MyRocks Status Variables

This page documents status variables related to the MyRocks storage engine. See Server Status Variables for a complete list of status variables that can be viewed with SHOW STATUS.

See also the Full list of MariaDB options, system and status variables.

Rocksdb_block_cache_add

• Description: Number of blocks added to the Block Cache.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_block_cache_add_failures

• Description: Number of failures when adding blocks to Block Cache.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_bytes_read

• Description: Bytes read from Block Cache.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_bytes_write

• Description: Bytes written to Block Cache.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_data_add

• Description: Number of data blocks added to the Block Cache.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_data_bytes_insert

• Description: Bytes added to the Block Cache.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_data_hit

• Description: Number of hits when accessing the data block from the Block Cache.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_block_cache_data_miss

• Description: Number of misses when accessing the data block from the Block Cache.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_block_cache_filter_add

• Description: Number of bloom filter blocks added to the Block Cache.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_filter_bytes_evict

• Description: Bytes of bloom filter blocks evicted from the Block Cache.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_filter_bytes_insert

• Description: Bytes of bloom filter blocks added to the Block Cache.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_filter_hit

• Description: Number of hits when accessing the filter block from the Block Cache.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_block_cache_filter_miss

• Description: Number of misses when accessing the filter block from the Block Cache.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_block_cache_hit

• Description: Total number of hits for the Block Cache.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_block_cache_index_add

• Description: Number of index blocks added to Block Cache index.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_index_bytes_evict

• Description: Bytes of index blocks evicted from the Block Cache.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_index_bytes_insert

• Description: Bytes of index blocks added to the Block Cache.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_block_cache_index_hit

• Description: Number of hits for the Block Cache index.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_block_cache_index_miss

• Description: Number of misses for the Block Cache index.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_block_cache_miss

• Description: Total number of misses for the Block Cache.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_block_cachecompressed_hit

• Description: Number of hits for the compressed Block Cache.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_block_cachecompressed_miss

• Description: Number of misses for the compressed Block Cache.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_bloom_filter_full_positive

• Description:
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.18, MariaDB 10.3.10

---

Rocksdb_bloom_filter_full_true_positive

• Description:
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.18, MariaDB 10.3.10

---

Rocksdb_bloom_filter_prefix_checked

• Description: Number of times the Bloom Filter checked before creating an iterator on a file.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_bloom_filter_prefix_useful

• Description: Number of times the Bloom Filter check used to avoid creating an iterator on a file.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_bloom_filter_useful

• Description: Number of times the Bloom Filter used instead of reading form file.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_bytes_read

• Description: Total number of uncompressed bytes read from memtables, cache or table files.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_bytes_written

• Description: Total number of uncompressed bytes written.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_compact_read_bytes

• Description: Number of bytes read during compaction.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_compact_write_bytes

• Description: Number of bytes written during compaction.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_compaction_key_drop_new

• Description: Number of keys dropped during compaction due their being overwritten by new values.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_compaction_key_drop_obsolete

• Description: Number of keys dropped during compaction due to their being obsolete.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_compaction_key_drop_user

• Description: Number of keys dropped during compaction due to user compaction.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_covered_secondary_key_lookups

• Description: Incremented when avoiding reading a record via a keyread. This indicates lookups that were performed via a secondary index containing a field that is only a prefix of the VARCHAR column, and that could return all requested fields directly from the secondary index.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_flush_write_bytes

• Description: Number of bytes written during flush.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_get_hit_l0

• Description: Number of times reads got data from the L0 compaction layer.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_get_hit_l1

• Description: Number of times reads got data from the L1 compaction layer.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_get_hit_l2_and_up

• Description: Number of times reads got data from the L2 and up compaction layer.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_getupdatessince_calls

• Description: Number of calls to the GetUpdatesSince function. You may find this useful when monitoring refreshes of the transaction log.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_iter_bytes_read

• Description: Total uncompressed bytes read from an iterator, including the size of both key and value.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_l0_num_files_stall_micros

• Description: Shows how long in microseconds throttled due to too mnay files in L0.
• Scope: Global, Session
• Data Type: numeric
• Removed: MariaDB 10.3.1, MariaDB 10.2.8

---

Rocksdb_l0_slowdown_micros

• Description: Total time spent waiting in microseconds while performing L0-L1 compactions.
• Scope: Global, Session
• Data Type: numeric
• Removed: MariaDB 10.3.1, MariaDB 10.2.8

---

Rocksdb_manual_compactions_processed

• Description:
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.18, MariaDB 10.3.10

---

Rocksdb_manual_compactions_running

• Description:
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.18, MariaDB 10.3.10

---

Rocksdb_memtable_compaction_micros

• Description:
• Scope: Global, Session
• Data Type: numeric
• Removed: MariaDB 10.3.1, MariaDB 10.2.8

---

Rocksdb_memtable_hit

• Description: Number of memtable hits.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_memtable_miss

• Description: Number of memtable misses.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_memtable_total

• Description: Memory used, in bytes, of all memtables.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_memtable_unflushed

• Description: Memory used, in bytes, of all unflushed memtables.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_no_file_closes

