percona save/restore buffer pool特性记录
作者: 弦乐之花 | 可以转载, 但必须以超链接形式标明文章原始出处和作者信息及版权声明
链接：http://shiri512003.itpub.net/post/37713/497336
[@more@]以前一篇文章提到关于percona提供的 save / restore buffer pool 特性(http://shiri512003.itpub.net/post/37713/497158)，这个特性可以快速hot系统，着实是个不错的idea，这个特性暂时还没有被innodb plugin引入，因为这个特性是plugin最新版本1.0.6之后发布的啦，不过percona xtradb-1.0.6-9 based innodb plugin 1.0.6已经包含了这个补丁了。这里记录下关于这个特性使用的详细说明。
注：以下内容版权归percona所有
http://www.percona.com/docs/wiki/percona-xtradb:patch:innodb_lru_dump_restore#xtra_lru_dump
innodb_lru_dump_restore
Description
This patch provide the following new admin commands to control content of LRU through the information_schema. XTRADB_ADMIN_COMMAND.
- XTRA_LRU_DUMP : Dump the content of buffer pool (list of space_id and page_no) to the specific file 'ib_lru_dump' at datadir.
- XTRA_LRU_RESTORE : Read pages based on the 'ib_lru_dump' file.
command lines
....(startup).... mysql> show status like 'Innodb_buffer_pool_pages_data'; +-------------------------------+-------+ | Variable_name | Value | +-------------------------------+-------+ | Innodb_buffer_pool_pages_data | 18 | +-------------------------------+-------+ 1 row in set (0.00 sec) ....(run workloads).... mysql> show status like 'Innodb_buffer_pool_pages_data'; +-------------------------------+-------+ | Variable_name | Value | +-------------------------------+-------+ | Innodb_buffer_pool_pages_data | 6231 | +-------------------------------+-------+ 1 row in set (0.01 sec) mysql> select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_LRU_DUMP*/; +------------------------------+ | result_message | +------------------------------+ | XTRA_LRU_DUMP was succeeded. | +------------------------------+ 1 row in set (0.02 sec) ....(restart mysqld).... mysql> show status like 'Innodb_buffer_pool_pages_data'; +-------------------------------+-------+ | Variable_name | Value | +-------------------------------+-------+ | Innodb_buffer_pool_pages_data | 22 | +-------------------------------+-------+ 1 row in set (0.00 sec) mysql> select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_LRU_RESTORE*/; +---------------------------------+ | result_message | +---------------------------------+ | XTRA_LRU_RESTORE was succeeded. | +---------------------------------+ 1 row in set (0.62 sec) (<--- * It is fast, because it doesn't use direct_io...) mysql> show status like 'Innodb_buffer_pool_pages_data'; +-------------------------------+-------+ | Variable_name | Value | +-------------------------------+-------+ | Innodb_buffer_pool_pages_data | 6231 | +-------------------------------+-------+ 1 row in set (0.00 sec)
.err file
.... 091217 11:49:16 InnoDB: administration command 'XTRA_LRU_DUMP' was detected. .... 091217 11:51:44 InnoDB: administration command 'XTRA_LRU_RESTORE' was detected. 091217 11:51:45 InnoDB: reading pages based on the dumped LRU list was done. (requested: 6231, read: 6209)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7591490/viewspace-1031724/ ，如需转载，请注明出处，否则将追究法律责任。
