128 MB on a 32 GB machine: InnoDB buffer pool sizing in production
A MySQL 8.0 e-commerce with 32 GB RAM running on 128 MB buffer pool. How we diagnosed the issue, fixed it, and cut query latency from 45ms to 3ms.
Mysql
5 tagged articles
MySQL
MySQL
The 8:40 AM phone call: recovering a Galera Cluster when nodes fall one after another
A Galera 3-node cluster loses quorum during a live incident. Diagnosis, emergency bootstrap, and recovery procedure guided over the phone — with the runbook.
MySQL
The Monday morning report: four hours of MySQL replica lag
Four hours of lag on a MySQL replica in a logistics system. How we diagnosed it, why Seconds_Behind_Master lies, and what actually fixed it.
MySQL
The ticket said 'update MySQL and shut down the service'
A real MySQL 8.0.34→8.0.45 patching workflow: broken views blocking mysqldump, GTID warnings, replica role check, and RPM upgrade order on RHEL 8.
MySQL
Swap at 100% on InnoDB Cluster: when join_buffer_size multiplies the problem
A MySQL InnoDB Cluster grinding to a halt due to join_buffer_size set to 2 GB per thread. Diagnosis, rolling restart, and the math behind per-thread buffers.