# How to query innodb buffer pool usage?

**URL:** <https://forums.percona.com/t/how-to-query-innodb-buffer-pool-usage/21544>\
**Category:** PMM 2.x\
**Created:** [April 21, 2023, 6:22am UTC](https://forums.percona.com/t/how-to-query-innodb-buffer-pool-usage/21544 "2023-04-21T06:22:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shshwe2](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/shshwe2/32/10086_2.png) [@shshwe2](https://forums.percona.com/u/shshwe2)\
**Post date:** [April 21, 2023, 6:22am UTC](https://forums.percona.com/t/how-to-query-innodb-buffer-pool-usage/21544/1 "2023-04-21T06:22:42Z")

</div>

Hello.

mysql\> show status like ‘%innodb\_buffer\_pool%’;  
±--------------------------------------±---------------------------------------------------+  
| Variable\_name | Value |  
±--------------------------------------±---------------------------------------------------+  
| Innodb\_buffer\_pool\_dump\_status | Dumping of buffer pool not started |  
| Innodb\_buffer\_pool\_load\_status | Buffer pool(s) load completed at 220321 10:06:44 |  
| Innodb\_buffer\_pool\_resize\_status | Completed resizing buffer pool at 220321 13:47:00. |  
| Innodb\_buffer\_pool\_pages\_data | 77340 |  
| Innodb\_buffer\_pool\_bytes\_data | 1267138560 |  
| Innodb\_buffer\_pool\_pages\_dirty | 0 |  
| Innodb\_buffer\_pool\_bytes\_dirty | 0 |  
| Innodb\_buffer\_pool\_pages\_flushed | 114231 |  
| Innodb\_buffer\_pool\_pages\_free | 53386 |  
| Innodb\_buffer\_pool\_pages\_misc | 346 |  
| Innodb\_buffer\_pool\_pages\_total | 131072 |  
| Innodb\_buffer\_pool\_read\_ahead\_rnd | 0 |  
| Innodb\_buffer\_pool\_read\_ahead | 152 |  
| Innodb\_buffer\_pool\_read\_ahead\_evicted | 0 |  
| Innodb\_buffer\_pool\_read\_requests | 20730686 |  
| Innodb\_buffer\_pool\_reads | 3923 |  
| Innodb\_buffer\_pool\_wait\_free | 0 |  
| Innodb\_buffer\_pool\_write\_requests | 11708242 |  
±--------------------------------------±------------------------------------------

When show variable, it is being looked up like this.

To check innodb\_buffer\_pool usage

innodb\_buffer\_pool\_pages\_data / Innodb\_buffer\_pool\_pages\_total \* 100

I am trying to write  
nnodb\_buffer\_pool\_pages\_data and

Innodb\_buffer\_pool\_pages\_total  
Can’t find metrics for

pmm is version 2.36.

Is there any way to deal with it?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [April 21, 2023, 10:02pm UTC](https://forums.percona.com/t/how-to-query-innodb-buffer-pool-usage/21544/2 "2023-04-21T22:02:00Z")

</div>

Since you are using PMM, look at the buffer pool usage graphs. Search PMM for the ‘MySQL InnoDB Dashboard’ dashboard, and expand the section ‘InnoDB Buffer Pool’. If what you need is not there, please give more details as to what you are looking to add.