mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2026-02-25 20:19:00 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/storage/rocksdb/mysql-test/rocksdb/r/show_engine.result
Sergei Golubchik 49b5a2b360 Revert "MDEV-30610 Update RocksDB to v8.1.1" 
Not ready yet, it fails its own test suite

This reverts commit 485c9b1fb3
2023-09-30 14:12:55 +02:00

491 lines
17 KiB
Text
Raw Permalink Blame History

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;
Reference in a new issue View git blame Copy permalink