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.
Foreign keys are a controversial topic. MySQL and MariaDB implementation has several bugs and limitations, that are discussed here.
MySQL transactions can be read only. Here’s how to use them, and why they are useful.
In MySQL and MariaDB, all tables should have a primary key – especially InnoDB tables – this is almost common wisdom. But why? Let’s discuss the reasons.
When creating indexes, some common mistakes should be avoided.
How primary key are implemented in InnoDB, and how to build fast primary keys.