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_SCHEMATDSTORE_SST_PROPS

TDSTORE_SST_PROPS

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

Function

INFORMATION_SCHEMA.TDSTORE_SST_PROPS is used to display the properties of SSTables in TDStore.

Field Description

Field Name
Type
Description
DB_TYPE
VARCHAR(193)
The SSTable belongs to the RocksDB type, supporting data_db, multi_raft_db, and monitor_info_db.
SST_NAME
VARCHAR(193)
The name of the SSTable.
COLUMN_FAMILY
INT
The corresponding ColumnFamily ID for the SSTable.
LEVEL
INT
The level of the SSTable.
MAX_KEY
VARCHAR(193)
The largest Key in the SSTable.
MIN_KEY
VARCHAR(193)
The smallest Key in the SSTable.
NUM_DATA_BLOCKS
BIGINT
The number of data blocks in the SSTable.
NUM_ENTRIES
BIGINT
The number of Entries in the SSTable.
NUM_DELETIONS
BIGINT
The number of deletions in the SSTable.
RAW_KEY_SIZE
BIGINT
The total size of keys in the SSTable before compression, in bytes.
RAW_VALUE_SIZE
BIGINT
The total size of Values in the SSTable before compression, in bytes.
DATA_BLOCK_SIZE
BIGINT
The total size of data blocks in the SSTable, in bytes.
INDEX_BLOCK_SIZE
BIGINT
The total size of index blocks in the SSTable, in bytes.
INDEX_PARTITIONS
INT
The number of index partitions in the SSTable.
TOP_LEVEL_INDEX_SIZE
BIGINT
The size of the top-level index in the SSTable, in bytes.
FILTER_BLOCK_SIZE
BIGINT
The total size of filter blocks in the SSTable, in bytes.
COMPRESSION_ALGO
VARCHAR(193)
The compression algorithm used by the SSTable.
CREATION_TIME
BIGINT
The creation time of the SSTable.
OLDEST_KEY_TIME
BIGINT
The creation time of the oldest Key in the SSTable.
FILTER_POLICY
VARCHAR(193)
The name of the Filter used by the SSTable.
NODE_NAME
VARCHAR(513)
Name of the SQLEngine node hosting the SSTable.

Examples

tdsql > select * from tdstore_sst_props\\G
*************************** 1. row ***************************
             DB_TYPE: data_db
            SST_NAME: 000019.sst
       COLUMN_FAMILY: 1
               LEVEL: 0
             MAX_KEY: 0000011E00000001
             MIN_KEY: 0000000100000001
     NUM_DATA_BLOCKS: 145
         NUM_ENTRIES: 54974
       NUM_DELETIONS: 794
        RAW_KEY_SIZE: 2256766
      RAW_VALUE_SIZE: 8356920
     DATA_BLOCK_SIZE: 9729222
    INDEX_BLOCK_SIZE: 5047
    INDEX_PARTITIONS: 0
TOP_LEVEL_INDEX_SIZE: 0
   FILTER_BLOCK_SIZE: 0
    COMPRESSION_ALGO: NULL
       CREATION_TIME: 1724913962
     OLDEST_KEY_TIME: 1724913362
       FILTER_POLICY: NULL
           NODE_NAME: node-1-001
*************************** 2. row ***************************
             DB_TYPE: data_db
            SST_NAME: 000020.sst
       COLUMN_FAMILY: 2
               LEVEL: 0
             MAX_KEY: 000027121E711E951C471E95091CAA1DAA1CAA1DB9091E95020B1E951E33091EB51DB91C7A1C47091E951CAA020B1D77091CAA1DB90000000004
             MIN_KEY: 000027121C8F1D321C471CF4091DB91DDD1E711E95091D321C7A1E710277091C471D771D771DDD091EF5020B1D32020B091E71020B1E951C47091C601D771CAA1E7108
     NUM_DATA_BLOCKS: 1
         NUM_ENTRIES: 6
       NUM_DELETIONS: 0
        RAW_KEY_SIZE: 477
      RAW_VALUE_SIZE: 278
     DATA_BLOCK_SIZE: 646
    INDEX_BLOCK_SIZE: 28
    INDEX_PARTITIONS: 0
TOP_LEVEL_INDEX_SIZE: 0
   FILTER_BLOCK_SIZE: 69
    COMPRESSION_ALGO: NULL
       CREATION_TIME: 1724913962
     OLDEST_KEY_TIME: 1724913362
       FILTER_POLICY: NULL
           NODE_NAME: node-1-001
*************************** 3. row ***************************
             DB_TYPE: data_db
            SST_NAME: 000011.sst
       COLUMN_FAMILY: 3
               LEVEL: 0
             MAX_KEY: 0000000000000003000000011D
             MIN_KEY: 00000000000000010100002711
     NUM_DATA_BLOCKS: 1
         NUM_ENTRIES: 165
       NUM_DELETIONS: 0
        RAW_KEY_SIZE: 3465
      RAW_VALUE_SIZE: 2310
     DATA_BLOCK_SIZE: 4481
    INDEX_BLOCK_SIZE: 28
    INDEX_PARTITIONS: 0
TOP_LEVEL_INDEX_SIZE: 0
   FILTER_BLOCK_SIZE: 0
    COMPRESSION_ALGO: NULL
       CREATION_TIME: 1724913353
     OLDEST_KEY_TIME: 3
       FILTER_POLICY: NULL
           NODE_NAME: node-1-001
3 rows in set (0.00 sec)
이전 주제: TDSTORE_REPLICATION_GROUP_EVENT_INFO다음 주제: LOGSERVICE_DD_PARTITIONS

도움말 및 지원

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

피드백