You are here
InnoDB Buffer Pool Instances is too small
Thu, 2015-07-16 20:09 — Shinguz
If you are using MariaDB/MySQL 5.5 and newer you should use several InnoDB Buffer Pool Instances for performance reasons.
Some rules to size InnoDB Buffer Pool instances are:
- One InnoDB Buffer Pool Instance should be at least 1 Gibyte in size (
innodb_buffer_pool_size
/innodb_buffer_pool_instances
>= 1 Gib). - InnoDB Buffer Pool Instances you can set equal to the number of cores of your machine.
Taxonomy upgrade extras: