Embedded Files
Sensible Starting Sizes
Sensible Starting Sizes
If you don't yet know how big your MySQL Server should be, here are some sensible starting points...
Start with 16 GB RAM
(8 GB absolute minimum, 32 GB if the application is expected to grow or be latency-sensitive)In the absence of workload characteristics, a sensible starting point for a dedicated MySQL VM is 16 GB RAM. This allows an appropriately sized InnoDB buffer pool while leaving sufficient headroom for connection memory and OS overhead. The configuration can be adjusted once workload and dataset size are known.
Start with 4 cores/vCPUs
(2 vCPUs absolute minimum, 8 vCPUs if concurrency or growth is expected)For an initial deployment with unknown workload characteristics, 4 vCPUs is a reasonable starting point for a dedicated MySQL VM. This provides sufficient concurrency headroom without overprovisioning and can be scaled vertically if required once workload metrics are available.
Start with 50GB storage for /var/lib/mysql and /backup
(Preferably SSD/NVMe)Cookie Cutter Configs
Cookie Cutter Configs
CPU: 2RAM: 8Storage: SSD
Max Connections: 50-100
Suitable for:
Notes:
Max Connections: 50-100
Suitable for:
- Internal Tools
- Low-Traffic Apps
- PoC
- Non-Critical Workloads
Notes:
- Easy to starve if connections spike
- Avoid reporting queries
- Expect to resize
CPU: 4RAM: 16Storage: SSD/NVMe
Max Connections: 200-300
Suitable for:
Notes:
Max Connections: 200-300
Suitable for:
- Most production OLTP systems
- Line-of-business apps
- APIs and web backends
- Unknown or evolving workloads
Notes:
- Handles most OLTP workloads comfortably
- Good balance of memory and concurrency
- Excellent “cookie-cutter” default
CPU: 8RAM: 32Storage: NVMe
Max Connections: 500+
Suitable for:
Notes:
Max Connections: 500+
Suitable for:
- High-traffic OLTP
- Mixed OLTP + reporting
- Larger datasets
- Latency-sensitive systems
Notes:
- Still conservative on per-thread memory
- Beyond this size, query design and architecture matter more
- Consider replicas before going bigger
Bibliography
Bibliography
Page updated
Google Sites
Report abuse