events_statements_stages_agg_current
简介
添加performance_schema.events_statements_stages_agg_current，基于event state，统计session 最近执行语句的stage累计信息。
表信息
表结构详情
| 字段名 | 类型 | 说明 |
|---|---|---|
| THREAD_ID | bigint unsigned | 线程的thread id |
| EVENT_NAME | varchar(128) | 事件名 |
| EVENT_ID | bigint unsigned | 事件ID |
| COUNT_STAR | bigint unsigned | 统计次数 |
| SUM_TIMER_WAIT | bigint unsigned | 事件总共消耗时间 |
| MIN_TIMER_WAIT | bigint unsigned | 事件最小消耗时间 |
| AVG_TIMER_WAIT | bigint unsigned | 事件平均消耗时间 |
| MAX_TIMER_WAIT | bigint unsigned | 事件最大消耗时间 |
使用介绍
相关参数
开启stage统计信息
call sys.ps_setup_enable_instrument('%stage/%');开启events_statements_stages_agg_current开关
call sys.ps_setup_enable_consumer('events_statements_stages_agg_current');开启greatdb相关stage
##开启线程的 set greatdb_enable_profile = on; ##开启全局的 set global greatdb_enable_profile = on;
示范
在session1执行语句，在session2 查看session1最近执行语句的stage详情。
session1
insert into t1 values(1, 1);
session2
GreatDB Cluster[performance_schema]> select * from performance_schema.events_statements_stages_agg_current where thread_id = ${session1.thread_id};
+-----------+--------------------------------------------------+----------+------------+----------------+----------------+----------------+----------------+
| THREAD_ID | EVENT_NAME | EVENT_ID | COUNT_STAR | SUM_TIMER_WAIT | MIN_TIMER_WAIT | AVG_TIMER_WAIT | MAX_TIMER_WAIT |
+-----------+--------------------------------------------------+----------+------------+----------------+----------------+----------------+----------------+
| 122 | stage/sql/checking permissions | 30 | 1 | 18718000 | 18718000 | 18718000 | 18718000 |
| 122 | stage/sql/cleaning up | 30 | 1 | 805000 | 805000 | 805000 | 805000 |
| 122 | stage/sql/closing tables | 30 | 1 | 28403000 | 28403000 | 28403000 | 28403000 |
| 122 | stage/sql/end | 30 | 1 | 3052000 | 3052000 | 3052000 | 3052000 |
| 122 | stage/sql/freeing items | 30 | 1 | 20793000 | 20793000 | 20793000 | 20793000 |
| 122 | stage/sql/init | 30 | 1 | 40171000 | 40171000 | 40171000 | 40171000 |
| 122 | stage/sql/Opening tables | 30 | 1 | 12421342000 | 12421342000 | 12421342000 | 12421342000 |
| 122 | stage/sql/query end | 30 | 1 | 3282000 | 3282000 | 3282000 | 3282000 |
| 122 | stage/sql/System lock | 30 | 3 | 145126000 | 19561000 | 48375000 | 69066000 |
| 122 | stage/sql/update | 30 | 2 | 63161294000 | 433800000 | 31580647000 | 62727494000 |
| 122 | stage/sql/waiting for handler commit | 30 | 3 | 6146891000 | 10103000 | 2048963000 | 6104718000 |
| 122 | stage/sql/starting | 30 | 2 | 462362000 | 39471000 | 231181000 | 422891000 |
| 122 | stage/sql/Executing hook on transaction begin. | 30 | 1 | 44606000 | 44606000 | 44606000 | 44606000 |
| 122 | stage/greatdb/Waiting for dtm start response | 30 | 1 | 1006304000 | 1006304000 | 1006304000 | 1006304000 |
| 122 | stage/greatdb/Async send dtm snapshot request | 30 | 1 | 45416000 | 45416000 | 45416000 | 45416000 |
| 122 | stage/greatdb/Waiting for dtm commit response | 30 | 1 | 262280000 | 262280000 | 262280000 | 262280000 |
| 122 | stage/greatdb/Gdb execute plan | 30 | 1 | 212381000 | 212381000 | 212381000 | 212381000 |
| 122 | stage/greatdb/Waiting for greatdb storage commit | 30 | 1 | 3504000 | 3504000 | 3504000 | 3504000 |
+-----------+--------------------------------------------------+----------+------------+----------------+----------------+----------------+----------------+
清理events_statements_stages_agg_current
支持使用truncate 语句清空events_statements_stages_agg_current信息。
truncate table performance_schema.events_statements_stages_agg_current;「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
