Plurrrr

Mon 08 Mar 2021

MicroOptimizing MySQL at scale

I’ll try to break this article down in 3 distinct areas (though, they can overlap a bit) – client, server and OS. The easiest optimizations for anyone to apply are probably query optimizations (client side). But we can also improve things directly on the MySQL server and even on the OS level. (All the things I write about here are MySQL with InnoDB, but they should be applicable to many other relational databases).

Source: MicroOptimizing MySQL at scale, an article by Aleksandar Ikonic.