MySQL — Benchmarks
Scope
Performance characteristics, scaling limits, and resource consumption for MySQL.
sysbench Results
| Hardware |
Threads |
Read QPS |
Write QPS |
Read/Write QPS |
| 4 vCPU, 16Gi |
16 |
25,000 |
5,000 |
15,000 |
| 8 vCPU, 32Gi |
32 |
60,000 |
12,000 |
35,000 |
| 16 vCPU, 64Gi |
64 |
120,000 |
25,000 |
70,000 |
InnoDB Buffer Pool Efficiency
| Pool Size vs Data |
Read Hit Ratio |
Random I/O |
| Pool > Data |
> 99.9% |
Minimal |
| Pool = 50% Data |
95-99% |
Moderate |
| Pool = 10% Data |
60-80% |
Heavy |
Group Replication
| Metric |
3 nodes |
5 nodes |
9 nodes |
| Certification latency |
< 1ms |
1-2ms |
2-5ms |
| Write throughput |
90% of standalone |
80% |
70% |
| Failover time |
5-30s |
5-30s |
10-60s |
Scaling Limits
| Dimension |
Limit |
Notes |
| Table size |
1TB comfortable |
Partition beyond 100M rows |
| Concurrent connections |
150,000 (max) |
Use connection pooling |
| Queries/sec |
100k+ point reads |
Depends on working set vs RAM |