tencent cloud

TDSQL Boundless

DocumentationTDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMATDSTORE_CF_OPTIONS

TDSTORE_CF_OPTIONS

PDF
Focus Mode
Font Size
Last updated: 2026-02-10 11:06:30

Function

INFORMATION_SCHEMA.TDSTORE_CF_OPTIONS is used to display the configuration options related to ColumnFamily in SQLEngine.

Field Description

Field Name
Type
Description
DB_TYPE
VARCHAR(193)
The RocksDB type supports data_db, multi_raft_db, and monitor_info_db.
CF_NAME
VARCHAR(193)
The name of the ColumnFamily.
OPTION_TYPE
VARCHAR(193)
Name of the configuration option.
VALUE
VARCHAR(193)
Value of the configuration option.
NODE_NAME
VARCHAR(513)
Name of the SQLEngine node.

Examples

tdsql>select * from tdstore_cf_options\\G
*************************** 1. row ***************************
    DB_TYPE: data_db
    CF_NAME: default
OPTION_TYPE: COMPARATOR
      VALUE: leveldb.BytewiseComparator
  NODE_NAME: node-1-001
*************************** 2. row ***************************
    DB_TYPE: data_db
    CF_NAME: default
OPTION_TYPE: COMPACTION_FILTER
      VALUE: NULL
  NODE_NAME: node-1-001
*************************** 3. row ***************************
    DB_TYPE: data_db
    CF_NAME: default
OPTION_TYPE: COMPACTION_FILTER_FACTORY
      VALUE: NULL
  NODE_NAME: node-1-001
*************************** 4. row ***************************
    DB_TYPE: data_db
    CF_NAME: default
OPTION_TYPE: WRITE_BUFFER_SIZE
      VALUE: 67108864
  NODE_NAME: node-1-001
*************************** 5. row ***************************
    DB_TYPE: data_db
    CF_NAME: default
OPTION_TYPE: MAX_WRITE_BUFFER_NUMBER
      VALUE: 2
  NODE_NAME: node-1-001
*************************** 6. row ***************************
    DB_TYPE: data_db
    CF_NAME: default
OPTION_TYPE: MIN_WRITE_BUFFER_NUMBER_TO_MERGE
      VALUE: 1
  NODE_NAME: node-1-001
*************************** 7. row ***************************
    DB_TYPE: data_db
    CF_NAME: default
OPTION_TYPE: NUM_LEVELS
      VALUE: 7
  NODE_NAME: node-1-001
*************************** 8. row ***************************
    DB_TYPE: data_db
    CF_NAME: default
OPTION_TYPE: LEVEL0_FILE_NUM_COMPACTION_TRIGGER
      VALUE: 4
  NODE_NAME: node-1-001
*************************** 9. row ***************************
    DB_TYPE: data_db
    CF_NAME: default
OPTION_TYPE: LEVEL0_SLOWDOWN_WRITES_TRIGGER
      VALUE: 20
  NODE_NAME: node-1-001
*************************** 10. row ***************************
    DB_TYPE: data_db
    CF_NAME: default
OPTION_TYPE: LEVEL0_STOP_WRITES_TRIGGER
      VALUE: 36
  NODE_NAME: node-1-001
Previous Topic: TDSTORE_BULK_LOAD_TXN_INFONext Topic: TDSTORE_COMMON_EVENT_INFO

Help and Support

Was this page helpful?

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

Feedback