首批通过分布式安全可靠测评,为关键业务系统打造
系统表 __all_virtual_table_mgr 中 table_type 的含义
更新时间:2026-05-21 01:56
在 __all_virtual_table_mgr 等系统表中,table_type 用整数数字表示,本文解释这些数字代表的含义。
适用版本
OceanBase 数据库 V3.x、V4.x 版本。
V3.x 版本的 table_type
enum TableType {
MEMTABLE = 0,
MAJOR_SSTABLE = 1,
MINOR_SSTABLE = 2, // obsoleted type after 2.2
TRANS_SSTABLE = 3, // new table type from 3.1
MULTI_VERSION_MINOR_SSTABLE = 4,
COMPLEMENT_MINOR_SSTABLE = 5, // new table type from 3.1
MULTI_VERSION_SPARSE_MINOR_SSTABLE = 6, // reserved table type
MINI_MINOR_SSTABLE = 7,
RESERVED_MINOR_SSTABLE = 8,
MAX_TABLE_TYPE
};
V4.x 版本的 table_type
enum TableType : unsigned char
{
// < memtable start from here
DATA_MEMTABLE = 0,
TX_DATA_MEMTABLE = 1,
TX_CTX_MEMTABLE = 2,
LOCK_MEMTABLE = 3,
DIRECT_LOAD_MEMTABLE = 4,
MAX_MEMTABLE_TYPE,
// < add new memtable here
// < sstable start from here
MAJOR_SSTABLE = 10, //Reuse type, also represents row store column group in column store
MINOR_SSTABLE = 11,
MINI_SSTABLE = 12,
META_MAJOR_SSTABLE = 13,
DDL_DUMP_SSTABLE = 14,
REMOTE_LOGICAL_MINOR_SSTABLE = 15,
DDL_MEM_SSTABLE = 16,
COLUMN_ORIENTED_SSTABLE = 17,
NORMAL_COLUMN_GROUP_SSTABLE = 18,
ROWKEY_COLUMN_GROUP_SSTABLE = 19,
COLUMN_ORIENTED_META_SSTABLE = 20,
DDL_MERGE_CO_SSTABLE = 21, // used for column store ddl, for base sstable
DDL_MERGE_CG_SSTABLE = 22, // used for column store ddl, for normal cg sstable, rowkey cg not supported
DDL_MEM_CO_SSTABLE = 23,
DDL_MEM_CG_SSTABLE = 24,
DDL_MEM_MINI_SSTABLE = 25,
MDS_MINI_SSTABLE = 26,
MDS_MINOR_SSTABLE = 27,
MICRO_MINI_SSTABLE = 28,
INC_MAJOR_SSTABLE = 29,
INC_COLUMN_ORIENTED_SSTABLE = 30,
INC_NORMAL_COLUMN_GROUP_SSTABLE = 31,
INC_ROWKEY_COLUMN_GROUP_SSTABLE = 32,
INC_MAJOR_DDL_DUMP_SSTABLE = 33,
INC_MAJOR_DDL_MERGE_CO_SSTABLE = 34,
INC_MAJOR_DDL_MERGE_CG_SSTABLE = 35,
INC_MAJOR_DDL_MEM_CO_SSTABLE = 36,
INC_MAJOR_DDL_MEM_CG_SSTABLE = 37,
INC_MAJOR_DDL_MEM_SSTABLE = 38,
INC_MAJOR_DDL_AGGREGATE_CO_SSTABLE = 39,
INC_MAJOR_DDL_AGGREGATE_CG_SSTABLE = 40,
MAX_TABLE_TYPE
};