MySQL backups can be made in several ways. Each method has pro’s and con’s.
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.
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.
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.
In MySQL/MariaDB one has to use ALTER TABLE to set a table comment. This is a problem in many situations.
Invisible columns are columns that are not returned by a SELECT *. Their use cases are not obvious.
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.
Let’s use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter.
Relational DBMSs allow to grant users permissions on certain tables or columns. Here we’ll discuss how to restrict access to a certain set of rows.
MySQL supports replication filters and binlog filters. These features are powerful, but dangerous. Here you’ll find out the risks, and how to mitigate them.