MyRocks Status Variables
You are viewing an old version of this article. View
the current version here.
Contents
- Rocksdb_block_cache_add
- Rocksdb_block_cache_data_hit
- Rocksdb_block_cache_data_miss
- Rocksdb_block_cache_filter_hit
- Rocksdb_block_cache_filter_miss
- Rocksdb_block_cache_hit
- Rocksdb_block_cache_index_hit
- Rocksdb_block_cache_index_miss
- Rocksdb_block_cache_miss
- Rocksdb_block_cachecompressed_hit
- Rocksdb_block_cachecompressed_miss
- Rocksdb_bloom_filter_prefix_checked
- Rocksdb_bloom_filter_prefix_useful
- Rocksdb_bloom_filter_useful
- Rocksdb_bytes_read
- Rocksdb_bytes_written
- Rocksdb_compact_read_bytes
- Rocksdb_compact_write_bytes
- Rocksdb_compaction_key_drop_new
- Rocksdb_compaction_key_drop_obsolete
- Rocksdb_compaction_key_drop_user
- Rocksdb_flush_write_bytes
- Rocksdb_getupdatessince_calls
- Rocksdb_l0_num_files_stall_micros
- Rocksdb_l0_slowdown_micros
- Rocksdb_memtable_compaction_micros
- Rocksdb_memtable_hit
- Rocksdb_memtable_miss
- Rocksdb_no_file_closes
- Rocksdb_no_file_errors
- Rocksdb_no_file_opens
- Rocksdb_num_iterators
- Rocksdb_number_block_not_compressed
- Rocksdb_number_deletes_filtered
- Rocksdb_number_keys_read
- Rocksdb_number_keys_updated
- Rocksdb_number_keys_written
- Rocksdb_number_merge_failures
- Rocksdb_number_multiget_bytes_read
- Rocksdb_number_multiget_get
- Rocksdb_number_multiget_keys_read
- Rocksdb_number_reseeks_iteration
- Rocksdb_number_sst_entry_delete
- Rocksdb_number_sst_entry_merge
- Rocksdb_number_sst_entry_other
- Rocksdb_number_sst_entry_put
- Rocksdb_number_sst_entry_singledelete
- Rocksdb_number_stat_computes
- Rocksdb_number_superversion_acquires
- Rocksdb_number_superversion_cleanups
- Rocksdb_number_superversion_releases
- Rocksdb_rate_limit_delay_millis
- Rocksdb_rows_deleted
- Rocksdb_rows_deleted_blind
- Rocksdb_rows_inserted
- Rocksdb_rows_read
- Rocksdb_rows_updated
- Rocksdb_system_rows_deleted
- Rocksdb_system_rows_inserted
- Rocksdb_system_rows_read
- Rocksdb_system_rows_updated
- Rocksdb_snapshot_conflict_errors
- Rocksdb_wal_bytes
- Rocksdb_wal_group_syncs
- Rocksdb_wal_synced
- Rocksdb_write_other
- Rocksdb_write_self
- Rocksdb_write_timedout
- Rocksdb_write_wal
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_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_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_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_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_flush_write_bytes
- Description: Number of bytes written during flush.
- Scope: Global, Session
- Data Type:
numeric
Rocksdb_getupdatessince_calls
- Description: Number of calls to the
GetUpdatesSince
function. - Scope: Global, Session
- Data Type:
numeric
You may find this useful when monitoring refreshes of the transaction log.
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
Rocksdb_l0_slowdown_micros
- Description: Total time spent waiting in microseconds while performing L0-L1 compactions.
- Scope: Global, Session
- Data Type:
numeric
Rocksdb_memtable_compaction_micros
- Description:
- Scope: Global, Session
- Data Type:
numeric
Rocksdb_memtable_hit
- Description: Number of hits for the Memtable.
- Scope: Global, Session
- Data Type:
numeric
Rocksdb_memtable_miss
- Description: Number of misses for the Memtable.
- 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_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_stat_computes
- Description:
- Scope: Global, Session
- Data Type:
numeric
Rocksdb_number_superversion_acquires
- Description: Number of times the superversion structure acquired.
- Scope: Global, Session
- Data Type:
numeric
This is useful when tracking files for the database.
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_rate_limit_delay_millis
- Description:
- Scope: Global, Session
- Data Type:
numeric
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_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_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_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_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.
- Scope: Global, Session
- Data Type:
numeric
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.
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
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.