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所有
This patch provide the following new admin commands to control content of LRU through the information_schema..
- 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) ( 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部落格 ” ,連結:http://blog.itpub.net/7591490/viewspace-1031724/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL 引擎特性:InnoDB Buffer PoolMySql
- canvas save()和restore()CanvasREST
- MySQL入門--記憶體buffer poolMySql記憶體
- Innodb特性之Read-Ahead(Buffer Pool Prefetching)
- MySQL 5.7新特性之動態修改innodb_buffer_pool大小MySql
- mySQL5.6新特性快速預熱Buffer_Pool緩衝池MySql
- git restore極簡使用記錄GitREST
- SQL Server 2014新特性探祕(2)-SSD Buffer Pool ExtensionSQLServer
- 【BUFFER】Oracle buffer cache之 latch 學習記錄Oracle
- DOCKER特性 - LIVE RESTOREDockerREST
- 深入淺出buffer cache和shared pool記載01
- 深入淺出cache buffer和shared pool記載02
- 深入淺出buffer cache和shared pool記載03
- 【Mysql】讀書筆記之--innodb_buffer_pool記憶體的管理MySql筆記記憶體
- percona server5.6新功能記錄Server
- IPTABLES-SAVE手冊頁&IPTABLES-RESTORE手冊頁REST
- Percona 5.6 thread pool說明及使用thread
- MySQL innodb_buffer_pool_size 變數MySql變數
- 給從庫預熱innodb buffer pool
- mysql 5.5 -- innodb buffer pool最佳化MySql
- 計算innodb_buffer_pool使用率
- MySQL中讀頁緩衝區buffer poolMySql
- ubuntu 命令列更改innodb_buffer_pool_sizeUbuntu命令列
- 【Mysql】mysql快速預熱innodb_buffer_poolMySql
- MySQL監控InnoDB Buffer Pool命中率MySql
- Android 高階UI9 Canvas save和restore例項解析AndroidUICanvasREST
- Innodb特性之change buffer
- 關於BUFFER POOL的一些總結
- oracle實驗記錄 (buffer_cache分析(1))Oracle
- oracle實驗記錄 (oracle 分析shared pool(1))Oracle
- oracle實驗記錄 (oracle 分析shared pool(2))Oracle
- DB2上的hidded buffer pool的作用DB2
- MySQL 8.0 Reference Manual(讀書筆記72節--InnoDB Buffer Pool Configuration (3))MySql筆記
- MySQL 8.0 Reference Manual(讀書筆記71節--InnoDB Buffer Pool Configuration (2))MySql筆記
- MySQL 8.0 Reference Manual(讀書筆記70節--InnoDB Buffer Pool Configuration (1))MySql筆記
- MySQL怎麼緩解讀的壓力的?---buffer poolMySql
- vertex buffer 資料結構 如何讀vb的memory pool資料結構
- mysql引數之innodb_buffer_pool_size大小設定MySql