Buffer-Pool

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.