INFORMATION_SCHEMA.LOGSERVICE_INFO is used to display metadata related to the LogService data unit (LogReceiver) within an instance.Field Name | Type | Description |
rep_group_id | bigint unsigned | RG ID |
sid | bigint unsigned | the unique identifier of LogService |
node_name | varchar(64) | the node name where LogReceiver is deployed |
node_addr | varchar(64) | the network address (IP address:Port) of the node where LogReceiver is deployed |
leader_commit_index | bigint unsigned | During LogService creation, the commit index of the rep-group's Leader replica. |
create_ts | bigint unsigned | the timestamp when LogReceiver was created |
delete_ts | bigint unsigned | the timestamp when LogReceiver is marked for deletion (0 indicates not deleted) |
is_pending | smallint | Indicates whether the LogReceiver is suspended (0: normal, 1: suspended). |
tdsql> SELECT * FROM INFORMATION_SCHEMA.LOGSERVICE_INFO;+--------------+-------------------+------------------------+---------------------+---------------------+-------------------+-------------------+------------+| rep_group_id | sid | node_name | node_addr | leader_commit_index | create_ts | delete_ts | is_pending |+--------------+-------------------+------------------------+---------------------+---------------------+-------------------+-------------------+------------+| 16048685 | 29637288212299800 | node-***-001 | ***:*** | NULL | 29637329400367957 | 29637343912657087 | 0 || 32003329 | 29637288212299800 | node-***-005 | ***:*** | NULL | 29637465950126221 | 29637466285670778 | 0 || 23420940 | 29637288212299800 | node-***-001 | ***:*** | NULL | 29637391039873556 | 29637392667252366 | 0 |+--------------+-------------------+------------------------+---------------------+---------------------+-------------------+-------------------+------------+3 rows in set (3.74 sec)
is_pending = 0).Esta página foi útil?
Você também pode entrar em contato com a Equipe de vendas ou Enviar um tíquete em caso de ajuda.
comentários