… and in turn, load that data into and pollute the buffer pool. Note that this can be somewhat mitigated using innodb_old… operation (redo logs, binlogs, etc) as well further polluting the buffer pool. Enter Xtrabackup… As a quick refresher, Xtrabackup works by copying… the same server. This will allow you to compare and restore values (potentially corrupted via user error or other issues) with…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… server does not process query traffic except for replication. The buffer pool and adaptive hash index on the standby server will not… would be heavily I/O bound after failover as the buffer pool pages were loaded from disk. Replaying Queries Working with Groupon… with slow query logs captured from our production systems. We restored a production database backup to our test database so that…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it is copied back to data directory. After the backup is restored buffer pool dump can be loaded by…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it is copied back to data directory. After the backup is restored buffer pool dump can be loaded by…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… these versions are are recognized by XtraBackup, and that backup/restore works as long as no 5.6-specific features are… GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup can use XtraDB changed page tracking…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 20 Comments
…_restore (Yasufumi names it LRU dump/restore, because he thinks about buffer pool as about LRU list, which how it is internally). To save buffer pool….6 I made small tpcc benchmark to show effect with restored buffer_pool (the condition of benchmarks are the same as in my… and ran it for 1h. After that I saved buffer_pool, restarted mysqld, restored buffer_pool ( it took about 4 min to load 26GB worth…
Comment: Percona Server 5.5.16-22.0
October 17, 2011 By 2 Comments
…-buffer-pool-restore (to be consistent with innodb-buffer-pool-restore-at-startup).” Just checked 5.5.16 on our test machine with the innodb-blocking-buffer-pool-restore directive: mysqld: 111017 10:13:12 InnoDB: Restoring buffer pool pages from ib_lru_dump So…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… to the buffer pool. A benchmark is worth a thousand words, so let’s repeat the last test with innodb_buffer_pool_sizeset to… | 19.805849 | | restoring secondary keys | 53.885502 | . . . +——————————+———–+ 19 rows in set (0.00 sec) So, as expected, a small buffer pool had a…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
….4 milestone at Launchpad. Improvements SHM Buffer Pool has been replaced with LRU Dump/Restore The ”SHM” buffer pool patch, which provided the ability to use a shared memory segment for the buffer pool to enable…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum) if used. Instructions for disabling the SHM buffer pool can be found here and for setting up LRU dump/restore…
