Query INFORMATION_SCHEMA.MYROCKS_TABLES. These system tables provide metadata about MyRocks tables, including their storage, compression, and other properties for performance analysis.
The Information Schema ROCKSDB_CF_OPTIONS table is included as part of the MyRocks storage engine, and contains infomation about MyRocks column families.
The PROCESS privilege is required to view the table.
It contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_CFSTATS table is included as part of the MyRocks storage engine.
The PROCESS privilege is required to view the table.
It contains the following columns:
CF_NAME
STAT_TYPE
VALUE
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_COMPACTION_STATS table is included as part of the MyRocks storage engine.
The PROCESS privilege is required to view the table.
It contains the following columns:
CF_NAME
LEVEL
TYPE
VALUE
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_DBSTATS table is included as part of the MyRocks storage engine.
The PROCESS privilege is required to view the table.
It contains the following columns:
STAT_TYPE
VALUE
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_DDL table is included as part of the MyRocks storage engine.
The PROCESS privilege is required to view the table.
It contains the following columns:
TABLE_SCHEMA
TABLE_NAME
PARTITION_NAME
INDEX_NAME
COLUMN_FAMILY
INDEX_NUMBER
INDEX_TYPE
KV_FORMAT_VERSION
TTL_DURATION
INDEX_FLAGS
CF
AUTO_INCREMENT
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_DEADLOCK table is included as part of the MyRocks storage engine.
The PROCESS privilege is required to view the table.
It contains the following columns:
DEADLOCK_ID
TIMESTAMP
TRANSACTION_ID
CF_NAME
WAITING_KEY
LOCK_TYPE
INDEX_NAME
TABLE_NAME
ROLLED_BACK
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_GLOBAL_INFO table is included as part of the MyRocks storage engine.
The PROCESS privilege is required to view the table.
It contains the following columns:
TYPE
NAME
VALUE
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_INDEX_FILE_MAP table is included as part of the MyRocks storage engine.
The PROCESS privilege is required to view the table.
It contains the following columns:
COLUMN_FAMILY
INDEX_NUMBER
SST_NAME
NUM_ROWS
DATA_SIZE
ENTRY_DELETES
ENTRY_SINGLEDELETES
ENTRY_MERGES
ENTRY_OTHERS
DISTINCT_KEYS_PREFIX
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_LOCKS table is included as part of the MyRocks storage engine.
The PROCESS privilege is required to view the table.
It contains the following columns:
COLUMN_FAMILY_ID
TRANSACTION_ID
KEY
MODE
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_PERF_CONTEXT table is included as part of the MyRocks storage engine and includes per-table/partition counters .
The PROCESS privilege is required to view the table.
It contains the following columns:
TABLE_SCHEMA
TABLE_NAME
PARTITION_NAME
STAT_TYPE
VALUE
Note: for multi-table queries, all counter increments are "billed" to the first table in the query:1018
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_PERF_CONTEXT_GLOBAL table is included as part of the MyRocks storage engine and includes global counter information.
The PROCESS privilege is required to view the table.
It contains the following columns:
STAT_TYPE
VALUE
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_SST_PROPS table is included as part of the MyRocks storage engine.
The PROCESS privilege is required to view the table.
It contains the following columns:
SST_NAME
COLUMN_FAMILY
DATA_BLOCKS
ENTRIES
RAW_KEY_SIZE
RAW_VALUE_SIZE
DATA_BLOCK_SIZE
INDEX_BLOCK_SIZE
INDEX_PARTITIONS
TOP_LEVEL_INDEX_SIZE
FILTER_BLOCK_SIZE
COMPRESSION_ALGO
CREATION_TIME
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_TRX table is included as part of the MyRocks storage engine.
The PROCESS privilege is required to view the table.
It contains the following columns:
TRANSACTION_ID
STATE
NAME
WRITE_COUNT
LOCK_COUNT
TIMEOUT_SEC
WAITING_KEY
WAITING_COLUMN_FAMILY_ID
IS_REPLICATION
SKIP_TRX_API
READ_ONLY
HAS_DEADLOCK_DETECTION
NUM_ONGOING_BULKLOAD
THREAD_ID
QUERY
This page is licensed: CC BY-SA / Gnu FDL