概述
Performance Schema 设置表提供了监测选项的信息以修改表中的数据来启用/禁用监测器. 设置表极大的提高了Performance Schema检测器配置的灵活性,例如可以通过一条语句完成多项配置.
设置表主要包含以下内容:
setup_actors setup_consumers setup_instruments setup_objects setup_timers
setup_actors
系统表介绍
setup_actors 用来配置监测的用户范围
| 列名 | 含义 |
|---|---|
| HOST | 主机IP |
| USER | 用户名 |
| ROLE | 角色 |
| ENABLED | 是否启用 |
| HISTORY | 是否记录历史事件 |
实例
mysql> select * from setup_actors ;+------+------+------+---------+---------+| HOST | USER | ROLE | ENABLED | HISTORY |+------+------+------+---------+---------+| % | % | % | YES | YES |+------+------+------+---------+---------+1 row in set (0.01 sec)
setup_consumers
系统表介绍
setup_consumers 用来配置监测事件的输出视图信息.
| 列名 | 含义 |
|---|---|
| NAME接收视图 | 事件 |
| ENABLED | 是否启用监控 |
实例
mysql> select * from setup_consumers ;+----------------------------------+---------+| NAME | ENABLED |+----------------------------------+---------+| events_stages_current | YES || events_stages_history | YES || events_stages_history_long | YES || events_statements_current | YES || events_statements_history | YES || events_statements_history_long | YES || events_transactions_current | YES || events_transactions_history | YES || events_transactions_history_long | YES || events_waits_current | YES || events_waits_history | YES || events_waits_history_long | YES || global_instrumentation | YES || thread_instrumentation | YES || statements_digest | YES |+----------------------------------+---------+15 rows in set (0.00 sec)
setup_instruments
系统表介绍
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)
setup_objects
系统表介绍
setup_objects 用以配置监测对象范围
| 列名 | 含义 |
|---|---|
| OBJECT_TYPE | 对象类型 |
| OBJECT_SCHEMA | 对象所属模式 |
| OBJECT_NAME | 对象名称 |
| ENABLED | 是否启用监测器 |
| TIMED | 是否计时 |
实例
mysql> select * from setup_objects ;+-------------+--------------------+-------------+---------+-------+| OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | ENABLED | TIMED |+-------------+--------------------+-------------+---------+-------+| EVENT | mysql | % | NO | NO || EVENT | performance_schema | % | NO | NO || EVENT | information_schema | % | NO | NO || EVENT | % | % | YES | YES || FUNCTION | mysql | % | NO | NO || FUNCTION | performance_schema | % | NO | NO || FUNCTION | information_schema | % | NO | NO || FUNCTION | % | % | YES | YES || PROCEDURE | mysql | % | NO | NO || PROCEDURE | performance_schema | % | NO | NO || PROCEDURE | information_schema | % | NO | NO || PROCEDURE | % | % | YES | YES || TABLE | mysql | % | NO | NO || TABLE | performance_schema | % | NO | NO || TABLE | information_schema | % | NO | NO || TABLE | % | % | YES | YES || TRIGGER | mysql | % | NO | NO || TRIGGER | performance_schema | % | NO | NO || TRIGGER | information_schema | % | NO | NO || TRIGGER | % | % | YES | YES |+-------------+--------------------+-------------+---------+-------+20 rows in set (0.01 sec)
setup_timers
系统表介绍
setup_timers 用以配置监测事件计时器类型
| 列名 | 含义 |
|---|---|
| NAME | 事件类型 |
| TIMER_NAME | 计时器类型 |
实例
mysql> select * from setup_timers ;+-------------+-------------+| NAME | TIMER_NAME |+-------------+-------------+| idle | MICROSECOND || wait | CYCLE || stage | NANOSECOND || statement | NANOSECOND || transaction | NANOSECOND |+-------------+-------------+5 rows in set, 1 warning (0.00 sec)
文章转载自数据小仙，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
