Search Results - comment: innodb free: 0 kb

Tuning InnoDB Primary Keys

The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing the best primary key depending on your workload.
As a principal architect at Percona, one of my main duties is to tune customer databases. There are many aspects related to performance tuning […]

Read more

How To Best Use Percona Server Column Compression With Dictionary

Database Compression

Very often, database performance is affected by the inability to cache all the required data in memory. Disk IO, even when using the fastest devices, takes much more time than a memory access. With MySQL/InnoDB, the main memory cache is the InnoDB buffer pool. There are many strategies we can try to fit as […]

Read more