mysql innodb_sort_buffer_size_mysql优化---第7篇：参数 innodb_buffer_pool_instances设置

摘要：1 innodb_buffer_pool_instances可以开启多个内存缓冲池，把需要缓冲的数据hash到不同的缓冲池中，这样可以并行的内存读写。

2 innodb_buffer_pool_instances参数显著的影响测试结果，特别是非常高的 I/O 负载时。

3 实验环境下，innodb_buffer_pool_instances=8在很小的 buffer_pool 大小时有很大的不同，而使用大的

buffer_pool 时，innodb_buffer_pool_instances=1的表现最棒。

1 定义

The number of regions that the InnoDB buffer

pool is divided into. For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve concurrency, by reducing contention as different threads read and write to cached pages. Each page that is stored

in or read from the buffer pool is assigned to one of the buffer pool instances randomly, using a hashing function. Each buffer pool manages its own free lists, flush lists, LRUs, and all other data structures connected to a buffer pool, and is protected by

its own buffer pool mutex.

This option t