O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

innodb_buffer_pool_instances

You can divided the InnoDB buffer pool into separate regions to improve concurrency, by reducing contention as different threads read and write to cached pages. For example, if the buffer pool size is 64 GB and innodb_buffer_pool_instances are 32, the buffer is split into 32 regions with 2 GB each.

If the buffer pool size is more than 16 GB, you can set the instances so that each region gets at least 1 GB of space.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required