MyRocks Status Variables

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_covered_secondary_key_lookups
  23. Rocksdb_flush_write_bytes
  24. Rocksdb_getupdatessince_calls
  25. Rocksdb_l0_num_files_stall_micros
  26. Rocksdb_l0_slowdown_micros
  27. Rocksdb_memtable_compaction_micros
  28. Rocksdb_memtable_hit
  29. Rocksdb_memtable_miss
  30. Rocksdb_memtable_total
  31. Rocksdb_memtable_unflushed
  32. Rocksdb_no_file_closes
  33. Rocksdb_no_file_errors
  34. Rocksdb_no_file_opens
  35. Rocksdb_num_iterators
  36. Rocksdb_number_block_not_compressed
  37. Rocksdb_number_deletes_filtered
  38. Rocksdb_number_keys_read
  39. Rocksdb_number_keys_updated
  40. Rocksdb_number_keys_written
  41. Rocksdb_number_merge_failures
  42. Rocksdb_number_multiget_bytes_read
  43. Rocksdb_number_multiget_get
  44. Rocksdb_number_multiget_keys_read
  45. Rocksdb_number_reseeks_iteration
  46. Rocksdb_number_sst_entry_delete
  47. Rocksdb_number_sst_entry_merge
  48. Rocksdb_number_sst_entry_other
  49. Rocksdb_number_sst_entry_put
  50. Rocksdb_number_sst_entry_singledelete
  51. Rocksdb_number_stat_computes
  52. Rocksdb_number_superversion_acquires
  53. Rocksdb_number_superversion_cleanups
  54. Rocksdb_number_superversion_releases
  55. Rocksdb_queries_point
  56. Rocksdb_queries_range
  57. Rocksdb_rate_limit_delay_millis
  58. Rocksdb_rows_deleted
  59. Rocksdb_rows_deleted_blind
  60. Rocksdb_rows_expired
  61. Rocksdb_rows_inserted
  62. Rocksdb_rows_read
  63. Rocksdb_rows_updated
  64. Rocksdb_snapshot_conflict_errors
  65. Rocksdb_stall_l0_file_count_limit_slowdowns
  66. Rocksdb_stall_l0_file_count_limit_stops
  67. Rocksdb_stall_locked_l0_file_count_limit_slowdowns
  68. Rocksdb_stall_locked_l0_file_count_limit_stops
  69. Rocksdb_stall_pending_compaction_limit_slowdowns
  70. Rocksdb_stall_pending_compaction_limit_stops
  71. Rocksdb_stall_memtable_limit_slowdowns
  72. Rocksdb_stall_memtable_limit_stops
  73. Rocksdb_stall_micros
  74. Rocksdb_stall_total_slowdowns
  75. Rocksdb_stall_total_stops
  76. Rocksdb_system_rows_deleted
  77. Rocksdb_system_rows_inserted
  78. Rocksdb_system_rows_read
  79. Rocksdb_system_rows_updated
  80. Rocksdb_wal_bytes
  81. Rocksdb_wal_group_syncs
  82. Rocksdb_wal_synced
  83. Rocksdb_write_other
  84. Rocksdb_write_self
  85. Rocksdb_write_timedout
  86. 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_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_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_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:

Rocksdb_l0_slowdown_micros

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

Rocksdb_memtable_compaction_micros

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

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_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_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_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_expired

  • Description: Number of expired rows.
  • 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_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_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_memtable_limit_slowdowns

  • Description: Write slowdowns due to nearing the maximum number of permitted memtables.
  • Scope: Global, Session
  • Data Type: numeric

Rocksdb_stall_memtable_limit_stops

  • Description: Write stops due to reaching the maximum number of permitted memtables.
  • Scope: Global, Session
  • Data Type: numeric

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_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.
  • 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...