1. What it is about
This investigation began as a performance comparison for different memory allocators. However, during benchmarking, I discovered unexpected effects deserving a more detailed explanation. I hope you find these findings both interesting and useful.
Imagine you need to set up a MySQL database server. Every detail
is planned: the operating system, the CPU architecture, the
number of cores, the amount of RAM, the storage capacity and
speed. On paper the hardware looks like it can handle the
workload. But in reality, things rarely go exactly as planned.
So, conducting a thorough stress test is the next thing to
do.
2. Realities of stress testing
You configure your MySQL server setting the innodb_buffer_pool_size to 70-80% of your available RAM. This creates a large fast buffer for your data and indexes, reducing the need for slower disk input/output.
After …
[Read more]