MyRocks Status Variables

Contents

  1. Rocksdb_block_cache_add
  2. Rocksdb_block_cache_add_failures
  3. Rocksdb_block_cache_bytes_read
  4. Rocksdb_block_cache_bytes_write
  5. Rocksdb_block_cache_data_add
  6. Rocksdb_block_cache_data_bytes_insert
  7. Rocksdb_block_cache_data_hit
  8. Rocksdb_block_cache_data_miss
  9. Rocksdb_block_cache_filter_add
  10. Rocksdb_block_cache_filter_bytes_evict
  11. Rocksdb_block_cache_filter_bytes_insert
  12. Rocksdb_block_cache_filter_hit
  13. Rocksdb_block_cache_filter_miss
  14. Rocksdb_block_cache_hit
  15. Rocksdb_block_cache_index_add
  16. Rocksdb_block_cache_index_bytes_evict
  17. Rocksdb_block_cache_index_bytes_insert
  18. Rocksdb_block_cache_index_hit
  19. Rocksdb_block_cache_index_miss
  20. Rocksdb_block_cache_miss
  21. Rocksdb_block_cachecompressed_hit
  22. Rocksdb_block_cachecompressed_miss
  23. Rocksdb_bloom_filter_full_positive
  24. Rocksdb_bloom_filter_full_true_positive
  25. Rocksdb_bloom_filter_prefix_checked
  26. Rocksdb_bloom_filter_prefix_useful
  27. Rocksdb_bloom_filter_useful
  28. Rocksdb_bytes_read
  29. Rocksdb_bytes_written
  30. Rocksdb_compact_read_bytes
  31. Rocksdb_compact_write_bytes
  32. Rocksdb_compaction_key_drop_new
  33. Rocksdb_compaction_key_drop_obsolete
  34. Rocksdb_compaction_key_drop_user
  35. Rocksdb_covered_secondary_key_lookups
  36. Rocksdb_flush_write_bytes
  37. Rocksdb_get_hit_l0
  38. Rocksdb_get_hit_l1
  39. Rocksdb_get_hit_l2_and_up
  40. Rocksdb_getupdatessince_calls
  41. Rocksdb_iter_bytes_read
  42. Rocksdb_l0_num_files_stall_micros
  43. Rocksdb_l0_slowdown_micros
  44. Rocksdb_manual_compactions_processed
  45. Rocksdb_manual_compactions_running
  46. Rocksdb_memtable_compaction_micros
  47. Rocksdb_memtable_hit
  48. Rocksdb_memtable_miss
  49. Rocksdb_memtable_total
  50. Rocksdb_memtable_unflushed
  51. Rocksdb_no_file_closes
  52. Rocksdb_no_file_errors
  53. Rocksdb_no_file_opens
  54. Rocksdb_num_iterators
  55. Rocksdb_number_block_not_compressed
  56. Rocksdb_number_db_next
  57. Rocksdb_number_db_next_found
  58. Rocksdb_number_db_prev
  59. Rocksdb_number_db_prev_found
  60. Rocksdb_number_db_seek
  61. Rocksdb_number_db_seek_found
  62. Rocksdb_number_deletes_filtered
  63. Rocksdb_number_keys_read
  64. Rocksdb_number_keys_updated
  65. Rocksdb_number_keys_written
  66. Rocksdb_number_merge_failures
  67. Rocksdb_number_multiget_bytes_read
  68. Rocksdb_number_multiget_get
  69. Rocksdb_number_multiget_keys_read
  70. Rocksdb_number_reseeks_iteration
  71. Rocksdb_number_sst_entry_delete
  72. Rocksdb_number_sst_entry_merge
  73. Rocksdb_number_sst_entry_other
  74. Rocksdb_number_sst_entry_put
  75. Rocksdb_number_sst_entry_singledelete
  76. Rocksdb_number_superversion_acquires
  77. Rocksdb_number_superversion_cleanups
  78. Rocksdb_number_superversion_releases
  79. Rocksdb_queries_point
  80. Rocksdb_queries_range
  81. Rocksdb_row_lock_deadlocks
  82. Rocksdb_row_lock_wait_timeouts
  83. Rocksdb_rows_deleted
  84. Rocksdb_rows_deleted_blind
  85. Rocksdb_rows_expired
  86. Rocksdb_rows_filtered
  87. Rocksdb_rows_inserted
  88. Rocksdb_rows_read
  89. Rocksdb_rows_updated
  90. Rocksdb_snapshot_conflict_errors
  91. Rocksdb_stall_l0_file_count_limit_slowdowns
  92. Rocksdb_stall_l0_file_count_limit_stops
  93. Rocksdb_stall_locked_l0_file_count_limit_slowdowns
  94. Rocksdb_stall_locked_l0_file_count_limit_stops
  95. Rocksdb_stall_memtable_limit_slowdowns
  96. Rocksdb_stall_memtable_limit_stops
  97. Rocksdb_stall_micros
  98. Rocksdb_stall_pending_compaction_limit_slowdowns
  99. Rocksdb_stall_pending_compaction_limit_stops
  100. Rocksdb_stall_total_slowdowns
  101. Rocksdb_stall_total_stops
  102. Rocksdb_system_rows_deleted
  103. Rocksdb_system_rows_inserted
  104. Rocksdb_system_rows_read
  105. Rocksdb_system_rows_updated
  106. Rocksdb_wal_bytes
  107. Rocksdb_wal_group_syncs
  108. Rocksdb_wal_synced
  109. Rocksdb_write_other
  110. Rocksdb_write_self
  111. Rocksdb_write_timedout
  112. 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_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


Rocksdb_block_cache_bytes_write


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


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


Rocksdb_bloom_filter_full_true_positive


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


Rocksdb_manual_compactions_running


Rocksdb_memtable_compaction_micros


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


Rocksdb_number_db_next_found


Rocksdb_number_db_prev


Rocksdb_number_db_prev_found


Rocksdb_number_db_seek


Rocksdb_number_db_seek_found


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


Rocksdb_row_lock_wait_timeouts


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


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

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.