MySQL

How to confirm the usage of change buffer (체인지 버퍼 사용량 확인방법)

lejpower 2021. 6. 29. 15:08
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