You are here

Home

buffer pool

How to force InnoDB Buffer Pool flushing

Thu, 2020-12-10 17:38 — Shinguz
Taxonomy upgrade extras: 
innodb
buffer pool
flushing
meb
MySQL Enterprise Backup
Backup

InnoDB tries to keep pages in Buffer Pool to be fast. If a page is changed by a DML statement (INSERT, UPDATE, DELETE) this change will be done in InnoDB Buffer Pool and not directly on disk. But those changed InnoDB pages residing in InnoDB Buffer Pool must be flushed sooner or later to disk to become persistent. This is done by the InnoDB background writer thread(s) (default 4).

Understanding InnoDB - Buffer Pool Flushing

InnoDB Page Cleaner Thread

The InnoDB Page Cleaner Thread is an InnoDB background thread that flushes dirty pages from the InnoDB Buffer Pool to disk. Prior MySQL 5.6 this action was performed by the InnoDB Master Thread.

Undefined
tags: 
innodb
ssd
hdd
buffer pool
flush
page cleaner

InnoDB Buffer Pool Instances is too small

Thu, 2015-07-16 20:09 — Shinguz
Taxonomy upgrade extras: 
fpmmm Triggers and Rules
innodb
buffer pool
configuration
parameter
variables

If you are using MariaDB/MySQL 5.5 and newer you should use several InnoDB Buffer Pool Instances for performance reasons.
Some rules to size InnoDB Buffer Pool instances are:

  • One InnoDB Buffer Pool Instance should be at least 1 Gibyte in size (innodb_buffer_pool_size / innodb_buffer_pool_instances >= 1 Gib).
  • InnoDB Buffer Pool Instances you can set equal to the number of cores of your machine.

Warming up the InnoDB Buffer Pool during start-up

Fri, 2011-07-22 17:12 — Shinguz
Taxonomy upgrade extras: 
english
innodb
buffer pool
warm-up
start-up

Abstract: Heating up the InnoDB Buffer Pool during the MySQL instance startup should significantly improve InnoDB Performance in the beginning of the life of the Instance. This is achieved by sequential scans of the needed data instead of random I/O reads which would happen when we just let the system work it out by itself.
How to find the database objects which can be loaded during MySQL start-up and how to load them automatically is described in this article.

Subscribe to RSS - buffer pool