TIDB_SERVERS_INFO

The TIDB_SERVERS_INFO table provides information about TiDB servers in the TiDB Cluster (namely, tidb-server processes).

TIDB_SERVERS_INFO - 图1

Note

This table is not available on TiDB Serverless clusters.

  1. USE INFORMATION_SCHEMA;
  2. DESC tidb_servers_info;

The output is as follows:

  1. +---------------+--------------+------+------+---------+-------+
  2. | Field         | Type         | Null | Key  | Default | Extra |
  3. +---------------+--------------+------+------+---------+-------+
  4. | DDL_ID        | varchar(64)  | YES  |      | NULL    |       |
  5. | IP            | varchar(64)  | YES  |      | NULL    |       |
  6. | PORT          | bigint(21)   | YES  |      | NULL    |       |
  7. | STATUS_PORT   | bigint(21)   | YES  |      | NULL    |       |
  8. | LEASE         | varchar(64)  | YES  |      | NULL    |       |
  9. | VERSION       | varchar(64)  | YES  |      | NULL    |       |
  10. | GIT_HASH      | varchar(64)  | YES  |      | NULL    |       |
  11. | BINLOG_STATUS | varchar(64)  | YES  |      | NULL    |       |
  12. | LABELS        | varchar(128) | YES  |      | NULL    |       |
  13. +---------------+--------------+------+------+---------+-------+
  14. 9 rows in set (0.00 sec)

View the TIDB_SERVERS_INFO table:

  1. SELECT * FROM TIDB_SERVERS_INFO\G

The output is as follows:

  1. *************************** 1. row ***************************
  2.        DDL_ID: 771c169d-0a3a-48ea-a93c-a4d6751d3674
  3.            IP: 0.0.0.0
  4.          PORT: 4000
  5.   STATUS_PORT: 10080
  6.         LEASE: 45s
  7.       VERSION: 8.0.11-TiDB-v8.1.0
  8.      GIT_HASH: 827d8ff2d22ac4c93ae1b841b79d468211e1d393
  9. BINLOG_STATUS: Off
  10.        LABELS:
  11. 1 row in set (0.006 sec)