MyRocks System Variables

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

This article is currently incomplete.

See Server System Variables for a complete list of system variables and instructions on setting them.

See also the Full list of MariaDB options, system and status variables.

rocksdb_access_hint_on_compaction_start

  • Description: DBOptions::access_hint_on_compaction_start for RocksDB
  • Commandline: --rocksdb-access-hint-on-compaction-start=#
  • Scope: Global
  • Dynamic: No
  • Data Type: numeric
  • Default Value: 1
  • Range: 0 to 3

rocksdb_advise_random_on_open

  • Description: DBOptions::advise_random_on_open for RocksDB
  • Commandline: --rocksdb-advise-random-on-open={0|1}
  • Scope: Global
  • Dynamic: No
  • Data Type: boolean
  • Default Value: ON

rocksdb_allow_concurrent_memtable_write

  • Description: DBOptions::allow_concurrent_memtable_write for RocksDB
  • Commandline: --rocksdb-allow-concurrent-memtable-write={0|1}
  • Scope: Global
  • Dynamic: No
  • Data Type: boolean
  • Default Value: OFF

rocksdb_allow_mmap_reads

  • Description: DBOptions::allow_mmap_reads for RocksDB
  • Commandline: --rocksdb-allow-mmap-reads={0|1}
  • Scope: Global
  • Dynamic: No
  • Data Type: boolean
  • Default Value: OFF

rocksdb_allow_mmap_writes

  • Description: DBOptions::allow_mmap_writes for RocksDB
  • Commandline: --rocksdb-allow-mmap-writes={0|1}
  • Scope: Global
  • Dynamic: No
  • Data Type: boolean
  • Default Value: OFF

rocksdb_background_sync

  • Description: Turns on background syncs for RocksDB
  • Commandline: --rocksdb-background-sync={0|1}
  • Scope: Global
  • Dynamic: No
  • Data Type: boolean
  • Default Value: OFF

rocksdb_base_background_compactions

  • Description: DBOptions::base_background_compactions for RocksDB
  • Commandline: --rocksdb-base-background-compactions=#
  • Scope: Global
  • Dynamic: No
  • Data Type: numeric
  • Default Value: 1
  • Range: -1 to 64

rocksdb_blind_delete_primary_key

  • Description: Deleting rows by primary key lookup, without reading rows (Blind Deletes). Blind delete is disabled if the table has secondary key.
  • Commandline: --rocksdb-blind-delete-primary-key={0|1}
  • Scope: Global
  • Dynamic: Yes
  • Data Type: boolean
  • Default Value: OFF

rocksdb_block_cache_size

  • Description: Block_cache size for RocksDB
  • Commandline: --rocksdb-block-cache-size=#
  • Scope: Global
  • Dynamic: No
  • Data Type: numeric
  • Default Value: 536870912
  • Range: 1024 to 9223372036854775807

rocksdb_block_restart_interval

  • Description: BlockBasedTableOptions::block_restart_interval for RocksDB
  • Commandline: --rocksdb-block-restart-interval=#
  • Scope: Global
  • Dynamic: No
  • Data Type: numeric
  • Default Value: 16
  • Range: 1 to 2147483647

rocksdb_block_size

  • Description: BlockBasedTableOptions::block_size for RocksDB
  • Commandline: --rocksdb-block-size=#
  • Scope: Global
  • Dynamic: No
  • Data Type: numeric
  • Default Value: 4096
  • Range: 1 to 18446744073709551615

rocksdb_block_size_deviation

  • Description: BlockBasedTableOptions::block_size_deviation for RocksDB
  • Commandline: --rocksdb-block-size-deviation=#
  • Scope: Global
  • Dynamic: No
  • Data Type: numeric
  • Default Value: 10
  • Range: 0 to 2147483647

rocksdb_bulk_load

  • Description: Use bulk-load mode for inserts. This disables unique_checks and enables rocksdb_commit_in_the_middle.
  • Commandline: --rocksdb-bulk-load={0|1}
  • Scope: Global
  • Dynamic: Yes
  • Data Type: boolean
  • Default Value: OFF

rocksdb_bulk_load_size

  • Description: Maximum number of records in a batch for bulk-load mode.
  • Commandline: --rocksdb-bulk-load-size=#
  • Scope: Global
  • Dynamic: Yes
  • Data Type: numeric
  • Default Value: 1000
  • Range: 1 to 1073741824

rocksdb_bytes_per_sync

  • Description: DBOptions::bytes_per_sync for RocksDB.
  • Commandline: --rocksdb-bytes-per-sync=#
  • Scope: Global
  • Dynamic: No
  • Data Type: numeric
  • Default Value: 0
  • Range: 0 to 18446744073709551615

rocksdb_cache_index_and_filter_blocks

  • Description: BlockBasedTableOptions::cache_index_and_filter_blocks for RocksDB.
  • Commandline: --rocksdb-cache-index-and-filter_blocks={0|1}
  • Scope: Global
  • Dynamic: No
  • Data Type: boolean
  • Default Value: ON

