setup_instruments 详解

Posted by 道行尚浅 on August 5, 2021

系统表介绍

setup_instruments 用以配置监测事件范围

列名 | 含义 —|— NAME | 事件名称
ENABLED | 是否启用监测器 TIMED | 是否启用计时器

实例


mysql> select * from setup_instruments  limit 5 ; 
+-------------------------------------------------------+---------+-------+
| NAME                                                  | ENABLED | TIMED |
+-------------------------------------------------------+---------+-------+
| wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_tc             | YES     | YES   |
| wait/synch/mutex/sql/LOCK_des_key_file                | YES     | YES   |
| wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_commit       | YES     | YES   |
| wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_commit_queue | YES     | YES   |
| wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_done         | YES     | YES   |
+-------------------------------------------------------+---------+-------+
5 rows in set (0.00 sec)