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
.SHOW ANALYZE STATUS
is the same with that of the ANALYZE_STATUS
table.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
.EXPLAIN
, see Understand the Query Execution Plan.