Some queries always fail or never return rows. They should be eliminated to improve database performance.
MariaDB
Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem.
MariaDB 10.6 is now Generally Available! Let's see what's new and if it's worth an upgrade.
Ignored Index are a MariaDB 10.6 feature that allows us to drop an index in production reducing the risks.
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.
Vettabase is a MariaDB Foundation partner. We contributed documentation about automating MariaDB deployments and configuration management.
Aria pagecache is used to cache frequently read index blocks, reducing the accesses to disks. Let's see how to check if its size is adequate.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.