Bug #58819 preload InnoDB buffer pool option

• Submitted: 8 Dec 2010 15:10
• Modified: 6 Oct 2011 23:55
• Reporter: Kyle Joiner
• Status: Closed
• Category: MySQL Server: InnoDB Plugin storage engine
• Severity: S4 (Feature request)
• Version: 5.1
• OS: Any
• Assigned to: Vasil Dimov
• CPU Architecture: Any
• Tags: innodb buffer pool, preload

[8 Dec 2010 15:10] Kyle Joiner

Description:
Request for an option to preload data from InnoDB tables into the InnoDB buffer pool at startup to increase initial startup performance.  Preferrably with a method to define what table or databases to preload.

How to repeat:
Restart MySQL and query InnoDB.  Initial query is slow.

Suggested fix:
Add feature

[8 Dec 2010 15:19] MySQL Verification Team

some 3rd party tips:
http://openquery.com/blog/cache-preloading-mysqld-startup
http://www.mysqlperformanceblog.com/2010/01/20/xtradb-feature-save-restore-buffer-pool/
http://provenscaling.com/blog/2008/10/06/making-mysql-more-usable-innodb-saverestore-buffe...

[23 Jun 2011 7:11] Vasil Dimov

Pushed in mysql-trunk under [e-mail]-20110623064848-cdjl7c0kg3z4b8vo, will be available in MySQL 5.6.3

[6 Oct 2011 23:55] John Russell

This feature is available now in the 5.6.3 development release.

http://dev.mysql.com/doc/refman/5.6/en/innodb-performance.html#innodb-preload-buffer-pool

http://dev.mysql.com/downloads/mysql/5.6.html