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_SCHEMATDSTORE_BULK_LOAD_TXN_INFO

TDSTORE_BULK_LOAD_TXN_INFO

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

Function

INFORMATION_SCHEMA.TDSTORE_BULK_LOAD_TXN_INFO is used to query both historical Bulk Load transactions and information about ongoing Bulk Load transactions.

Field Description

Field Name
Type
Description
node_name
varchar(64)
Node name.
node_addr
varchar(64)
Node address.
trans_id
bigint
Transaction ID.
state
varchar(64)
Current status of the Bulk Load transaction.
start_time
varchar(64)
start time of the Bulk Load.
end_time
varchar(64)
end time of the Bulk Load.
total_file_num
bigint
Number of SST files for the Bulk Load transaction.
total_file_size
bigint
size of the SST files for the Bulk Load transaction in Bytes.
total_cost_ms
bigint
Total duration of the Bulk Load transaction in ms.
detail_cost_info
longtext
Specific duration of each stage in the Bulk Load process, in microseconds.
rep_group_ids
longtext
RG ID involved in the Bulk Load transaction.
err_msg
longtext
Error message for the Bulk Load transaction in failure scenarios.

Examples

tdsql>  select * from INFORMATION_SCHEMA.TDSTORE_BULK_LOAD_TXN_INFO;
*************************** 1. row ***************************
       node_name: node-******-1-21-001
       node_addr: 10.10.10.10:9806
        trans_id: 29350720562004012
           state: SUCCESS
      start_time: 2025-06-09 11:21:14 231
        end_time: 2025-06-09 11:21:14 541
  total_file_num: 1
 total_file_size: 386413
   total_cost_ms: 310
detail_cost_info:  [BULK_LOAD_TRANS: <PUT_RECORDS: 12333us>, <EXECUTOR_HANDLE: 76us>, <FINISH_WRITE_AND_SORT_DATA: 5591us>, <SET_SCHEDULE_REP_GROUP_JOB: 0us>, <GET_REP_GROUP_META_FROM_MC: 1062us>, <REORG_SST_FILE_BY_REP_GROUP: 210us>, <SEND_SST_FILE_TO_DST_NODE: 1329us>, <PREPARE_PARTS: 56us>, <COMMIT_SYNC_LOG: 28180us>, <WAIT_CLIENT_BEFORE_COMMITTING: 261958us>, <WAIT_WHEN_COMMITTING: 117us>, <CLEAN_PENDING_COMMIT_DATA_DIR: 0us>] 
   rep_group_ids: 257
         err_msg: 
*************************** 2. row ***************************
       node_name: node-******-1-21-001
       node_addr: 10.10.10.10:9806
        trans_id: 29350720562004019
           state: SUCCESS
      start_time: 2025-06-09 11:21:14 231
        end_time: 2025-06-09 11:21:14 575
  total_file_num: 1
 total_file_size: 386233
   total_cost_ms: 344
detail_cost_info:  [BULK_LOAD_TRANS: <PUT_RECORDS: 14501us>, <EXECUTOR_HANDLE: 57us>, <FINISH_WRITE_AND_SORT_DATA: 5831us>, <SET_SCHEDULE_REP_GROUP_JOB: 0us>, <GET_REP_GROUP_META_FROM_MC: 1482us>, <REORG_SST_FILE_BY_REP_GROUP: 176us>, <SEND_SST_FILE_TO_DST_NODE: 196us>, <PREPARE_PARTS: 44us>, <COMMIT_SYNC_LOG: 51951us>, <WAIT_CLIENT_BEFORE_COMMITTING: 269700us>, <WAIT_WHEN_COMMITTING: 150us>, <CLEAN_PENDING_COMMIT_DATA_DIR: 0us>] 
   rep_group_ids: 257
         err_msg: 
*************************** 3. row ***************************
       node_name: node-******-1-21-001
       node_addr: 10.10.10.10:9806
        trans_id: 29350720562004034
           state: SUCCESS
      start_time: 2025-06-09 11:21:14 231
        end_time: 2025-06-09 11:21:14 597
  total_file_num: 1
 total_file_size: 386649
   total_cost_ms: 366
detail_cost_info:  [BULK_LOAD_TRANS: <PUT_RECORDS: 17218us>, <EXECUTOR_HANDLE: 77us>, <FINISH_WRITE_AND_SORT_DATA: 8347us>, <SET_SCHEDULE_REP_GROUP_JOB: 0us>, <GET_REP_GROUP_META_FROM_MC: 982us>, <REORG_SST_FILE_BY_REP_GROUP: 1139us>, <SEND_SST_FILE_TO_DST_NODE: 200us>, <PREPARE_PARTS: 55us>, <COMMIT_SYNC_LOG: 66420us>, <WAIT_CLIENT_BEFORE_COMMITTING: 271738us>, <WAIT_WHEN_COMMITTING: 102us>, <CLEAN_PENDING_COMMIT_DATA_DIR: 0us>] 
   rep_group_ids: 257
         err_msg: 
3 rows in set (0.01 sec)
이전 주제: TDSTORE_ACTIVE_COMPACTION_STATS다음 주제: TDSTORE_CF_OPTIONS

도움말 및 지원

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

피드백