Tag - InnoDB buffer pool size

19 Jun 2018

InnoDB Buffer Pool Resizing: Chunk Change

By David Ducos Insight for DBAs, MySQL , , , , , , 2 Comments
InnoDB Buffer Pool

Since MySQL 5.7.5, we have been able to resize dynamically the InnoDB Buffer Pool. This new feature also introduced a new variable — innodb_buffer_pool_chunk_size — which defines the chunk size by which the buffer pool is enlarged or reduced. This variable is not dynamic and if it is incorrectly configured, could lead to undesired […]

Read more
01 Jul 2013

tpcc-mysql: Simple usage steps and how to build graphs with gnuplot

By Michael Rikmas Benchmarks, Percona Software , , , 11 Comments

Lots of times we could see different benchmarks performed by tpcc-mysql. So today I want to tell you about how to use tpcc-mysql and how to build graphs with gnuplot in a few easy steps.
As an example I’ll compare Percona Server 5.5 (latest version: 5.5.31) performance by changing InnoDB buffer pool size: innodb_buffer_pool_size = […]

Read more

Upcoming Webinars

All Webinars »


MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners. Proudly running Percona Server for MySQL. Copyright © 2006-2019 Percona LLC.

Terms of Use | Privacy | Copyright | Legal