[MySQL 5.6] information_schema.innodb_metrics
1. 概括
已关闭/打开的配置
use information_schema select count(*), status from innodb_metrics group by status; +----------+----------+ | count(*) | status | +----------+----------+ | 170 | disabled | | 65 | enabled | +----------+----------+
模块
select count(*), subsystem from innodb_metrics group by subsystem; +----------+---------------------+ | count(*) | subsystem | +----------+---------------------+ | 8 | adaptive_hash_index | | 75 | buffer | | 32 | buffer_page_io | | 8 | change_buffer | | 4 | compression | | 6 | ddl | | 4 | dml | | 1 | file_system | | 4 | icp | | 6 | index | | 16 | lock | | 3 | metadata | | 9 | os | | 7 | purge | | 15 | recovery | | 25 | server | | 12 | transaction | +----------+---------------------+ 17 rows in set (0.00 sec)
模块名与subsystem的对应关系:
设置监控变量
mysql> show variables like "%monitor%";
+————————–+——-+
| Variable_name | Value |
+————————–+——-+
| innodb_monitor_disable | |
| innodb_monitor_enable | |
| innodb_monitor_reset | |
| innodb_monitor_reset_all | |
+————————–+——-+
4 rows in set (0.00 sec)
打开/关闭计数器:
mysql> set global innodb_monitor_enable = "adaptive_hash_%";
mysql> set global innodb_monitor_disable = "adaptive_hash_%";
重置值:
mysql> set global innodb_monitor_reset_all = "adaptive_hash_%";
mysql> set global innodb_monitor_reset = "adaptive_hash_%";
查看模块信息
SELECT * FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem="transaction";