Tag

innodb_buffer_pool_instances

1 views collected around this technical thread.

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.

MySQLbenchmarkinnodb_buffer_pool_instances

0 likes · 7 min read

How Many innodb_buffer_pool_instances Do You Need in MySQL 8?

Aikesheng Open Source Community

Apr 10, 2020 · Databases

Observing the Performance Impact of innodb_buffer_pool_instances in MySQL

This article demonstrates a step‑by‑step experiment using sysbench and performance_schema to measure how different values of innodb_buffer_pool_instances affect buffer‑pool lock latency, analyzes the collected data, and discusses the observed trends and limitations.

MySQLPerformance Schemainnodb_buffer_pool_instances

0 likes · 5 min read

Observing the Performance Impact of innodb_buffer_pool_instances in MySQL