The Ultimate Guide to High Availability with MariaDB

MyRocks Status Variables

You are viewing an old version of this article. View the current version here.

Contents

  1. Rocksdb_block_cache_add
  2. Rocksdb_block_cache_data_hit
  3. Rocksdb_block_cache_data_miss
  4. Rocksdb_block_cache_filter_hit
  5. Rocksdb_block_cache_filter_miss
  6. Rocksdb_block_cache_hit
  7. Rocksdb_block_cache_index_hit
  8. Rocksdb_block_cache_index_miss
  9. Rocksdb_block_cache_miss
  10. Rocksdb_block_cachecompressed_hit
  11. Rocksdb_block_cachecompressed_miss
  12. Rocksdb_bloom_filter_prefix_checked
  13. Rocksdb_bloom_filter_prefix_useful
  14. Rocksdb_bloom_filter_useful
  15. Rocksdb_bytes_read
  16. Rocksdb_bytes_written
  17. Rocksdb_compact_read_bytes
  18. Rocksdb_compact_write_bytes
  19. Rocksdb_compaction_key_drop_new
  20. Rocksdb_compaction_key_drop_obsolete
  21. Rocksdb_compaction_key_drop_user
  22. Rocksdb_flush_write_bytes
  23. Rocksdb_getupdatessince_calls
  24. Rocksdb_l0_num_files_stall_micros
  25. Rocksdb_l0_slowdown_micros
  26. Rocksdb_memtable_compaction_micros
  27. Rocksdb_memtable_hit
  28. Rocksdb_memtable_miss
  29. Rocksdb_no_file_closes
  30. Rocksdb_no_file_errors
  31. Rocksdb_no_file_opens
  32. Rocksdb_num_iterators
  33. Rocksdb_number_block_not_compressed
  34. Rocksdb_number_deletes_filtered
  35. Rocksdb_number_keys_read
  36. Rocksdb_number_keys_updated
  37. Rocksdb_number_keys_written
  38. Rocksdb_number_merge_failures
  39. Rocksdb_number_multiget_bytes_read
  40. Rocksdb_number_multiget_get
  41. Rocksdb_number_multiget_keys_read
  42. Rocksdb_number_reseeks_iteration
  43. Rocksdb_number_sst_entry_delete
  44. Rocksdb_number_sst_entry_merge
  45. Rocksdb_number_sst_entry_other
  46. Rocksdb_number_sst_entry_put
  47. Rocksdb_number_sst_entry_singledelete
  48. Rocksdb_number_stat_computes
  49. Rocksdb_number_superversion_acquires
  50. Rocksdb_number_superversion_cleanups
  51. Rocksdb_number_superversion_releases
  52. Rocksdb_rate_limit_delay_millis
  53. Rocksdb_rows_deleted
  54. Rocksdb_rows_deleted_blind
  55. Rocksdb_rows_inserted
  56. Rocksdb_rows_read
  57. Rocksdb_rows_updated
  58. Rocksdb_system_rows_deleted
  59. Rocksdb_system_rows_inserted
  60. Rocksdb_system_rows_read
  61. Rocksdb_system_rows_updated
  62. Rocksdb_snapshot_conflict_errors
  63. Rocksdb_wal_bytes
  64. Rocksdb_wal_group_syncs
  65. Rocksdb_wal_synced
  66. Rocksdb_write_other
  67. Rocksdb_write_self
  68. Rocksdb_write_timedout
  69. 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.