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 (→Vettabase)
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 (→Vettabase)
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