InnoDB buffer pool is the most important memory area to allocate to get decent performance. Let’s see how to check if it’s big enough.
I’ve asked to remove Federico-Razzoli.com feed from Planet MySQL. Other well known members of the community did the same.
In MySQL/MariaDB one has to use ALTER TABLE to set a table comment. This is a problem in many situations.
MySQL logs slow queries into the Slow Log. But it’s preferable to log all the queries, not just some of them. This article shows how to log all available information.
Two weeks of live interviews to relevant database persons, starting from 4th May.