Aikesheng Open Source Community
Aug 17, 2020 · Databases
How Many innodb_buffer_pool_instances Do You Need in MySQL 8?
Using sysbench oltp_read_write benchmarks on a 100 GB database with a 25 GB buffer pool, this article evaluates the impact of varying innodb_buffer_pool_instances (1, 2, 4, 8, 16, 32, 64) on throughput and variability, concluding that 64 instances yields the highest performance.
MySQLSysbenchinnodb_buffer_pool_instances
0 likes · 7 min read