MySQL Optimize

MySQL Tuner

innodb_buffer_pool_size

On a server with 32 GB RAM, set

Having more innodb_buffer_pool_size, make MySQL act like an in memory database.

innodb_buffer_pool_instances divide buffer pool into smaller instances. It is better use 1 GB per instance.

To see current innodb_buffer_pool values, run

MySQL InnoDB Optimise

See MySQL