SELECT * FROM INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY UNION ALL SELECT * FROM INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY_HISTORY ),best_plans AS ( SELECT plan_digest, `digest`, avg_latency, CONCAT('create global binding from history using plan digest "', plan_digest, '"') as binding...
SELECT * FROM INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY UNION ALL SELECT * FROM INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY_HISTORY ), best_plans AS ( SELECT plan_digest, `digest`, avg_latency, CONCAT('create global binding from history using plan digest "', plan_digest, '"') as binding...
CLUSTER_STATEMENTS_SUMMARY_HISTORY ), best_plans AS ( SELECT plan_digest, `digest`, avg_latency, CONCAT('create global binding from history using plan digest "', plan_digest, '"') as binding_stmt FROM stmts t1 WHERE avg_latency = (SELECT min(avg_latency) FROM stmts t2 -- The plan ...
CLUSTER_STATEMENTS_SUMMARY_HISTORY提供STATEMENTS_SUMMARY_HISTORY表的集群级别的视图。 CLUSTER_TIDB_INDEX_USAGE提供TIDB_INDEX_USAGE表的集群级别的视图。 CLUSTER_TIDB_TRX提供TIDB_TRX表的集群级别的视图。 CLUSTER_SYSTEMINFO提供集群中服务器的内核参数配置的详细信息。
WITH stmts AS ( -- Gets all information SELECT * FROM INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY UNION ALL SELECT * FROM INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY_HISTORY ), best_plans AS ( SELECT plan_digest, `digest`, avg_latency, CONCAT('create global binding from history using plan ...
cluster_statements_summary显示各台 TiDB server 的statements_summary数据,cluster_statements_summary_history显示各台 TiDB server 的statements_summary_history数据。这两张表用字段INSTANCE表示 TiDB server 的地址,其他字段与statements_summary相同。 参数配置 ...
cluster_statements_summary_history: 显示各台 TiDB server 的statements_summary_history数据 上面2个集群系统表使用用字段INSTANCE表示 TiDB server 的地址。 注意:重启TiDB后,上面的4张系统表的数据会清空。因为它们是内存表,不会持久化数据。 系统表字段说明 ...
CLUSTER_STATEMENTS_SUMMARY_HISTORY ), best_plans AS ( SELECT plan_digest, `digest`, avg_latency, CONCAT('create global binding from history using plan digest "', plan_digest, '"') as binding_stmt FROM stmts t1 WHERE avg_latency = (SELECT min(avg_latency) FROM stmts t2 -- The plan ...
SELECT * FROM INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY UNION ALL SELECT * FROM INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY_HISTORY ), best_plans AS ( SELECT plan_digest, `digest`, avg_latency, CONCAT('create global binding from history using plan digest "', plan_digest, '"') as binding...
我想查询在2021-04-05 00:01:30这个时间执行了哪些sql。要如何查询呢? cluster_statements_summary_history这个历史表里面没有记录。因为他的LAST_SEEN和FIRST_SEEN时间是动态的, SUMMARY_BEGIN_TIME和 SUMMARY_END_TIME时间是个区间。所以无法确定当时时间的sql记录。有其他办法查询到吗?