tencent cloud

TDSQL Boundless

Release Notes
Product Introduction
Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
Kernel Features
Kernel Overview
Kernel Version Release Notes
Functionality Features
Performance Features
Billing
Billing Overview
Purchase Method
Pricing Details
Renewal
Overdue Payments
Refund
Getting Started
Creating an Instance
Connect to Instances
User Guide
Data Migration
Data Subscription
Instance Management
Parameter Configuration
Account Management
Security Group
Backup and Restoration
Database Auditing
Tag Management
Use Cases
Technical Evolution and Usage Practices of Online DDL
Lock Mechanism Analysis and Troubleshooting Practices
Data Intelligent Scheduling and Related Practices for Performance Optimization
TDSQL Boundless Selection Guide and Practical Tutorial
Developer Guide
Developer Guide (MySQL Compatibility Mode)
Developer Guide (HBase Compatibility Mode)
Performance Tuning
Performance Tuning Overview
SQL Tuning
DDL Tuning
Performance White Paper
Performance Overview
TPC-C Test
Sysbench Test
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Security Group APIs
Task APIs
Backup APIs
Rollback APIs
Parameter APIs
Database APIs
Data Types
Error Codes
General Reference
System Architecture
SQL Reference
Database Parameter Description
TPC-H benchmark data model reference
Error Code Information
Security and Compliance
FAQs
Agreements
Service Level Agreement
Terms of Service
Privacy Policy
Data Processing And Security Agreement
Contact Us
Glossary
문서TDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMAMETA_CLUSTER_RGS

META_CLUSTER_RGS

PDF
포커스 모드
폰트 크기
마지막 업데이트 시간: 2026-02-10 11:06:29

Function

INFORMATION_SCHEMA.META_CLUSTER_RGS is used to store and display metadata related to Replication Groups (RG) within the instance.

Field Description

Field Name
Type
Description
rep_group_id
bigint unsigned
RG ID.
data_space_type
varchar(64)
Type of data space.
DATA_SPACE_TYPE_SYSTEM: system space.
DATA_SPACE_TYPE_USER: user space.
rep_group_state
varchar(64)
RG status.
meta_version
bigint
Metadata Version.
member_version
bigint
Membership change version.
key_range_version
bigint
version of key range.
quorum
int unsigned
Legal Quorum.
member_node_names
varchar(320)
Member list.
leader_node_name
varchar(320)
Leader member.
last_leader_report_time
varchar(64)
Last reported time of the heartbeat.
create_time
varchar(64)
creation time of RG.
parent_rep_group_id
bigint unsigned
If a split occurs, then it reflects the ID of the parent RG; otherwise the value is 0.
rep_group_stats_approximate_size
bigint unsigned
Approximate data size of the RG Leader in bytes.
rep_group_stats_approximate_keys
bigint unsigned
Approximate number of keys in the RG Leader.
rep_group_log_info_current_term
bigint unsigned
Current Leader term.
rep_group_log_info_committed_index
bigint unsigned
The index of the committed log.
rep_group_log_info_consecutive_applied_index
bigint unsigned
Applied log index.
rep_group_log_info_last_snapshot_index
bigint unsigned
The log index of the last snapshot taken.
rep_group_log_info_first_index
bigint unsigned
The starting log index of the Raft Log retained in memory, indicating that logs before this have been purged.
rep_group_log_info_last_index
bigint unsigned
The last log index of the Raft Log retained in memory.
rep_group_log_info_disk_index
bigint unsigned
The persisted log index of the Raft Log.
rep_group_log_info_applied_index
bigint unsigned
Applied index of the Raft Log.
rep_group_log_info_raft_log_sync_delay_seconds
bigint unsigned
Delay of replica log synchronization.

property
varchar(64)
RG attributes:
RG_PROPERTY_DEFAULT: ordinary RG.
RG_PROPERTY_BROADCAST: broadcast RG.
RG_PROPERTY_SYNC: synchronous RG.
RG_PROPERTY_BROADCAST_SYNC: broadcast synchronous RG.
witness_quorum
int unsigned
witness Legal Quorum.
witnesses
longtext
witness member.

Examples

tdsql>SELECT * FROM information_schema.meta_cluster_rgs\\G;
*************************** 1. row ***************************
                                  rep_group_id: 1792
                               data_space_type: DATA_SPACE_TYPE_SYSTEM
                               rep_group_state: RG_STATE_L_WORKING
                                  meta_version: 36
                                member_version: 0
                             key_range_version: 36
                                        quorum: 3
                             member_node_names: [node-tdsql3-86ea1ffe-001, node-tdsql3-86ea1ffe-002, node-tdsql3-86ea1ffe-003]
                              leader_node_name: node-tdsql3-86ea1ffe-002
                       last_leader_report_time: 2024-08-19 16:31:47.866168
                                   create_time: 2024-08-19 14:56:47.692831
                           parent_rep_group_id: 0
              rep_group_stats_approximate_size: 9725997
              rep_group_stats_approximate_keys: 3836
               rep_group_log_info_current_term: 9
            rep_group_log_info_committed_index: 6783
  rep_group_log_info_consecutive_applied_index: 6783
        rep_group_log_info_last_snapshot_index: 6727
                rep_group_log_info_first_index: 2
                 rep_group_log_info_last_index: 6783
                 rep_group_log_info_disk_index: 6783
              rep_group_log_info_applied_index: 6783
rep_group_log_info_raft_log_sync_delay_seconds: 11
                                      property: RG_PROPERTY_DEFAULT
                                witness_quorum: 0
                                     witnesses: []
*************************** 2. row ***************************
                                  rep_group_id: 1281
                               data_space_type: DATA_SPACE_TYPE_USER
                               rep_group_state: RG_STATE_L_WORKING
                                  meta_version: 3
                                member_version: 0
                             key_range_version: 3
                                        quorum: 3
                             member_node_names: [node-tdsql3-86ea1ffe-001, node-tdsql3-86ea1ffe-002, node-tdsql3-86ea1ffe-003]
                              leader_node_name: node-tdsql3-86ea1ffe-003
                       last_leader_report_time: 2024-08-19 16:31:49.145344
                                   create_time: 2024-08-19 14:56:47.817777
                           parent_rep_group_id: 0
              rep_group_stats_approximate_size: 3070
              rep_group_stats_approximate_keys: 27
               rep_group_log_info_current_term: 3
            rep_group_log_info_committed_index: 864
  rep_group_log_info_consecutive_applied_index: 864
        rep_group_log_info_last_snapshot_index: 831
                rep_group_log_info_first_index: 2
                 rep_group_log_info_last_index: 864
                 rep_group_log_info_disk_index: 864
              rep_group_log_info_applied_index: 864
rep_group_log_info_raft_log_sync_delay_seconds: 18446744073709551615
                                      property: RG_PROPERTY_DEFAULT
                                witness_quorum: 0
                                     witnesses: []

2 rows in set (0.01 sec)
이전 주제: META_CLUSTER_REPLICAS다음 주제: META_CLUSTER_SCHEDULE_CONFIGS

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백