Hints to optimise queries with a LIKE comparison
Some queries with LIKE can’t use an index. However, here you can find some hints to optimise them. Continue reading Hints to optimise queries with a LIKE comparison
Author Archives: Federico Razzoli
A summary of MariaDB 10.9: Vault integration, innodb_log_file_size and more
Our review of MariaDB 10.9 version, released in August 2022. Continue reading A summary of MariaDB 10.9: Vault integration, innodb_log_file_size and more
A summary of MariaDB 10.8: key performance improvements
New features and performance optimisations in MariaDB 10.8 short term support release. Continue reading A summary of MariaDB 10.8: key performance improvements
3.6 millions MySQL servers accessible from the web. Hints to keep yours secure
Shadowserver has announced that they found over 3.6 million MySQL servers exposed to the web, following their Accessible MySQL Server Report. Continue reading 3.6 millions MySQL servers accessible from the web. Hints to keep yours secure
How to fix git mistakes
Code or configuration versioning comes with a potential problem: fixing mistakes can be tricky. Here are some solutions for the most common problems. Continue reading How to fix git mistakes
MariaDB/MySQL: Working with MD5 or other hashes
The optimal way to store a MD5 hashes in MariaDB, and how to work with them. Continue reading MariaDB/MySQL: Working with MD5 or other hashes
How to test database backups
Testing backups is often considered too expensive. But it is not, if the tests are adequately designed. Continue reading How to test database backups
MariaDB: The regexp + LIKE optimisation
MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases. Continue reading MariaDB: The regexp + LIKE optimisation
A checklist for Database backup automation
Databases and technical debts: here’s a list of requirements your database infrastructure should have. Continue reading A checklist for Database backup automation
MariaDB: WITH TIES syntax
Semantics and use cases of the WITH TIES syntax. Continue reading MariaDB: WITH TIES syntax