The optimal way to store a MD5 hashes in MariaDB, and how to work with them.
MariaDB supports regular expressions, but regexps won't use indexes. Here's a workaround that can be used in some cases.
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all ...
Some queries always fail or never return rows. They should be eliminated to improve database performance.
Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem.
Having many indexes in our databases comes with a cost. It is good to periodically eliminate duplicate and unused indexes.
MariaDB/MySQL replication filters may be useful, but they come with some risks that Database Administrators should be aware of.
An oversized InnoDB buffer pool will consume too many resources and can be slower than necessary. Let's see how to check if we can shrink it.