MariaDB made several improvements to the DROP TABLE statement.
Read moreMariaDB RETURNING Statements (→Vettabase)
MariaDB supports INSERT RETURNING and DELETE RETURNING, which help avoid an additional SELECT.
Read moreMySQL backup methods comparison
MySQL backups can be made in several ways. Each method has pro’s and con’s.
Read moreSizing Aria Pagecache (→Vettabase)
Aria is a MariaDB storage engine that is always used internally. Its pagecache is the equivalent of InnoDB buffer pool, and this article is about sizing it properly.
Read moreCan we shrink InnoDB Buffer Pool? (→Vettabase)
It’s not easy to find out if InnoDB Buffer Pool is oversized. However shrinking it could greatly reduce the resources we need and pay, and even improve performance.
Read moreIs InnoDB Buffer Pool big enough? (→Vettabase)
InnoDB buffer pool is the most important memory area to allocate to get decent performance. Let’s see how to check if it’s big enough.
Read moreMySQL danger: comments and ALTER TABLE
In MySQL/MariaDB one has to use ALTER TABLE to set a table comment. This is a problem in many situations.
Read moreLogging all MySQL queries into the Slow Log (→Vettabase)
MySQL logs slow queries into the Slow Log. But it’s preferable to log all the queries, not just some of them. This article shows how to log all available information.
Read moreUse cases for MariaDB Invisible Columns
Invisible columns are columns that are not returned by a SELECT *. Their use cases are not obvious.
Read morePractical advice for MySQL/MariaDB live migrations
Modifying table structures is sometimes necessary, or desirable. Modifying them online can be a pain, especially with big tables. Migrations should be ran properly in production.
Read more