You are viewing the documentation of an older version of the TiDB database (TiDB v3.0).

It is recommended that you use the latest LTS version of the TiDB database.

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:

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.
Was this page helpful?