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. Continua a leggere Hints to optimise queries with a LIKE comparison
Archivio autore: 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. Continua a leggere 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. Continua a leggere 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. Continua a leggere 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. Continua a leggere 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. Continua a leggere 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. Continua a leggere 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. Continua a leggere 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. Continua a leggere A checklist for Database backup automation
MariaDB: WITH TIES syntax
Semantics and use cases of the WITH TIES syntax. Continua a leggere MariaDB: WITH TIES syntax