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.
Read moreAbout Planet MySQL
I’ve asked to remove Federico-Razzoli.com feed from Planet MySQL. Other well known members of the community did the same.
Read moreMySQL danger: comments and ALTER TABLE
In MySQL/MariaDB one has to use ALTER TABLE to set a table comment. This is a problem in many situations.
Read moreLogging all MySQL queries into the Slow Log (→Vettabase)
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.
Read moreTwo Weeks of Databases
Two weeks of live interviews to relevant database persons, starting from 4th May.
Read more