TIDB_SERVERS_INFO
TIDB_SERVERS_INFO
の表は、TiDBクラスター内のTiDBサーバー(つまり、tidb-serverプロセス)に関する情報を提供します。
USE information_schema;
DESC tidb_servers_info;
+---------------+-------------+------+------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+------+---------+-------+
| DDL_ID | varchar(64) | YES | | NULL | |
| IP | varchar(64) | YES | | NULL | |
| PORT | bigint(21) | YES | | NULL | |
| STATUS_PORT | bigint(21) | YES | | NULL | |
| LEASE | varchar(64) | YES | | NULL | |
| VERSION | varchar(64) | YES | | NULL | |
| GIT_HASH | varchar(64) | YES | | NULL | |
| BINLOG_STATUS | varchar(64) | YES | | NULL | |
+---------------+-------------+------+------+---------+-------+
8 rows in set (0.00 sec)
SELECT * FROM tidb_servers_info\G
*************************** 1. row ***************************
DDL_ID: 771c169d-0a3a-48ea-a93c-a4d6751d3674
IP: 0.0.0.0
PORT: 4000
STATUS_PORT: 10080
LEASE: 45s
VERSION: 5.7.25-TiDB-v4.0.0-beta.2-720-g0df3b74f5
GIT_HASH: 0df3b74f55f8f8fbde39bbd5d471783f49dc10f7
BINLOG_STATUS: Off
1 row in set (0.00 sec)