How to query innodb buffer pool usage?

Percona Monitoring and Management (PMM) PMM 2.x
1

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?

2

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.