check-cluster-status-using-sql-statements.md

title	summary	category	aliases
Check the TiDB Cluster Status Using SQL Statements	This document introduces that TiDB offers some SQL statements and system tables to check the TiDB cluster status.	reference	/docs/dev/reference/performance/check-cluster-status-using-sql-statements/

Check the TiDB Cluster Status Using SQL Statements

TiDB offers some SQL statements and system tables to check the TiDB cluster status.

The INFORMATION_SCHEMA system database offers system tables as follows to query the cluster status and diagnose common cluster issues:

• TABLES
• TIDB_INDEXES
• ANALYZE_STATUS
• TIDB_HOT_REGIONS
• TIKV_STORE_STATUS
• TIKV_REGION_STATUS
• TIKV_REGION_PEERS

You can also use the following statements to obtain some useful information for troubleshooting and querying the TiDB cluster status.

• ADMIN SHOW DDL: obtains the ID of TiDB with the DDL owner role and IP:PORT.
• The feature of SHOW ANALYZE STATUS is the same with that of the ANALYZE_STATUS table.
• Specific EXPLAIN statements
  • EXPLAIN ANALYZE: obtains some detailed information for execution of a SQL statement.
  • EXPLAIN FOR CONNECTION: obtains the execution plan for the query executed last in a connection. Can be used along with SHOW PROCESSLIST.
  • For more information about EXPLAIN, see Understand the Query Execution Plan.