Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
INFORMATION_SCHEMA.TDSTORE_CF_OPTIONS is used to display the configuration options related to ColumnFamily in SQLEngine.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. |
tdsql>select * from tdstore_cf_options\\G*************************** 1. row ***************************DB_TYPE: data_dbCF_NAME: defaultOPTION_TYPE: COMPARATORVALUE: leveldb.BytewiseComparatorNODE_NAME: node-1-001*************************** 2. row ***************************DB_TYPE: data_dbCF_NAME: defaultOPTION_TYPE: COMPACTION_FILTERVALUE: NULLNODE_NAME: node-1-001*************************** 3. row ***************************DB_TYPE: data_dbCF_NAME: defaultOPTION_TYPE: COMPACTION_FILTER_FACTORYVALUE: NULLNODE_NAME: node-1-001*************************** 4. row ***************************DB_TYPE: data_dbCF_NAME: defaultOPTION_TYPE: WRITE_BUFFER_SIZEVALUE: 67108864NODE_NAME: node-1-001*************************** 5. row ***************************DB_TYPE: data_dbCF_NAME: defaultOPTION_TYPE: MAX_WRITE_BUFFER_NUMBERVALUE: 2NODE_NAME: node-1-001*************************** 6. row ***************************DB_TYPE: data_dbCF_NAME: defaultOPTION_TYPE: MIN_WRITE_BUFFER_NUMBER_TO_MERGEVALUE: 1NODE_NAME: node-1-001*************************** 7. row ***************************DB_TYPE: data_dbCF_NAME: defaultOPTION_TYPE: NUM_LEVELSVALUE: 7NODE_NAME: node-1-001*************************** 8. row ***************************DB_TYPE: data_dbCF_NAME: defaultOPTION_TYPE: LEVEL0_FILE_NUM_COMPACTION_TRIGGERVALUE: 4NODE_NAME: node-1-001*************************** 9. row ***************************DB_TYPE: data_dbCF_NAME: defaultOPTION_TYPE: LEVEL0_SLOWDOWN_WRITES_TRIGGERVALUE: 20NODE_NAME: node-1-001*************************** 10. row ***************************DB_TYPE: data_dbCF_NAME: defaultOPTION_TYPE: LEVEL0_STOP_WRITES_TRIGGERVALUE: 36NODE_NAME: node-1-001
피드백