BestHub
Sign in
Tag

innodb_buffer_pool_instances

0 views collected around this technical thread.

Aikesheng Open Source Community
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.

MySQLPerformance Tuningbenchmark
0 likes · 7 min read
How Many innodb_buffer_pool_instances Do You Need in MySQL 8?
Aikesheng Open Source Community
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