On 5 May 2020, GitHub had a 2 hours and 24 minutes downtime caused by AUTO_INCREMENT values. Let’s see how to avoid these incidents.
Read moreCase sensitivity in MySQL and MariaDB queries
Maybe you’re wondering why in MySQL/MariaDB ‘string’ seems to be the same as ‘STRING’. Or maybe that’s not the case for you, but you would like to make a case insensitive search. This article explains how to write a case …
Read moreDropping useless MySQL indexes
How to find useless indexes and get rid of them to improve your database performance.
Read moreInnoDB Indexes Bad Practices
When creating indexes, some common mistakes should be avoided.
Read moreDropping database objects in a safe way
Whenever I worked as a DBA, I was reasonably scared by 💧DROP commands. Don’t get me wrong: despite this, I badly wanted to drop obsolete tables. After that, I could more easily ask developers to fix bad practices, like tables …
Read moreMySQL: IS NULL conditions and indexes
It is quite common to use an equality condition and an IS NULL condition on the same columns. Unfortunately, this could make queries very slow.
Read more