简介

InnoDB 与 RocksDB schema 对比,涉及到存储引擎级别的表(从 information_schema 库获取),

  • 只有2个表有重合名字(仅仅名字重合而已,字段基本不同) INNODB_LOCKS vs ROCKSDB_LOCKS, INNODB_TRX vs ROCKSDB_TRX;
  • 其他的都是自己独有的

InnoDB 独有的表:

 INNODB_BUFFER_PAGE
 INNODB_BUFFER_PAGE_LRU
 INNODB_BUFFER_POOL_STATS
 INNODB_CMP
 INNODB_CMPMEM
 INNODB_CMPMEM_RESET
 INNODB_CMP_PER_INDEX
 INNODB_CMP_PER_INDEX_RESET
 INNODB_CMP_RESET
 INNODB_FILE_STATUS
 INNODB_FT_BEING_DELETED
 INNODB_FT_CONFIG
 INNODB_FT_DEFAULT_STOPWORD
 INNODB_FT_DELETED
 INNODB_FT_INDEX_CACHE
 INNODB_FT_INDEX_TABLE
 INNODB_LOCK_WAITS
 INNODB_METRICS
 INNODB_SYS_COLUMNS
 INNODB_SYS_DATAFILES
 INNODB_SYS_DOCSTORE_FIELDS
 INNODB_SYS_FIELDS
 INNODB_SYS_FOREIGN
 INNODB_SYS_FOREIGN_COLS
 INNODB_SYS_INDEXES
 INNODB_SYS_TABLES
 INNODB_SYS_TABLESPACES
 INNODB_SYS_TABLESTATS

RocksDB 独有的表:

 ROCKSDB_CF_OPTIONS
 ROCKSDB_CFSTATS
 ROCKSDB_COMPACTION_STATS
 ROCKSDB_DBSTATS
 ROCKSDB_DDL
 ROCKSDB_DEADLOCK
 ROCKSDB_GLOBAL_INFO
 ROCKSDB_INDEX_FILE_MAP
 ROCKSDB_PERF_CONTEXT
 ROCKSDB_PERF_CONTEXT_GLOBAL
 ROCKSDB_TF_OPTIONS

results matching ""

    No results matching ""

    results matching ""

      No results matching ""