Warming the InnoDB cache

The following stored procedures save, load, or cancel loading the InnoDB buffer pool on RDS for MySQL DB instances. For more information, see InnoDB cache warming for MySQL on Amazon RDS.

mysql.rds_innodb_buffer_pool_dump_now

Dumps the current state of the buffer pool to disk.

Syntax

CALL mysql.rds_innodb_buffer_pool_dump_now();

Usage notes

The master user must run the mysql.rds_innodb_buffer_pool_dump_now procedure.

mysql.rds_innodb_buffer_pool_load_abort

Cancels a load of the saved buffer pool state while in progress.

Syntax

CALL mysql.rds_innodb_buffer_pool_load_abort();

Usage notes

The master user must run the mysql.rds_innodb_buffer_pool_load_abort procedure.

mysql.rds_innodb_buffer_pool_load_now

Loads the saved state of the buffer pool from disk.

Syntax

CALL mysql.rds_innodb_buffer_pool_load_now();

Usage notes

The master user must run the mysql.rds_innodb_buffer_pool_load_now procedure.