Expand description

Properties

Full list of valid properties and descriptions pulled from here.

Constants

“rocksdb.actual-delayed-write-rate” - returns the current actual delayed write rate. 0 means no delay.

“rocksdb.aggregated-table-properties” - returns a string representation of the aggregated table properties of the target column family.

“rocksdb.background-errors” - returns accumulated number of background errors.

“rocksdb.base-level” - returns number of level to which L0 data will be compacted.

“rocksdb.block-cache-capacity” - returns block cache capacity.

“rocksdb.block-cache-pinned-usage” - returns the memory size for the entries being pinned.

“rocksdb.block-cache-usage” - returns the memory size for the entries residing in block cache.

“rocksdb.cfstats” - Both of “rocksdb.cfstats-no-file-histogram” and “rocksdb.cf-file-histogram” together. See below for description of the two.

“rocksdb.cfstats-no-file-histogram” - returns a multi-line string with general columm family stats per-level over db’s lifetime (“L”), aggregated over db’s lifetime (“Sum”), and aggregated over the interval since the last retrieval (“Int”). It could also be used to return the stats in the format of the map. In this case there will a pair of string to array of double for each level as well as for “Sum”. “Int” stats will not be affected when this form of stats are retrieved.

“rocksdb.cf-file-histogram” - print out how many file reads to every level, as well as the histogram of latency of single requests.

“rocksdb.compaction-pending” - returns 1 if at least one compaction is pending; otherwise, returns 0.

“rocksdb.current-super-version-number” - returns number of current LSM version. It is a uint64_t integer number, incremented after there is any change to the LSM tree. The number is not preserved after restarting the DB. After DB restart, it will start from 0 again.

“rocksdb.cur-size-active-mem-table” - returns approximate size of active memtable (bytes).

“rocksdb.cur-size-all-mem-tables” - returns approximate size of active and unflushed immutable memtables (bytes).

“rocksdb.dbstats” - returns a multi-line string with general database stats, both cumulative (over the db’s lifetime) and interval (since the last retrieval of kDBStats).

“rocksdb.estimate-live-data-size” - returns an estimate of the amount of live data in bytes.

“rocksdb.estimate-num-keys” - returns estimated number of total keys in the active and unflushed immutable memtables and storage.

“rocksdb.estimate-oldest-key-time” - returns an estimation of oldest key timestamp in the DB. Currently only available for FIFO compaction with compaction_options_fifo.allow_compaction = false.

“rocksdb.estimate-pending-compaction-bytes” - returns estimated total number of bytes compaction needs to rewrite to get all levels down to under target size. Not valid for other compactions than level- based.

“rocksdb.estimate-table-readers-mem” - returns estimated memory used for reading SST tables, excluding memory used in block cache (e.g., filter and index blocks).

“rocksdb.is-file-deletions-enabled” - returns 0 if deletion of obsolete files is enabled; otherwise, returns a non-zero number.

“rocksdb.is-write-stopped” - Return 1 if write has been stopped.

“rocksdb.levelstats” - returns multi-line string containing the number of files per level and total size of each level (MB).

“rocksdb.live-sst-files-size” - returns total size (bytes) of all SST files belong to the latest LSM tree.

“rocksdb.mem-table-flush-pending” - returns 1 if a memtable flush is pending; otherwise, returns 0.

“rocksdb.min-log-number-to-keep” - return the minimum log number of the log files that should be kept.

“rocksdb.min-obsolete-sst-number-to-keep” - return the minimum file number for an obsolete SST to be kept. The max value of uint64_t will be returned if all obsolete files can be deleted.

“rocksdb.num-deletes-active-mem-table” - returns total number of delete entries in the active memtable.

“rocksdb.num-deletes-imm-mem-tables” - returns total number of delete entries in the unflushed immutable memtables.

“rocksdb.num-entries-active-mem-table” - returns total number of entries in the active memtable.

“rocksdb.num-entries-imm-mem-tables” - returns total number of entries in the unflushed immutable memtables.

“rocksdb.num-immutable-mem-table” - returns number of immutable memtables that have not yet been flushed.

“rocksdb.num-immutable-mem-table-flushed” - returns number of immutable memtables that have already been flushed.

“rocksdb.num-live-versions” - returns number of live versions. Version is an internal data structure. See version_set.h for details. More live versions often mean more SST files are held from being deleted, by iterators or unfinished compactions.

“rocksdb.num-running-compactions” - returns the number of currently running compactions.

“rocksdb.num-running-flushes” - returns the number of currently running flushes.

“rocksdb.num-snapshots” - returns number of unreleased snapshots of the database.

“rocksdb.oldest-snapshot-time” - returns number representing unix timestamp of oldest unreleased snapshot.

“rocksdb.options-statistics” - returns multi-line string of options.statistics

“rocksdb.size-all-mem-tables” - returns approximate size of active, unflushed immutable, and pinned immutable memtables (bytes).

“rocksdb.sstables” - returns a multi-line string summarizing current SST files.

“rocksdb.stats” - returns a multi-line string containing the data described by kCFStats followed by the data described by kDBStats.

“rocksdb.total-sst-files-size” - returns total size (bytes) of all SST files. WARNING: may slow down online queries if there are too many files.

Functions

“rocksdb.aggregated-table-properties-at-level”, same as the previous one but only returns the aggregated table properties of the specified level “N” at the target column family.

“rocksdb.compression-ratio-at-level” - returns string containing the compression ratio of data at level , where is an ASCII representation of a level number (e.g., “0”). Here, compression ratio is defined as uncompressed data size / compressed file size. Returns “-1.0” if no open files at level .

“rocksdb.num-files-at-level” - returns string containing the number of files at level , where is an ASCII representation of a level number (e.g., “0”).