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.