Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
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 contains information about MyRocks column families, such as the column family name and option type.
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:
CF_NAME
name.
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_COMPACTION_STATS table contains statistics about compaction operations performed by the RocksDB engine.
The ROCKSDB_COMPACTION_STATS table is included as part of the storage engine.
The PROCESS is required to view the table.
It contains the following columns:
TYPE
VALUE
This page is licensed: CC BY-SA / Gnu FDL
CF_NAME
LEVEL
OPTION_TYPE
VALUE
The Information Schema ROCKSDB_DBSTATS table displays database-level statistics for the MyRocks storage engine.
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_GLOBAL_INFO table contains global configuration information for the MyRocks storage engine.
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
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_PERF_CONTEXT_GLOBAL table aggregates performance counters from all sessions, offering a global view of MyRocks performance.
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
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_SST_PROPS table displays properties of SST files, such as data size and compression ratios, for MyRocks tables.
The ROCKSDB_SST_PROPS table is included as part of the storage engine.
The PROCESS is required to view the table.
It contains the following columns:
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
SST_NAME
COLUMN_FAMILY
NAME
VALUE
VALUE
The Information Schema ROCKSDB_TRX table provides information about active transactions in MyRocks, including transaction IDs and states.
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
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_DDL table contains information about Data Definition Language (DDL) operations in MyRocks, including table and index names.
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
This page is licensed: CC BY-SA / Gnu FDL
The Information Schema ROCKSDB_INDEX_FILE_MAP table maps MyRocks indexes to their corresponding SST files, useful for understanding data storage.
The ROCKSDB_INDEX_FILE_MAP table is included as part of the storage engine.
The PROCESS is required to view the table.
It contains the following columns:
The Information Schema ROCKSDB_LOCKS table displays information about locks currently held or requested by MyRocks transactions.
The ROCKSDB_LOCKS table is included as part of the storage engine.
The PROCESS is required to view the table.
It contains the following columns:
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
TABLE_NAME
PARTITION_NAME
INDEX_NAME
COLUMN_FAMILY
INDEX_NUMBER
INDEX_TYPE
KV_FORMAT_VERSION
TTL_DURATION
INDEX_FLAGS
CF
AUTO_INCREMENT
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
COLUMN_FAMILY
INDEX_NUMBER
KEY
MODE
This page is licensed: CC BY-SA / Gnu FDL
COLUMN_FAMILY_ID
TRANSACTION_ID
The Information Schema ROCKSDB_PERF_CONTEXT table contains performance counters for the current session, providing granular metrics on RocksDB operations.
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
Note: for multi-table queries, all counter increments are "billed" to the first table in the query:
This page is licensed: CC BY-SA / Gnu FDL
TABLE_NAME
PARTITION_NAME
STAT_TYPE
VALUE
The Information Schema ROCKSDB_DEADLOCK table provides information about deadlocks that have occurred within the MyRocks storage engine.
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
This page is licensed: CC BY-SA / Gnu FDL
TIMESTAMP
TRANSACTION_ID
CF_NAME
WAITING_KEY
LOCK_TYPE
INDEX_NAME
TABLE_NAME
ROLLED_BACK
The Information Schema ROCKSDB_CFSTATS table provides statistics for each column family in the MyRocks storage engine.
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
This page is licensed: CC BY-SA / Gnu FDL
STAT_TYPE
VALUE