SELECT (SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE WHERE PAGE_TYPE LIKE 'IBUF%') AS change_buffer_pages,
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE) AS total_pages,
(SELECT ((change_buffer_pages/total_pages)*100)) AS change_buffer_page_percentage;
+---------------------+-------------+-------------------------------+
| change_buffer_pages | total_pages | change_buffer_page_percentage |
+---------------------+-------------+-------------------------------+
| 3 | 8192 | 0.0366 |
+---------------------+-------------+-------------------------------+
1 row in set (0.06 sec)
mysql>
'MySQL' 카테고리의 다른 글
Innodb lock monitor (0) | 2021.07.12 |
---|---|
페이지 통합과 분할 (0) | 2021.07.12 |
Gap lock & Next key lock (0) | 2021.07.08 |
Lock mechanism in MySQL Internal (0) | 2021.07.05 |
MySQL8 bufferpool (버퍼풀) (0) | 2021.06.29 |