content_image/807085.jpg
•You can configure how InnoDB  preserves the current buffer pool state to avoid a lengthy warmup period after a server restart. For details, see Section 15.8.3.6, “Saving and Restoring the Buffer Pool State” . 

## Monitoring the Buffer Pool Using the InnoDB Standard Monitor 

InnoDB  Standard Monitor output, which can be accessed using SHOW ENGINE INNODB STATUS , provides metrics regarding operation of the buffer pool. Buffer pool metrics are located in the BUFFER POOL AND MEMORY  section of InnoDB  Standard Monitor output: 

---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 2198863872 Dictionary memory allocated 776332 Buffer pool size 131072 Free buffers 124908 Database pages 5720 Old database pages 2071 Modified db pages 910 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4, not young 0 0.10 youngs/s, 0.00 non-youngs/s Pages read 197, created 5523, written 5060 0.00 reads/s, 190.89 creates/s, 244.94 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 5720, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] 

The following table describes buffer pool metrics reported by the InnoDB  Standard Monitor. 

Per second averages provided in InnoDB  Standard Monitor output are based on the elapsed time since InnoDB  Standard Monitor output was last printed. 

<img src='content_image/807085.jpg'>

