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

Data Processing And Security Agreement

Glossary

TDSTORE_COMPACTION_HISTORY

PDF

포커스 모드

폰트 크기

마지막 업데이트 시간: 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
﻿

도움말 및 지원

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

더 자세한 내용은 문의하기 또는 티겟 제출 을 통해 문의할 수 있습니다.

피드백

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.

tencent cloud

TDSQL Boundless

TDSTORE_COMPACTION_HISTORY

Function

Field Description

Examples

도움말 및 지원