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
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
Developer Guide
- Developer Guide (MySQL Compatibility Mode)
- Developer Guide (HBase Compatibility Mode)
Performance Tuning
- Performance Tuning Overview
- SQL Tuning
- DDL Tuning
Performance White Paper
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
Contact Us
Glossary

TDSTORE_COMPACTION_HISTORY

Focus Mode

Font Size

Last updated: 2026-02-10 11:06:31

Function
INFORMATION_SCHEMA.TDSTORE_COMPACTION_HISTORY is used to display historical Compaction tasks in TDStore.
Field Description
Field Name
Type
Description
THREAD_ID
VARCHAR(513)
 The thread ID that performs the Compaction task.
CF_NAME
VARCHAR(513)
The ColumnFamily name that the Compaction task belongs to.
INPUT_LEVEL
INT
The hierarchy level of Compaction input files.
OUTPUT_LEVEL
INT
The level of output files of Compaction.
INPUT_FILES
VARCHAR(513)
The name of input files of Compaction.
OUTPUT_FILES
VARCHAR(513)
The name of output files of Compaction.
COMPACTION_REASON
VARCHAR(513)
The reason for triggering Compaction.
START_TIMESTAMP
BIGINT
Start time of Compaction.
END_TIMESTAMP
BIGINT
End time of Compaction.
INPUT_COMPACTION_BYTES
BIGINT
Total volume of input data of Compaction.
OUTPUT_COMPACTION_BYTES
BIGINT
Total volume of output data of Compaction.
INPUT_FILE_COUNT
INT
Number of input files for Compaction.
OUTPUT_FILE_COUNT
INT
Number of output files for Compaction.
CPU_MICROS
BIGINT
The CPU time consumed by Compaction, in ms.
NODE_NAME
VARCHAR(513)
Name of the SQLEngine node.
Examples
tdsql>select * from TDSTORE_COMPACTION_HISTORY\\G
*************************** 1. row ***************************
              THREAD_ID: 7f77f1fff700
                CF_NAME: user_region
            INPUT_LEVEL: 1
           OUTPUT_LEVEL: 2
            INPUT_FILES: 000212.sst
           OUTPUT_FILES: 000232.sst
      COMPACTION_REASON: LevelMaxLevelSize
        START_TIMESTAMP: 1722946987
          END_TIMESTAMP: 1722946988
 INPUT_COMPACTION_BYTES: 33818511
OUTPUT_COMPACTION_BYTES: 16227005
       INPUT_FILE_COUNT: 1
      OUTPUT_FILE_COUNT: 1
             CPU_MICROS: 420796
              NODE_NAME: node-Performance-1505-9_109_173_22-001
*************************** 2. row ***************************
              THREAD_ID: 7f77f1fff700
                CF_NAME: user_region
            INPUT_LEVEL: 1
           OUTPUT_LEVEL: 2
            INPUT_FILES: 000071.sst
           OUTPUT_FILES: 000234.sst
      COMPACTION_REASON: LevelMaxLevelSize
        START_TIMESTAMP: 1722946988
          END_TIMESTAMP: 1722946988
 INPUT_COMPACTION_BYTES: 33818511
OUTPUT_COMPACTION_BYTES: 16226568
       INPUT_FILE_COUNT: 1
      OUTPUT_FILE_COUNT: 1
             CPU_MICROS: 426266
              NODE_NAME: node-Performance-1505-9_109_173_22-001
*************************** 3. row ***************************
              THREAD_ID: 7f77f1fff700
                CF_NAME: user_region
            INPUT_LEVEL: 1
           OUTPUT_LEVEL: 2
            INPUT_FILES: 000220.sst
           OUTPUT_FILES: 000235.sst
      COMPACTION_REASON: LevelMaxLevelSize
        START_TIMESTAMP: 1722946988
          END_TIMESTAMP: 1722946989
 INPUT_COMPACTION_BYTES: 33818511
OUTPUT_COMPACTION_BYTES: 16226904
       INPUT_FILE_COUNT: 1
      OUTPUT_FILE_COUNT: 1
             CPU_MICROS: 415835
              NODE_NAME: node-Performance-1505-9_109_173_22-001
﻿

Help and Support

Was this page helpful?

You can also Contact sales or Submit a Ticket for help.

Help us improve! Rate your documentation experience in 5 mins.

Feedback

tencent cloud

TDSQL Boundless

TDSTORE_COMPACTION_HISTORY

Function

Field Description

Examples

Help and Support

Field Name	Type	Description
THREAD_ID	VARCHAR(513)	The thread ID that performs the Compaction task.
CF_NAME	VARCHAR(513)	The ColumnFamily name that the Compaction task belongs to.
INPUT_LEVEL	INT	The hierarchy level of Compaction input files.
OUTPUT_LEVEL	INT	The level of output files of Compaction.
INPUT_FILES	VARCHAR(513)	The name of input files of Compaction.
OUTPUT_FILES	VARCHAR(513)	The name of output files of Compaction.
COMPACTION_REASON	VARCHAR(513)	The reason for triggering Compaction.
START_TIMESTAMP	BIGINT	Start time of Compaction.
END_TIMESTAMP	BIGINT	End time of Compaction.
INPUT_COMPACTION_BYTES	BIGINT	Total volume of input data of Compaction.
OUTPUT_COMPACTION_BYTES	BIGINT	Total volume of output data of Compaction.
INPUT_FILE_COUNT	INT	Number of input files for Compaction.
OUTPUT_FILE_COUNT	INT	Number of output files for Compaction.
CPU_MICROS	BIGINT	The CPU time consumed by Compaction, in `ms`.
NODE_NAME	VARCHAR(513)	Name of the SQLEngine node.