• Description: Number of times files were closed.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_no_file_errors

• Description: Number of errors encountered while trying to read data from an SST file.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_no_file_opens

• Description: Number of times files were opened.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_num_iterators

• Description: Number of iterators currently open.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_block_not_compressed

• Description: Number of uncompressed blocks.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_db_next

• Description: Number of next calls.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_number_db_next_found

• Description: Number of next calls that returned data.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_number_db_prev

• Description: Number of prev calls.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_number_db_prev_found

• Description: Number of prev calls that returned data.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_number_db_seek

• Description: Number of seek calls.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_number_db_seek_found

• Description: Number of seek calls that returned data.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_number_deletes_filtered

• Description: Number of deleted records were not written to storage due to a nonexistent key.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_keys_read

• Description: Number of keys have been read.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_keys_updated

• Description: Number of keys have been updated.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_keys_written

• Description: Number of keys have been written.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_merge_failures

• Description: Number of failures encountered while performing merge operator actions.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_multiget_bytes_read

• Description: Number of bytes read during RocksDB MultiGet() calls.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_multiget_get

• Description: Number of RocksDB MultiGet() requests made.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_multiget_keys_read

• Description: Number of keys read through RocksDB MultiGet() calls.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_reseeks_iteration

• Description: Number of reseeks that have occurred inside an iteration that skipped over a large number of keys with the same user key.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_sst_entry_delete

• Description: Number of delete markers written.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_sst_entry_merge

• Description: Number of merge keys written.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_sst_entry_other

• Description: Number of keys written that are not delete, merge or put keys.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_sst_entry_put

• Description: Number of put keys written.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_sst_entry_singledelete

• Description: Number of single-delete keys written.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_superversion_acquires

• Description: Number of times the superversion structure acquired. This is useful when tracking files for the database.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_superversion_cleanups

• Description: Number of times the superversion structure performed cleanups.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_number_superversion_releases

• Description: Number of times the superversion structure released.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_queries_point

• Description: Number of single-row queries.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_queries_range

• Description: Number of multi-row queries.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_row_lock_deadlocks

• Description: Number of deadlocks.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_row_lock_wait_timeouts

• Description: Number of row lock wait timeouts.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_rows_deleted

• Description: Number of rows deleted.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_rows_deleted_blind

• Description:
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_rows_expired

• Description: Number of expired rows.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_rows_filtered

• Description: Number of TTL filtered rows.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.15, MariaDB 10.3.7

---

Rocksdb_rows_inserted

• Description: Number of rows inserted.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_rows_read

• Description: Number of rows read.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_rows_updated

• Description: Number of rows updated.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_snapshot_conflict_errors

• Description: Number of snapshot conflict errors that have occurred during transactions that forced a rollback.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_stall_l0_file_count_limit_slowdowns

• Description: Write slowdowns due to L0 being near to full.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_stall_l0_file_count_limit_stops

• Description: Write stops due to L0 being to full.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_stall_locked_l0_file_count_limit_slowdowns

• Description: Write slowdowns due to L0 being near to full and L0 compaction in progress.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_stall_locked_l0_file_count_limit_stops

• Description: Write stops due to L0 being full and L0 compaction in progress.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_stall_memtable_limit_slowdowns

• Description: Write slowdowns due to approaching maximum permitted number of memtables.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.10, MariaDB 10.3.3

---

Rocksdb_stall_memtable_limit_stops

• Description: * Description: Write stops due to reaching maximum permitted number of memtables.
• Scope: Global, Session
• Data Type: numeric
• Introduced: MariaDB 10.2.10, MariaDB 10.3.3

---

Rocksdb_stall_micros

• Description: Time in microseconds that the writer had to wait for the compaction or flush to complete.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_stall_pending_compaction_limit_slowdowns

• Description: Write slowdowns due to nearing the limit for the maximum number of pending compaction bytes.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_stall_pending_compaction_limit_stops

• Description: Write stops due to reaching the limit for the maximum number of pending compaction bytes.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_stall_total_slowdowns

• Description: Total number of write slowdowns.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_stall_total_stops

• Description: Total number of write stops.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_system_rows_deleted

• Description: Number of rows deleted from system tables.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_system_rows_inserted

• Description: Number of rows inserted into system tables.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_system_rows_read

• Description: Number of rows read from system tables.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_system_rows_updated

• Description: Number of rows updated for system tables.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_wal_bytes

• Description: Number of bytes written to WAL.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_wal_group_syncs

• Description: Number of group commit WAL file syncs have occurred. This is provided by MyRocks and is not a view of a RocksDB counter. Increased in rocksdb_flush_wal() when doing the rdb->FlushWAL() call.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_wal_synced

• Description: Number of syncs made on RocksDB WAL file.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_write_other

• Description: Number of writes processed by a thread other than the requesting thread.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_write_self

• Description: Number of writes processed by requesting thread.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_write_timedout

• Description: Number of writes that timed out.
• Scope: Global, Session
• Data Type: numeric

---

Rocksdb_write_wal

• Description: Number of write calls that requested WAL.
• Scope: Global, Session
• Data Type: numeric

---