diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/r/show_engine.result')
| -rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/show_engine.result | 491 |
1 files changed, 491 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/show_engine.result b/storage/rocksdb/mysql-test/rocksdb/r/show_engine.result new file mode 100644 index 00000000..eac329a2 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/show_engine.result @@ -0,0 +1,491 @@ +DROP TABLE IF EXISTS t1; +DROP TABLE IF EXISTS t2; +DROP TABLE IF EXISTS t3; +DROP TABLE IF EXISTS t4; +CREATE TABLE t1 (i INT, PRIMARY KEY (i) COMMENT 'cf_t1') ENGINE = ROCKSDB; +CREATE TABLE t2 (j INT, PRIMARY KEY (j) COMMENT 'rev:cf_t2') ENGINE = ROCKSDB; +CREATE TABLE t3 (k INT, PRIMARY KEY (k) COMMENT 'cf_t1') ENGINE = ROCKSDB; +CREATE TABLE t4 (l INT, PRIMARY KEY (l) COMMENT 'cf_t4') ENGINE = ROCKSDB +PARTITION BY KEY(l) PARTITIONS 4; +SET @save.rocksdb_max_background_jobs= @@global.rocksdb_max_background_jobs; +SET GLOBAL rocksdb_max_background_jobs= 1; +INSERT INTO t1 VALUES (1), (2), (3); +SELECT COUNT(*) FROM t1; +COUNT(*) +3 +INSERT INTO t2 VALUES (1), (2), (3), (4); +SELECT COUNT(*) FROM t2; +COUNT(*) +4 +INSERT INTO t4 VALUES (1), (2), (3), (4), (5); +SELECT COUNT(*) FROM t4; +COUNT(*) +5 +SET GLOBAL rocksdb_force_flush_memtable_now=1; +SET GLOBAL rocksdb_compact_cf="cf_t1"; +SHOW ENGINE rocksdb STATUS; +Type Name Status +STATISTICS # # +DBSTATS # # +CF_COMPACTION # # +CF_COMPACTION # # +CF_COMPACTION # # +CF_COMPACTION # # +MEMORY_STATS # # +BG_THREADS # # +BG_THREADS # # +SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_CFSTATS; +CF_NAME STAT_TYPE VALUE +__system__ NUM_IMMUTABLE_MEM_TABLE # +__system__ MEM_TABLE_FLUSH_PENDING # +__system__ COMPACTION_PENDING # +__system__ CUR_SIZE_ACTIVE_MEM_TABLE # +__system__ CUR_SIZE_ALL_MEM_TABLES # +__system__ NUM_ENTRIES_ACTIVE_MEM_TABLE # +__system__ NUM_ENTRIES_IMM_MEM_TABLES # +__system__ NON_BLOCK_CACHE_SST_MEM_USAGE # +__system__ NUM_LIVE_VERSIONS # +cf_t1 NUM_IMMUTABLE_MEM_TABLE # +cf_t1 MEM_TABLE_FLUSH_PENDING # +cf_t1 COMPACTION_PENDING # +cf_t1 CUR_SIZE_ACTIVE_MEM_TABLE # +cf_t1 CUR_SIZE_ALL_MEM_TABLES # +cf_t1 NUM_ENTRIES_ACTIVE_MEM_TABLE # +cf_t1 NUM_ENTRIES_IMM_MEM_TABLES # +cf_t1 NON_BLOCK_CACHE_SST_MEM_USAGE # +cf_t1 NUM_LIVE_VERSIONS # +default NUM_IMMUTABLE_MEM_TABLE # +default MEM_TABLE_FLUSH_PENDING # +default COMPACTION_PENDING # +default CUR_SIZE_ACTIVE_MEM_TABLE # +default CUR_SIZE_ALL_MEM_TABLES # +default NUM_ENTRIES_ACTIVE_MEM_TABLE # +default NUM_ENTRIES_IMM_MEM_TABLES # +default NON_BLOCK_CACHE_SST_MEM_USAGE # +default NUM_LIVE_VERSIONS # +rev:cf_t2 NUM_IMMUTABLE_MEM_TABLE # +rev:cf_t2 MEM_TABLE_FLUSH_PENDING # +rev:cf_t2 COMPACTION_PENDING # +rev:cf_t2 CUR_SIZE_ACTIVE_MEM_TABLE # +rev:cf_t2 CUR_SIZE_ALL_MEM_TABLES # +rev:cf_t2 NUM_ENTRIES_ACTIVE_MEM_TABLE # +rev:cf_t2 NUM_ENTRIES_IMM_MEM_TABLES # +rev:cf_t2 NON_BLOCK_CACHE_SST_MEM_USAGE # +rev:cf_t2 NUM_LIVE_VERSIONS # +SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_DBSTATS; +STAT_TYPE VALUE +DB_BACKGROUND_ERRORS # +DB_NUM_SNAPSHOTS # +DB_OLDEST_SNAPSHOT_TIME # +DB_BLOCK_CACHE_USAGE # +SELECT TABLE_SCHEMA, TABLE_NAME, PARTITION_NAME, COUNT(STAT_TYPE) +FROM INFORMATION_SCHEMA.ROCKSDB_PERF_CONTEXT +WHERE TABLE_SCHEMA = 'test' +GROUP BY TABLE_NAME, PARTITION_NAME; +TABLE_SCHEMA TABLE_NAME PARTITION_NAME COUNT(STAT_TYPE) +test t1 NULL 57 +test t2 NULL 57 +test t4 p0 57 +test t4 p1 57 +test t4 p2 57 +test t4 p3 57 +SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_CF_OPTIONS; +CF_NAME OPTION_TYPE VALUE +__system__ COMPARATOR # +__system__ MERGE_OPERATOR # +__system__ COMPACTION_FILTER # +__system__ COMPACTION_FILTER_FACTORY # +__system__ WRITE_BUFFER_SIZE # +__system__ MAX_WRITE_BUFFER_NUMBER # +__system__ MIN_WRITE_BUFFER_NUMBER_TO_MERGE # +__system__ NUM_LEVELS # +__system__ LEVEL0_FILE_NUM_COMPACTION_TRIGGER # +__system__ LEVEL0_SLOWDOWN_WRITES_TRIGGER # +__system__ LEVEL0_STOP_WRITES_TRIGGER # +__system__ MAX_MEM_COMPACTION_LEVEL # +__system__ TARGET_FILE_SIZE_BASE # +__system__ TARGET_FILE_SIZE_MULTIPLIER # +__system__ MAX_BYTES_FOR_LEVEL_BASE # +__system__ LEVEL_COMPACTION_DYNAMIC_LEVEL_BYTES # +__system__ MAX_BYTES_FOR_LEVEL_MULTIPLIER # +__system__ SOFT_RATE_LIMIT # +__system__ HARD_RATE_LIMIT # +__system__ RATE_LIMIT_DELAY_MAX_MILLISECONDS # +__system__ ARENA_BLOCK_SIZE # +__system__ DISABLE_AUTO_COMPACTIONS # +__system__ PURGE_REDUNDANT_KVS_WHILE_FLUSH # +__system__ MAX_SEQUENTIAL_SKIP_IN_ITERATIONS # +__system__ MEMTABLE_FACTORY # +__system__ INPLACE_UPDATE_SUPPORT # +__system__ INPLACE_UPDATE_NUM_LOCKS # +__system__ MEMTABLE_PREFIX_BLOOM_BITS_RATIO # +__system__ MEMTABLE_PREFIX_BLOOM_HUGE_PAGE_TLB_SIZE # +__system__ BLOOM_LOCALITY # +__system__ MAX_SUCCESSIVE_MERGES # +__system__ OPTIMIZE_FILTERS_FOR_HITS # +__system__ MAX_BYTES_FOR_LEVEL_MULTIPLIER_ADDITIONAL # +__system__ COMPRESSION_TYPE # +__system__ COMPRESSION_PER_LEVEL # +__system__ COMPRESSION_OPTS # +__system__ BOTTOMMOST_COMPRESSION # +__system__ PREFIX_EXTRACTOR # +__system__ COMPACTION_STYLE # +__system__ COMPACTION_OPTIONS_UNIVERSAL # +__system__ COMPACTION_OPTION_FIFO::MAX_TABLE_FILES_SIZE # +__system__ TABLE_FACTORY::FLUSH_BLOCK_POLICY_FACTORY # +__system__ TABLE_FACTORY::CACHE_INDEX_AND_FILTER_BLOCKS # +__system__ TABLE_FACTORY::CACHE_INDEX_AND_FILTER_BLOCKS_WITH_HIGH_PRIORITY # +__system__ TABLE_FACTORY::PIN_L0_FILTER_AND_INDEX_BLOCKS_IN_CACHE # +__system__ TABLE_FACTORY::PIN_TOP_LEVEL_INDEX_AND_FILTER # +__system__ TABLE_FACTORY::INDEX_TYPE # +__system__ TABLE_FACTORY::DATA_BLOCK_INDEX_TYPE # +__system__ TABLE_FACTORY::INDEX_SHORTENING # +__system__ TABLE_FACTORY::DATA_BLOCK_HASH_TABLE_UTIL_RATIO # +__system__ TABLE_FACTORY::HASH_INDEX_ALLOW_COLLISION # +__system__ TABLE_FACTORY::CHECKSUM # +__system__ TABLE_FACTORY::NO_BLOCK_CACHE # +__system__ TABLE_FACTORY::BLOCK_CACHE # +__system__ TABLE_FACTORY::BLOCK_CACHE_NAME # +__system__ TABLE_FACTORY::BLOCK_CACHE_OPTIONS # +__system__ TABLE_FACTORY::CAPACITY # +__system__ TABLE_FACTORY::NUM_SHARD_BITS # +__system__ TABLE_FACTORY::STRICT_CAPACITY_LIMIT # +__system__ TABLE_FACTORY::MEMORY_ALLOCATOR # +__system__ TABLE_FACTORY::HIGH_PRI_POOL_RATIO # +__system__ TABLE_FACTORY::BLOCK_CACHE_COMPRESSED # +__system__ TABLE_FACTORY::PERSISTENT_CACHE # +__system__ TABLE_FACTORY::BLOCK_SIZE # +__system__ TABLE_FACTORY::BLOCK_SIZE_DEVIATION # +__system__ TABLE_FACTORY::BLOCK_RESTART_INTERVAL # +__system__ TABLE_FACTORY::INDEX_BLOCK_RESTART_INTERVAL # +__system__ TABLE_FACTORY::METADATA_BLOCK_SIZE # +__system__ TABLE_FACTORY::PARTITION_FILTERS # +__system__ TABLE_FACTORY::USE_DELTA_ENCODING # +__system__ TABLE_FACTORY::FILTER_POLICY # +__system__ TABLE_FACTORY::WHOLE_KEY_FILTERING # +__system__ TABLE_FACTORY::VERIFY_COMPRESSION # +__system__ TABLE_FACTORY::READ_AMP_BYTES_PER_BIT # +__system__ TABLE_FACTORY::FORMAT_VERSION # +__system__ TABLE_FACTORY::ENABLE_INDEX_COMPRESSION # +__system__ TABLE_FACTORY::BLOCK_ALIGN # +cf_t1 COMPARATOR # +cf_t1 MERGE_OPERATOR # +cf_t1 COMPACTION_FILTER # +cf_t1 COMPACTION_FILTER_FACTORY # +cf_t1 WRITE_BUFFER_SIZE # +cf_t1 MAX_WRITE_BUFFER_NUMBER # +cf_t1 MIN_WRITE_BUFFER_NUMBER_TO_MERGE # +cf_t1 NUM_LEVELS # +cf_t1 LEVEL0_FILE_NUM_COMPACTION_TRIGGER # +cf_t1 LEVEL0_SLOWDOWN_WRITES_TRIGGER # +cf_t1 LEVEL0_STOP_WRITES_TRIGGER # +cf_t1 MAX_MEM_COMPACTION_LEVEL # +cf_t1 TARGET_FILE_SIZE_BASE # +cf_t1 TARGET_FILE_SIZE_MULTIPLIER # +cf_t1 MAX_BYTES_FOR_LEVEL_BASE # +cf_t1 LEVEL_COMPACTION_DYNAMIC_LEVEL_BYTES # +cf_t1 MAX_BYTES_FOR_LEVEL_MULTIPLIER # +cf_t1 SOFT_RATE_LIMIT # +cf_t1 HARD_RATE_LIMIT # +cf_t1 RATE_LIMIT_DELAY_MAX_MILLISECONDS # +cf_t1 ARENA_BLOCK_SIZE # +cf_t1 DISABLE_AUTO_COMPACTIONS # +cf_t1 PURGE_REDUNDANT_KVS_WHILE_FLUSH # +cf_t1 MAX_SEQUENTIAL_SKIP_IN_ITERATIONS # +cf_t1 MEMTABLE_FACTORY # +cf_t1 INPLACE_UPDATE_SUPPORT # +cf_t1 INPLACE_UPDATE_NUM_LOCKS # +cf_t1 MEMTABLE_PREFIX_BLOOM_BITS_RATIO # +cf_t1 MEMTABLE_PREFIX_BLOOM_HUGE_PAGE_TLB_SIZE # +cf_t1 BLOOM_LOCALITY # +cf_t1 MAX_SUCCESSIVE_MERGES # +cf_t1 OPTIMIZE_FILTERS_FOR_HITS # +cf_t1 MAX_BYTES_FOR_LEVEL_MULTIPLIER_ADDITIONAL # +cf_t1 COMPRESSION_TYPE # +cf_t1 COMPRESSION_PER_LEVEL # +cf_t1 COMPRESSION_OPTS # +cf_t1 BOTTOMMOST_COMPRESSION # +cf_t1 PREFIX_EXTRACTOR # +cf_t1 COMPACTION_STYLE # +cf_t1 COMPACTION_OPTIONS_UNIVERSAL # +cf_t1 COMPACTION_OPTION_FIFO::MAX_TABLE_FILES_SIZE # +cf_t1 TABLE_FACTORY::FLUSH_BLOCK_POLICY_FACTORY # +cf_t1 TABLE_FACTORY::CACHE_INDEX_AND_FILTER_BLOCKS # +cf_t1 TABLE_FACTORY::CACHE_INDEX_AND_FILTER_BLOCKS_WITH_HIGH_PRIORITY # +cf_t1 TABLE_FACTORY::PIN_L0_FILTER_AND_INDEX_BLOCKS_IN_CACHE # +cf_t1 TABLE_FACTORY::PIN_TOP_LEVEL_INDEX_AND_FILTER # +cf_t1 TABLE_FACTORY::INDEX_TYPE # +cf_t1 TABLE_FACTORY::DATA_BLOCK_INDEX_TYPE # +cf_t1 TABLE_FACTORY::INDEX_SHORTENING # +cf_t1 TABLE_FACTORY::DATA_BLOCK_HASH_TABLE_UTIL_RATIO # +cf_t1 TABLE_FACTORY::HASH_INDEX_ALLOW_COLLISION # +cf_t1 TABLE_FACTORY::CHECKSUM # +cf_t1 TABLE_FACTORY::NO_BLOCK_CACHE # +cf_t1 TABLE_FACTORY::BLOCK_CACHE # +cf_t1 TABLE_FACTORY::BLOCK_CACHE_NAME # +cf_t1 TABLE_FACTORY::BLOCK_CACHE_OPTIONS # +cf_t1 TABLE_FACTORY::CAPACITY # +cf_t1 TABLE_FACTORY::NUM_SHARD_BITS # +cf_t1 TABLE_FACTORY::STRICT_CAPACITY_LIMIT # +cf_t1 TABLE_FACTORY::MEMORY_ALLOCATOR # +cf_t1 TABLE_FACTORY::HIGH_PRI_POOL_RATIO # +cf_t1 TABLE_FACTORY::BLOCK_CACHE_COMPRESSED # +cf_t1 TABLE_FACTORY::PERSISTENT_CACHE # +cf_t1 TABLE_FACTORY::BLOCK_SIZE # +cf_t1 TABLE_FACTORY::BLOCK_SIZE_DEVIATION # +cf_t1 TABLE_FACTORY::BLOCK_RESTART_INTERVAL # +cf_t1 TABLE_FACTORY::INDEX_BLOCK_RESTART_INTERVAL # +cf_t1 TABLE_FACTORY::METADATA_BLOCK_SIZE # +cf_t1 TABLE_FACTORY::PARTITION_FILTERS # +cf_t1 TABLE_FACTORY::USE_DELTA_ENCODING # +cf_t1 TABLE_FACTORY::FILTER_POLICY # +cf_t1 TABLE_FACTORY::WHOLE_KEY_FILTERING # +cf_t1 TABLE_FACTORY::VERIFY_COMPRESSION # +cf_t1 TABLE_FACTORY::READ_AMP_BYTES_PER_BIT # +cf_t1 TABLE_FACTORY::FORMAT_VERSION # +cf_t1 TABLE_FACTORY::ENABLE_INDEX_COMPRESSION # +cf_t1 TABLE_FACTORY::BLOCK_ALIGN # +default COMPARATOR # +default MERGE_OPERATOR # +default COMPACTION_FILTER # +default COMPACTION_FILTER_FACTORY # +default WRITE_BUFFER_SIZE # +default MAX_WRITE_BUFFER_NUMBER # +default MIN_WRITE_BUFFER_NUMBER_TO_MERGE # +default NUM_LEVELS # +default LEVEL0_FILE_NUM_COMPACTION_TRIGGER # +default LEVEL0_SLOWDOWN_WRITES_TRIGGER # +default LEVEL0_STOP_WRITES_TRIGGER # +default MAX_MEM_COMPACTION_LEVEL # +default TARGET_FILE_SIZE_BASE # +default TARGET_FILE_SIZE_MULTIPLIER # +default MAX_BYTES_FOR_LEVEL_BASE # +default LEVEL_COMPACTION_DYNAMIC_LEVEL_BYTES # +default MAX_BYTES_FOR_LEVEL_MULTIPLIER # +default SOFT_RATE_LIMIT # +default HARD_RATE_LIMIT # +default RATE_LIMIT_DELAY_MAX_MILLISECONDS # +default ARENA_BLOCK_SIZE # +default DISABLE_AUTO_COMPACTIONS # +default PURGE_REDUNDANT_KVS_WHILE_FLUSH # +default MAX_SEQUENTIAL_SKIP_IN_ITERATIONS # +default MEMTABLE_FACTORY # +default INPLACE_UPDATE_SUPPORT # +default INPLACE_UPDATE_NUM_LOCKS # +default MEMTABLE_PREFIX_BLOOM_BITS_RATIO # +default MEMTABLE_PREFIX_BLOOM_HUGE_PAGE_TLB_SIZE # +default BLOOM_LOCALITY # +default MAX_SUCCESSIVE_MERGES # +default OPTIMIZE_FILTERS_FOR_HITS # +default MAX_BYTES_FOR_LEVEL_MULTIPLIER_ADDITIONAL # +default COMPRESSION_TYPE # +default COMPRESSION_PER_LEVEL # +default COMPRESSION_OPTS # +default BOTTOMMOST_COMPRESSION # +default PREFIX_EXTRACTOR # +default COMPACTION_STYLE # +default COMPACTION_OPTIONS_UNIVERSAL # +default COMPACTION_OPTION_FIFO::MAX_TABLE_FILES_SIZE # +default TABLE_FACTORY::FLUSH_BLOCK_POLICY_FACTORY # +default TABLE_FACTORY::CACHE_INDEX_AND_FILTER_BLOCKS # +default TABLE_FACTORY::CACHE_INDEX_AND_FILTER_BLOCKS_WITH_HIGH_PRIORITY # +default TABLE_FACTORY::PIN_L0_FILTER_AND_INDEX_BLOCKS_IN_CACHE # +default TABLE_FACTORY::PIN_TOP_LEVEL_INDEX_AND_FILTER # +default TABLE_FACTORY::INDEX_TYPE # +default TABLE_FACTORY::DATA_BLOCK_INDEX_TYPE # +default TABLE_FACTORY::INDEX_SHORTENING # +default TABLE_FACTORY::DATA_BLOCK_HASH_TABLE_UTIL_RATIO # +default TABLE_FACTORY::HASH_INDEX_ALLOW_COLLISION # +default TABLE_FACTORY::CHECKSUM # +default TABLE_FACTORY::NO_BLOCK_CACHE # +default TABLE_FACTORY::BLOCK_CACHE # +default TABLE_FACTORY::BLOCK_CACHE_NAME # +default TABLE_FACTORY::BLOCK_CACHE_OPTIONS # +default TABLE_FACTORY::CAPACITY # +default TABLE_FACTORY::NUM_SHARD_BITS # +default TABLE_FACTORY::STRICT_CAPACITY_LIMIT # +default TABLE_FACTORY::MEMORY_ALLOCATOR # +default TABLE_FACTORY::HIGH_PRI_POOL_RATIO # +default TABLE_FACTORY::BLOCK_CACHE_COMPRESSED # +default TABLE_FACTORY::PERSISTENT_CACHE # +default TABLE_FACTORY::BLOCK_SIZE # +default TABLE_FACTORY::BLOCK_SIZE_DEVIATION # +default TABLE_FACTORY::BLOCK_RESTART_INTERVAL # +default TABLE_FACTORY::INDEX_BLOCK_RESTART_INTERVAL # +default TABLE_FACTORY::METADATA_BLOCK_SIZE # +default TABLE_FACTORY::PARTITION_FILTERS # +default TABLE_FACTORY::USE_DELTA_ENCODING # +default TABLE_FACTORY::FILTER_POLICY # +default TABLE_FACTORY::WHOLE_KEY_FILTERING # +default TABLE_FACTORY::VERIFY_COMPRESSION # +default TABLE_FACTORY::READ_AMP_BYTES_PER_BIT # +default TABLE_FACTORY::FORMAT_VERSION # +default TABLE_FACTORY::ENABLE_INDEX_COMPRESSION # +default TABLE_FACTORY::BLOCK_ALIGN # +rev:cf_t2 COMPARATOR # +rev:cf_t2 MERGE_OPERATOR # +rev:cf_t2 COMPACTION_FILTER # +rev:cf_t2 COMPACTION_FILTER_FACTORY # +rev:cf_t2 WRITE_BUFFER_SIZE # +rev:cf_t2 MAX_WRITE_BUFFER_NUMBER # +rev:cf_t2 MIN_WRITE_BUFFER_NUMBER_TO_MERGE # +rev:cf_t2 NUM_LEVELS # +rev:cf_t2 LEVEL0_FILE_NUM_COMPACTION_TRIGGER # +rev:cf_t2 LEVEL0_SLOWDOWN_WRITES_TRIGGER # +rev:cf_t2 LEVEL0_STOP_WRITES_TRIGGER # +rev:cf_t2 MAX_MEM_COMPACTION_LEVEL # +rev:cf_t2 TARGET_FILE_SIZE_BASE # +rev:cf_t2 TARGET_FILE_SIZE_MULTIPLIER # +rev:cf_t2 MAX_BYTES_FOR_LEVEL_BASE # +rev:cf_t2 LEVEL_COMPACTION_DYNAMIC_LEVEL_BYTES # +rev:cf_t2 MAX_BYTES_FOR_LEVEL_MULTIPLIER # +rev:cf_t2 SOFT_RATE_LIMIT # +rev:cf_t2 HARD_RATE_LIMIT # +rev:cf_t2 RATE_LIMIT_DELAY_MAX_MILLISECONDS # +rev:cf_t2 ARENA_BLOCK_SIZE # +rev:cf_t2 DISABLE_AUTO_COMPACTIONS # +rev:cf_t2 PURGE_REDUNDANT_KVS_WHILE_FLUSH # +rev:cf_t2 MAX_SEQUENTIAL_SKIP_IN_ITERATIONS # +rev:cf_t2 MEMTABLE_FACTORY # +rev:cf_t2 INPLACE_UPDATE_SUPPORT # +rev:cf_t2 INPLACE_UPDATE_NUM_LOCKS # +rev:cf_t2 MEMTABLE_PREFIX_BLOOM_BITS_RATIO # +rev:cf_t2 MEMTABLE_PREFIX_BLOOM_HUGE_PAGE_TLB_SIZE # +rev:cf_t2 BLOOM_LOCALITY # +rev:cf_t2 MAX_SUCCESSIVE_MERGES # +rev:cf_t2 OPTIMIZE_FILTERS_FOR_HITS # +rev:cf_t2 MAX_BYTES_FOR_LEVEL_MULTIPLIER_ADDITIONAL # +rev:cf_t2 COMPRESSION_TYPE # +rev:cf_t2 COMPRESSION_PER_LEVEL # +rev:cf_t2 COMPRESSION_OPTS # +rev:cf_t2 BOTTOMMOST_COMPRESSION # +rev:cf_t2 PREFIX_EXTRACTOR # +rev:cf_t2 COMPACTION_STYLE # +rev:cf_t2 COMPACTION_OPTIONS_UNIVERSAL # +rev:cf_t2 COMPACTION_OPTION_FIFO::MAX_TABLE_FILES_SIZE # +rev:cf_t2 TABLE_FACTORY::FLUSH_BLOCK_POLICY_FACTORY # +rev:cf_t2 TABLE_FACTORY::CACHE_INDEX_AND_FILTER_BLOCKS # +rev:cf_t2 TABLE_FACTORY::CACHE_INDEX_AND_FILTER_BLOCKS_WITH_HIGH_PRIORITY # +rev:cf_t2 TABLE_FACTORY::PIN_L0_FILTER_AND_INDEX_BLOCKS_IN_CACHE # +rev:cf_t2 TABLE_FACTORY::PIN_TOP_LEVEL_INDEX_AND_FILTER # +rev:cf_t2 TABLE_FACTORY::INDEX_TYPE # +rev:cf_t2 TABLE_FACTORY::DATA_BLOCK_INDEX_TYPE # +rev:cf_t2 TABLE_FACTORY::INDEX_SHORTENING # +rev:cf_t2 TABLE_FACTORY::DATA_BLOCK_HASH_TABLE_UTIL_RATIO # +rev:cf_t2 TABLE_FACTORY::HASH_INDEX_ALLOW_COLLISION # +rev:cf_t2 TABLE_FACTORY::CHECKSUM # +rev:cf_t2 TABLE_FACTORY::NO_BLOCK_CACHE # +rev:cf_t2 TABLE_FACTORY::BLOCK_CACHE # +rev:cf_t2 TABLE_FACTORY::BLOCK_CACHE_NAME # +rev:cf_t2 TABLE_FACTORY::BLOCK_CACHE_OPTIONS # +rev:cf_t2 TABLE_FACTORY::CAPACITY # +rev:cf_t2 TABLE_FACTORY::NUM_SHARD_BITS # +rev:cf_t2 TABLE_FACTORY::STRICT_CAPACITY_LIMIT # +rev:cf_t2 TABLE_FACTORY::MEMORY_ALLOCATOR # +rev:cf_t2 TABLE_FACTORY::HIGH_PRI_POOL_RATIO # +rev:cf_t2 TABLE_FACTORY::BLOCK_CACHE_COMPRESSED # +rev:cf_t2 TABLE_FACTORY::PERSISTENT_CACHE # +rev:cf_t2 TABLE_FACTORY::BLOCK_SIZE # +rev:cf_t2 TABLE_FACTORY::BLOCK_SIZE_DEVIATION # +rev:cf_t2 TABLE_FACTORY::BLOCK_RESTART_INTERVAL # +rev:cf_t2 TABLE_FACTORY::INDEX_BLOCK_RESTART_INTERVAL # +rev:cf_t2 TABLE_FACTORY::METADATA_BLOCK_SIZE # +rev:cf_t2 TABLE_FACTORY::PARTITION_FILTERS # +rev:cf_t2 TABLE_FACTORY::USE_DELTA_ENCODING # +rev:cf_t2 TABLE_FACTORY::FILTER_POLICY # +rev:cf_t2 TABLE_FACTORY::WHOLE_KEY_FILTERING # +rev:cf_t2 TABLE_FACTORY::VERIFY_COMPRESSION # +rev:cf_t2 TABLE_FACTORY::READ_AMP_BYTES_PER_BIT # +rev:cf_t2 TABLE_FACTORY::FORMAT_VERSION # +rev:cf_t2 TABLE_FACTORY::ENABLE_INDEX_COMPRESSION # +rev:cf_t2 TABLE_FACTORY::BLOCK_ALIGN # +DROP TABLE t1; +DROP TABLE t2; +DROP TABLE t3; +DROP TABLE t4; +SHOW ENGINE rocksdb MUTEX; +Type Name Status +SHOW ENGINE ALL MUTEX; +SHOW ENGINE rocksdb TRANSACTION STATUS; +Type Name Status +rocksdb +============================================================ +TIMESTAMP ROCKSDB TRANSACTION MONITOR OUTPUT +============================================================ +--------- +SNAPSHOTS +--------- +LIST OF SNAPSHOTS FOR EACH SESSION: +----------LATEST DETECTED DEADLOCKS---------- +----------------------------------------- +END OF ROCKSDB TRANSACTION MONITOR OUTPUT +========================================= + +START TRANSACTION WITH CONSISTENT SNAPSHOT; +SHOW ENGINE rocksdb TRANSACTION STATUS; +Type Name Status +rocksdb +============================================================ +TIMESTAMP ROCKSDB TRANSACTION MONITOR OUTPUT +============================================================ +--------- +SNAPSHOTS +--------- +LIST OF SNAPSHOTS FOR EACH SESSION: +---SNAPSHOT, ACTIVE NUM sec +MySQL thread id TID, OS thread handle PTR, query id QID localhost root ACTION +SHOW ENGINE rocksdb TRANSACTION STATUS +lock count 0, write count 0 +insert count 0, update count 0, delete count 0 +----------LATEST DETECTED DEADLOCKS---------- +----------------------------------------- +END OF ROCKSDB TRANSACTION MONITOR OUTPUT +========================================= + +ROLLBACK; +START TRANSACTION WITH SHARED ROCKSDB SNAPSHOT; +File Position Gtid_executed Snapshot_ID + 0 1 +SHOW ENGINE rocksdb STATUS; +Type Name Status +STATISTICS # # +DBSTATS # # +CF_COMPACTION # # +CF_COMPACTION # # +CF_COMPACTION # # +CF_COMPACTION # # +MEMORY_STATS # # +BG_THREADS # # +BG_THREADS # # +EXPLICIT_SNAPSHOTS # # +ROLLBACK; +CREATE EXPLICIT rocksdb SNAPSHOT; +File Position Gtid_executed Snapshot_ID + 0 2 +SHOW ENGINE rocksdb STATUS; +Type Name Status +STATISTICS # # +DBSTATS # # +CF_COMPACTION # # +CF_COMPACTION # # +CF_COMPACTION # # +CF_COMPACTION # # +MEMORY_STATS # # +BG_THREADS # # +BG_THREADS # # +EXPLICIT_SNAPSHOTS # # +RELEASE EXPLICIT rocksdb SNAPSHOT; +File Position Gtid_executed Snapshot_ID + 0 2 +SHOW ENGINE rocksdb STATUS; +Type Name Status +STATISTICS # # +DBSTATS # # +CF_COMPACTION # # +CF_COMPACTION # # +CF_COMPACTION # # +CF_COMPACTION # # +MEMORY_STATS # # +BG_THREADS # # +BG_THREADS # # +SET GLOBAL rocksdb_max_background_jobs= @save.rocksdb_max_background_jobs; |