DEV Community

#mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
How We Evolved a Cultural Recommendation Feed From a Weighted SQL Ranker to a Narrative Affinity Model
sampseiol1 profile

How We Evolved a Cultural Recommendation Feed From a Weighted SQL Ranker to a Narrative Affinity Model

#php #mysql #algorithms #softwareengineering
Comments
6 min read
Build a Maintainable Node.js CRUD API with Express and MySQL
blogs_world profile

Build a Maintainable Node.js CRUD API with Express and MySQL

#node #express #mysql #webdev
Comments
9 min read
WordPress Sitewide Outages: Which Misconfigurations Actually Cause Them, Ranked by Frequency and Recovery Time
john_182319291 profile
John

WordPress Sitewide Outages: Which Misconfigurations Actually Cause Them, Ranked by Frequency and Recovery Time

#wordpress #selfhosting #php #mysql
Comments
14 min read
The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem
mahmut_gndzalp_c736ac4b profile

The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem

#mysql #performance #database #webdev
5
Comments
6 min read
Understanding Two-Phase Commit (2PC) by Building One in Go
ankitmalikg profile

Understanding Two-Phase Commit (2PC) by Building One in Go

#go #mysql #postgres #distributedsystems
Comments
11 min read
One '%' Cost Us 53 Seconds: A Redis, MySQL Buffer Pool Story
yogendra_singh_9737a86e38 profile

One '%' Cost Us 53 Seconds: A Redis, MySQL Buffer Pool Story

#database #mysql #performance #redis
Comments
3 min read
SQL 里时间戳的 4 个真坑 + 用 tsforge-mcp 在 LLM 里直接算
caresodev profile
tine

SQL 里时间戳的 4 个真坑 + 用 tsforge-mcp 在 LLM 里直接算

#sql #database #mysql #tutorial
Comments
1 min read
Atomic Money: Making a PHP/MySQL Wallet Safe Under Concurrency
amc_animarcelinus_b4a718 profile

Atomic Money: Making a PHP/MySQL Wallet Safe Under Concurrency

#php #mysql #fintech #database
1
Comments
5 min read
I built a free portable tool to import huge MySQL dumps on Windows (9GB+ tested) — with real-time progress
muhammad_suleman_095 profile

I built a free portable tool to import huge MySQL dumps on Windows (9GB+ tested) — with real-time progress

#mysql #opensource #database
Comments
1 min read
Track MySQL LTS Updates with Renovate
catatsuy profile

Track MySQL LTS Updates with Renovate

#renovate #mysql #docker #devops
Comments
4 min read
Introducing HakPoint: A Modular Enterprise Management Platform Built with PHP and MySQL
hakkache_hamza profile

Introducing HakPoint: A Modular Enterprise Management Platform Built with PHP and MySQL

#backend #mysql #php #softwaredevelopment
Comments
2 min read
Getting Started on MOCO Part 2: Backup and Restore to MinIO (and the davfs2 Bug That Broke It)
mucheru profile

Getting Started on MOCO Part 2: Backup and Restore to MinIO (and the davfs2 Bug That Broke It)

#kubernetes #mysql #moco #devops
Comments
8 min read
MySQL Optimization Strategies for Large-Scale Applications
software_solutions_740799 profile

MySQL Optimization Strategies for Large-Scale Applications

#mysql #database #backend #webdev
Comments
4 min read
Magento 2 Database Table Partitioning & Archiving Strategies
magevanta profile

Magento 2 Database Table Partitioning & Archiving Strategies

#magento #mysql #database #performance
Comments
6 min read
Magento 2 MySQL Read/Write Replication Splitting: Scale Your Database Horizontally
magevanta profile

Magento 2 MySQL Read/Write Replication Splitting: Scale Your Database Horizontally

#magento2 #performance #mysql #database
1
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.