TiDB offers some SQL statements and system tables to check the TiDB cluster status.
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 ownerrole and
- The feature of
SHOW ANALYZE STATUSis the same with that of the
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
- For more information about
EXPLAIN, see Understand the Query Execution Plan.