Open1
MySQL InnoDBバッファプール
mysql> SHOW GLOBAL STATUS LIKE 'InnoDB\_buffer\_pool%';
mysql> SHOW GLOBAL STATUS LIKE 'Innodb\_pages%';
パッファープールヒット率 =
(1 - ( Innodb_buffer_pool_reads / Innodb_buffer_pool_read_requests )) * 100
mysql> SHOW GLOBAL STATUS LIKE 'InnoDB\_buffer\_pool%';
mysql> SHOW GLOBAL STATUS LIKE 'Innodb\_pages%';
パッファープールヒット率 =
(1 - ( Innodb_buffer_pool_reads / Innodb_buffer_pool_read_requests )) * 100