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
numeric
Rocksdb_block_cache_data_hit
numeric
Rocksdb_block_cache_data_miss
numeric
Rocksdb_block_cache_filter_hit
numeric
Rocksdb_block_cache_filter_miss
numeric
Rocksdb_block_cache_hit
numeric
Rocksdb_block_cache_index_hit
numeric
Rocksdb_block_cache_index_miss
numeric
Rocksdb_block_cache_miss
numeric
Rocksdb_block_cachecompressed_hit
numeric
Rocksdb_block_cachecompressed_miss
numeric
Rocksdb_bloom_filter_prefix_checked
numeric
Rocksdb_bloom_filter_prefix_useful
numeric
Rocksdb_bloom_filter_useful
numeric
Rocksdb_bytes_read
numeric
Rocksdb_bytes_written
numeric
Rocksdb_compact_read_bytes
numeric
Rocksdb_compact_write_bytes
numeric
Rocksdb_compaction_key_drop_new
numeric
Rocksdb_compaction_key_drop_obsolete
numeric
Rocksdb_compaction_key_drop_user
numeric
Rocksdb_covered_secondary_key_lookups
numeric
Rocksdb_flush_write_bytes
numeric
Rocksdb_getupdatessince_calls
GetUpdatesSince
function. You may find this useful when monitoring refreshes of the transaction log. numeric
Rocksdb_l0_num_files_stall_micros
numeric
Rocksdb_l0_slowdown_micros
numeric
Rocksdb_memtable_compaction_micros
numeric
Rocksdb_memtable_hit
numeric
Rocksdb_memtable_miss
numeric
Rocksdb_memtable_total
numeric
Rocksdb_memtable_unflushed
numeric
Rocksdb_no_file_closes
numeric
Rocksdb_no_file_errors
numeric
Rocksdb_no_file_opens
numeric
Rocksdb_num_iterators
numeric
Rocksdb_number_block_not_compressed
numeric
Rocksdb_number_deletes_filtered
numeric
Rocksdb_number_keys_read
numeric
Rocksdb_number_keys_updated
numeric
Rocksdb_number_keys_written
numeric
Rocksdb_number_merge_failures
numeric
Rocksdb_number_multiget_bytes_read
MultiGet()
calls. numeric
Rocksdb_number_multiget_get
MultiGet()
requests made. numeric
Rocksdb_number_multiget_keys_read
MultiGet()
calls. numeric
Rocksdb_number_reseeks_iteration
numeric
Rocksdb_number_sst_entry_delete
numeric
Rocksdb_number_sst_entry_merge
numeric
Rocksdb_number_sst_entry_other
numeric
Rocksdb_number_sst_entry_put
numeric
Rocksdb_number_sst_entry_singledelete
numeric
Rocksdb_number_stat_computes
numeric
Rocksdb_number_superversion_acquires
numeric
This is useful when tracking files for the database.
Rocksdb_number_superversion_cleanups
numeric
Rocksdb_number_superversion_releases
numeric
Rocksdb_queries_point
numeric
Rocksdb_queries_range
numeric
Rocksdb_rate_limit_delay_millis
numeric
Rocksdb_rows_deleted
numeric
Rocksdb_rows_deleted_blind
numeric
Rocksdb_rows_expired
numeric
Rocksdb_rows_inserted
numeric
Rocksdb_rows_read
numeric
Rocksdb_rows_updated
numeric
Rocksdb_snapshot_conflict_errors
numeric
Rocksdb_stall_l0_file_count_limit_slowdowns
numeric
Rocksdb_stall_l0_file_count_limit_stops
numeric
Rocksdb_stall_locked_l0_file_count_limit_slowdowns
numeric
Rocksdb_stall_locked_l0_file_count_limit_stops
numeric
Rocksdb_stall_pending_compaction_limit_slowdowns
numeric
Rocksdb_stall_pending_compaction_limit_stops
numeric
Rocksdb_stall_memtable_limit_slowdowns
numeric
Rocksdb_stall_memtable_limit_stops
numeric
Rocksdb_stall_micros
numeric
Rocksdb_stall_total_slowdowns
numeric
Rocksdb_stall_total_stops
numeric
Rocksdb_system_rows_deleted
numeric
Rocksdb_system_rows_inserted
numeric
Rocksdb_system_rows_read
numeric
Rocksdb_system_rows_updated
numeric
Rocksdb_wal_bytes
numeric
Rocksdb_wal_group_syncs
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
numeric
Rocksdb_write_other
numeric
Rocksdb_write_self
numeric
Rocksdb_write_timedout
numeric
Rocksdb_write_wal
numeric
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/myrocks-status-variables/