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