x$ps_digest_avg_latency_distribution - xiaoboluo768/mysql-system-schema GitHub Wiki
-
帮助视图(辅助试图)，用于帮助x$ps_digest_95th_percentile_by_avg_us视图生成语句百分之九十五的平均执行时间分布值，数据来源：events_statements_summary_by_digest
-
x$ps_digest_avg_latency_distribution视图字段含义如下：
- cnt：按照语句平均执行时间的分组计数值
- avg_us：语句平均执行时间（微秒单位）
-
视图定义语句
CREATE OR REPLACE
ALGORITHM = TEMPTABLE
DEFINER = 'root'@'localhost'
SQL SECURITY INVOKER
VIEW x$ps_digest_avg_latency_distribution (
cnt, avg_us
) AS
SELECT COUNT(*) cnt,
ROUND(avg_timer_wait/1000000) AS avg_us
FROM performance_schema.events_statements_summary_by_digest
GROUP BY avg_us;
- 视图查询信息示例
admin@localhost : sys 01:00:38> select * from x$ps_digest_avg_latency_distribution limit 3;
+-----+--------+
| cnt | avg_us |
+-----+--------+
| 2 | 38 |
| 1 | 43 |
| 1 | 57 |
+-----+--------+
3 rows in set (0.00 sec)
- 参考链接：辅助视图无参考链接