tencent cloud

TDSQL Boundless

Release Notes
Product Introduction
Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
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
Configuration Change
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_SCHEMALOGSERVICE_DUMP_PROCESSLIST

LOGSERVICE_DUMP_PROCESSLIST

PDF
포커스 모드
폰트 크기
마지막 업데이트 시간: 2026-03-06 18:48:07

Function

The LOGSERVICE_DUMP_PROCESSLIST view is used to monitor the data replay progress and memory usage of each Replication Group (RG) in the Binlog Dump layer. Through this view, users can check the synchronization status, persistence progress, and resource allocation of each RG in real time, helping Ops personnel grasp the real-time operational status of Binlog generation.

Field Description

Field Name
Type
Description
sid
bigint unsigned
the unique identifier of LogService
rep_group_id
bigint unsigned
Replication Group ID
dump_curr_ts_barrier
bigint unsigned
The commit timestamp barrier of the Binlog Dump RG in current memory
curr_ts_barrier_persisted
bigint unsigned
The current persisted commit timestamp barrier of the Binlog Dump RG
unpersisted_sql_min_commit_ts
bigint unsigned
The minimum commit timestamp of unpersisted transactions in the current RG
max_alloc_size
bigint unsigned
the maximum memory allocated to this RG
used_mem_size
bigint unsigned
the memory used by this RG
Note:
unpersisted_sql_min_commit_ts reflects the earliest transaction timestamp that has not yet been persisted.
Memory-related fields help monitor the memory usage efficiency of RGs to avoid memory overflow.

Examples

tdsql >  SELECT * FROM INFORMATION_SCHEMA.LOGSERVICE_DUMP_PROCESSLIST LIMIT 1\\G
*************************** 1. row ***************************
                          sid: 29635447583932561
                 rep_group_id: 257
         dump_curr_ts_barrier: 29635448859000901
    curr_ts_barrier_persisted: 29635448859000901
unpersisted_sql_min_commit_ts: NULL
               max_alloc_size: 10485760
                used_mem_size: 0
1 row in set (0.00 sec)
Result Interpretation
The current commit ts barrier for replication group 257 is 29627931357610059.
unpersisted_sql_min_commit_ts is NULL, indicating there are no unpersisted transactions.
이전 주제: DDL_JOB_STAGE_INFO다음 주제: LOGSERVICE_DUMP_STAT

도움말 및 지원

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

피드백