TIDB_SERVERS_INFO
TIDB_SERVERS_INFO 表提供了 TiDB 集群中 TiDB 服务器的信息(即 tidb-server 进程)。
1. USE information_schema;
2. DESC tidb_servers_info;
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. +---------------+-------------+------+------+---------+-------+
13. 8 rows in set (0.00 sec)
1. SELECT * FROM tidb_servers_info\G
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: 5.7.25-TiDB-v4.0.0-beta.2-720-g0df3b74f5
8. GIT_HASH: 0df3b74f55f8f8fbde39bbd5d471783f49dc10f7
9. BINLOG_STATUS: Off
10. 1 row in set (0.00 sec)
