PmaControl
Understanding the InnoDB Buffer Pool: a guide to performance tuning
How InnoDB caches pages, protects hot data, warms up after a restart and interacts with redo, the change buffer and the adaptive hash index.
Read article →
← All articles
Articles tagged innodb 3
When an Atomicity Fix Makes Ingestion 12% Faster
Making PmaControl's chunked time-series inserts atomic was expected to cost a little. The benchmark says otherwise: 12.5% faster ingestion. Here's why.
Read article →
MyISAM Is Deprecated: Time to Migrate
MyISAM is officially deprecated: the mysql system database and temporary tables have migrated. Why and how to abandon MyISAM for good.
Read article →