系统表介绍
events_statements_history反映了语句包含的事件。为每个线程保留的行数受参数performance_schema_events_statements_history_size控制。
列名 | 含义 |
---|---|
THREAD_ID | 线程编号 |
EVENT_ID | 事件编号 |
END_EVENT_ID | 阶段结束事件ID 当事件结束后,发生启动修改线程当前事件号时置为空 |
EVENT_NAME | 事件名称 |
SOURCE | 包含监测器的源码文件 |
TIMER_START | 事件启动的时间 |
TIMER_END | 事件结束的时间 |
TIMER_WAIT | 事件持续时长 TIMER_END-TIMER_START 单位是皮秒 百万分之一微秒 |
LOCK_TIME | 锁等待事件 (微秒) |
SQL_TEXT | SQL文本 |
DIGEST | 概要 |
DIGEST_TEXT | 概要文本 |
CURRENT_SCHEMA | 当前模式 |
OBJECT_TYPE | 嵌套语句(存储过程类型) |
OBJECT_SCHEMA | 嵌套语句(存储过程所属模式) |
OBJECT_NAME | 嵌套语句(存储过程名称) |
OBJECT_INSTANCE_BEGIN | 对象的内存地址 |
MYSQL_ERRNO | 语句错误编号 |
RETURNED_SQLSTATE | 语句SQLSTATE 值 |
MESSAGE_TEXT | 报错信息 |
ERRORS | 报错标志(如SQLSTAT以00、01开头值为0 ,其他值为1 ) |
WARNINGS | 警告数量 |
ROWS_AFFECTED | 涉及的行数 |
ROWS_SENT | 语句返回行数 |
ROWS_EXAMINED | 在server层检查的行数(不包含在内部存储影响处理的数量) |
CREATED_TMP_DISK_TABLES | 内部创建磁盘临时表的数量 |
CREATED_TMP_TABLES | 内部创建临时表的数量 |
SELECT_FULL_JOIN | 由于没有索引引起全表连接的数量 |
SELECT_FULL_RANGE_JOIN | 在引用表发生大范围扫描的次数 |
SELECT_RANGE | 在初始表使用范围方式获取记录的次数 |
SELECT_RANGE_CHECK | 判断是否要使用范围扫描的次数 |
SELECT_SCAN | 全表扫描次数 |
SORT_MERGE_PASSES | 再排序次数 |
SORT_RANGE | 范围扫描时按顺序读取记录的次数 |
SORT_ROWS | 排序的行数 |
SORT_SCAN | 全表扫描是按顺序读取的次数 |
NO_INDEX_USED | 标识是否使用索引 1 未使用 其他 0 |
NO_GOOD_INDEX_USED | 标识是否使用好的索引 1 使用 其他 0 |
NESTING_EVENT_ID | 父语句事件编号 |
NESTING_EVENT_TYPE | 父事件类型 |
NESTING_EVENT_LEVEL | 嵌套级别 |
实例
mysql> select * from events_statements_history ;
+-----------+----------+--------------+------------------------------+--------+----------------------+----------------------+------------+------------+-------------------------------------------------------------------------+----------------------------------+--------------------------------------------+--------------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+
| THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | LOCK_TIME | SQL_TEXT | DIGEST | DIGEST_TEXT | CURRENT_SCHEMA | OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | OBJECT_INSTANCE_BEGIN | MYSQL_ERRNO | RETURNED_SQLSTATE | MESSAGE_TEXT | ERRORS | WARNINGS | ROWS_AFFECTED | ROWS_SENT | ROWS_EXAMINED | CREATED_TMP_DISK_TABLES | CREATED_TMP_TABLES | SELECT_FULL_JOIN | SELECT_FULL_RANGE_JOIN | SELECT_RANGE | SELECT_RANGE_CHECK | SELECT_SCAN | SORT_MERGE_PASSES | SORT_RANGE | SORT_ROWS | SORT_SCAN | NO_INDEX_USED | NO_GOOD_INDEX_USED | NESTING_EVENT_ID | NESTING_EVENT_TYPE | NESTING_EVENT_LEVEL |
+-----------+----------+--------------+------------------------------+--------+----------------------+----------------------+------------+------------+-------------------------------------------------------------------------+----------------------------------+--------------------------------------------+--------------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+
| 364 | 1841 | 1858 | statement/com/Field List | | 12449143435914006000 | 12449143436071635000 | 157629000 | 0 | NULL | NULL | NULL | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 |
| 364 | 1861 | 1878 | statement/com/Field List | | 12449143439338060000 | 12449143439432663000 | 94603000 | 0 | NULL | NULL | NULL | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 |
| 364 | 1881 | 1898 | statement/com/Field List | | 12449143440167391000 | 12449143440270650000 | 103259000 | 0 | NULL | NULL | NULL | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 |
| 364 | 1901 | 1918 | statement/com/Field List | | 12449143440886590000 | 12449143441579299000 | 692709000 | 0 | NULL | NULL | NULL | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 |
| 364 | 1921 | 2137 | statement/sql/show_fields | | 12449243704483786000 | 12449243711425448000 | 6941662000 | 5761000000 | desc events_statements_current | ef1f054841548f4b27bfae7968e389f3 | DESC `events_statements_current` | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 41 | 41 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 |
| 364 | 2140 | 2172 | statement/sql/show_variables | | 12462438356580651000 | 12462438357689627000 | 1108976000 | 454000000 | show variables like 'performance_schema_events_statements_history_size' | 6909bda371af7c36751d55c3ca80a467 | SHOW VARIABLES LIKE ? | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 |
| 364 | 2175 | 2207 | statement/sql/select | | 12462524333565264000 | 12462524335592502000 | 2027238000 | 866000000 | select *from events_statements_current | 90e76d5b2feeed538b321a76a4ce9d7a | SELECT * FROM `events_statements_current` | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 |
| 364 | 1783 | 1798 | statement/com/Field List | | 12449143396800438000 | 12449143397515081000 | 714643000 | 0 | NULL | NULL | NULL | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 |
| 364 | 1801 | 1818 | statement/com/Field List | | 12449143405715525000 | 12449143406372683000 | 657158000 | 0 | NULL | NULL | NULL | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 |
| 364 | 1821 | 1838 | statement/com/Field List | | 12449143412750472000 | 12449143413074539000 | 324067000 | 0 | NULL | NULL | NULL | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 |
+-----------+----------+--------------+------------------------------+--------+----------------------+----------------------+------------+------------+-------------------------------------------------------------------------+----------------------------------+--------------------------------------------+--------------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+
10 rows in set (0.00 sec)
mysql> show variables like 'performance_schema_events_statements_history_size' ;
+---------------------------------------------------+-------+
| Variable_name | Value |
+---------------------------------------------------+-------+
| performance_schema_events_statements_history_size | 10 |
+---------------------------------------------------+-------+
1 row in set (0.00 sec)