rocksdb_checksums_pct

  • Description: Percentage of rows to be checksummed.
  • Commandline: --rocksdb-checksums-pct=#
  • Scope: Global, Session
  • Dynamic: Yes
  • Data Type: numeric
  • Default Value: 100
  • Range: 0 to 100

rocksdb_collect_sst_properties

  • Description: Enables collecting SST file properties on each flush.
  • Commandline: --rocksdb-collect-sst-properties={0|1}
  • Scope: Global
  • Dynamic: No
  • Data Type: boolean
  • Default Value: ON

rocksdb_commit_in_the_middle

  • Description: Commit rows implicitly every rocksdb_bulk_load_size, on bulk load/insert, update and delete.
  • Commandline: --rocksdb-commit-in-the-middle={0|1}
  • Scope: Global
  • Dynamic: Yes
  • Data Type: boolean
  • Default Value: OFF

rocksdb_compact_cf

  • Description: Compact column family.
  • Commandline: --rocksdb-compact-cf=value
  • Scope: Global
  • Dynamic: Yes
  • Data Type: string
  • Default Value: (Empty)

rocksdb_compaction_readahead_size

  • Description: DBOptions::compaction_readahead_size for RocksDB.
  • Commandline: --rocksdb-compaction-readahead-size=#
  • Scope: Global
  • Dynamic: Yes
  • Data Type: numeric
  • Default Value: 0
  • Range: 0 to 18446744073709551615

rocksdb_compaction_sequential_deletes

  • Description: RocksDB will trigger compaction for the file if it has more than this number sequential deletes per window.
  • Commandline: --rocksdb-compaction-sequential-deletes=#
  • Scope: Global
  • Dynamic: Yes
  • Data Type: numeric
  • Default Value: 0
  • Range: 0 to 2000000

rocksdb_compaction_sequential_deletes_count_sd

  • Description: Counting SingleDelete as rocksdb_compaction_sequential_deletes.
  • Commandline: --rocksdb-compaction-sequential-deletes-count-sd={0|1}
  • Scope: Global
  • Dynamic: Yes
  • Data Type: boolean
  • Default Value: OFF

rocksdb_compaction_sequential_deletes_file_size

  • Description: Minimum file size required for compaction_sequential_deletes.
  • Commandline: --rocksdb-compaction-sequential-deletes-file-size=#
  • Scope: Global
  • Dynamic: Yes
  • Data Type: numeric
  • Default Value: 0
  • Range: -1 to 9223372036854775807

rocksdb_compaction_sequential_deletes_window

  • Description: Size of the window for counting rocksdb_compaction_sequential_deletes.
  • Commandline: --rocksdb-compaction-sequential-deletes-window=#
  • Scope: Global
  • Dynamic: Yes
  • Data Type: numeric
  • Default Value: 0
  • Range: 0 to 2000000

rocksdb_create_checkpoint

  • Description: Checkpoint directory.
  • Commandline: --rocksdb-create-checkpoint=value
  • Scope: Global
  • Dynamic: Yes
  • Data Type: string
  • Default Value: (Empty)

rocksdb_create_if_missing

  • Description: DBOptions::create_if_missing for RocksDB.
  • Commandline: --rocksdb-create-if-missing={0|1}
  • Scope: Global
  • Dynamic: No
  • Data Type: boolean
  • Default Value: ON

rocksdb_create_missing_column_families

  • Description: DBOptions::create_missing_column_families for RocksDB.
  • Commandline: --rocksdb-create-missing-column-families={0|1}
  • Scope: Global
  • Dynamic: No
  • Data Type: boolean
  • Default Value: OFF

rocksdb_datadir

  • Description: RocksDB data directory.
  • Commandline: --rocksdb-datadir[=value]
  • Scope: Global
  • Dynamic: No
  • Data Type: string
  • Default Value: ./.rocksdb

rocksdb_db_write_buffer_size

  • Description: DBOptions::db_write_buffer_size for RocksDB.
  • Commandline: --rocksdb-db-write-buffer-size=#
  • Scope: Global
  • Dynamic: No
  • Data Type: numeric
  • Default Value: 0
  • Range: 0 to 18446744073709551615

rocksdb_deadlock_detect

  • Description: Enables deadlock detection.
  • Commandline: --rocksdb-deadlock-detect={0|1}
  • Scope: Global, Session
  • Dynamic: Yes
  • Data Type: boolean
  • Default Value: OFF

rocksdb_debug_optimizer_no_zero_cardinality

  • Description: If cardinality is zero, override it with some value.
  • Commandline: --rocksdb-debug-optimizer-no-zero-cardinality={0|1}
  • Scope: Global, Session
  • Dynamic: Yes
  • Data Type: boolean
  • Default Value: ON

rocksdb_default_cf_options

  • Description: Default cf options for RocksDB.
  • Commandline: --rocksdb-default-cf-options=value
  • Scope: Global
  • Dynamic: No
  • Data Type: string
  • Default Value: (Empty)

rocksdb_delayed_write_rate

  • Description: DBOptions::delayed_write_rate.
  • Commandline: --rocksdb-delayed-write-rate=#
  • Scope: Global
  • Dynamic: Yes
  • Data Type: numeric
  • Default Value: 16777216
  • Range: 0 to 18446744073709551615

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.