This page documents system variables related to the MyRocks storage engine. 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
--rocksdb-access-hint-on-compaction-start=#
numeric
1
0
to 3
rocksdb_advise_random_on_open
--rocksdb-advise-random-on-open={0|1}
boolean
ON
rocksdb_allow_concurrent_memtable_write
--rocksdb-allow-concurrent-memtable-write={0|1}
boolean
OFF
rocksdb_allow_mmap_reads
--rocksdb-allow-mmap-reads={0|1}
boolean
OFF
rocksdb_allow_mmap_writes
--rocksdb-allow-mmap-writes={0|1}
boolean
OFF
rocksdb_background_sync
--rocksdb-background-sync={0|1}
boolean
OFF
rocksdb_base_background_compactions
--rocksdb-base-background-compactions=#
numeric
1
-1
to 64
rocksdb_blind_delete_primary_key
--rocksdb-blind-delete-primary-key={0|1}
boolean
OFF
rocksdb_block_cache_size
--rocksdb-block-cache-size=#
numeric
536870912
1024
to 9223372036854775807
To see the statistics of block cache usage, check SHOW ENGINE ROCKSDB STATUS
output (search for lines starting with rocksdb.block.cache
).
One can check the size of data of the block cache in DB_BLOCK_CACHE_USAGE
column of the INFORMATION_SCHEMA.ROCKSDB_DBSTATS
table.
rocksdb_block_restart_interval
--rocksdb-block-restart-interval=#
numeric
16
1
to 2147483647
rocksdb_block_size
--rocksdb-block-size=#
numeric
4096
1
to 18446744073709551615
rocksdb_block_size_deviation
--rocksdb-block-size-deviation=#
numeric
10
0
to 2147483647
rocksdb_bulk_load
--rocksdb-bulk-load={0|1}
boolean
OFF
rocksdb_bulk_load_allow_unsorted
--rocksdb-bulk-load_allow_unsorted={0|1}
boolean
OFF
rocksdb_bulk_load_size
--rocksdb-bulk-load-size=#
numeric
1000
1
to 1073741824
rocksdb_bytes_per_sync
--rocksdb-bytes-per-sync=#
numeric
0
0
to 18446744073709551615
rocksdb_cache_index_and_filter_blocks
--rocksdb-cache-index-and-filter_blocks={0|1}
boolean
ON
rocksdb_checksums_pct
--rocksdb-checksums-pct=#
numeric
100
0
to 100
rocksdb_collect_sst_properties
--rocksdb-collect-sst-properties={0|1}
boolean
ON
rocksdb_commit_in_the_middle
--rocksdb-commit-in-the-middle={0|1}
boolean
OFF
rocksdb_compact_cf
--rocksdb-compact-cf=value
string
rocksdb_compaction_readahead_size
--rocksdb-compaction-readahead-size=#
numeric
0
0
to 18446744073709551615
rocksdb_compaction_sequential_deletes
--rocksdb-compaction-sequential-deletes=#
numeric
0
0
to 2000000
rocksdb_compaction_sequential_deletes_count_sd
--rocksdb-compaction-sequential-deletes-count-sd={0|1}
boolean
OFF
rocksdb_compaction_sequential_deletes_file_size
--rocksdb-compaction-sequential-deletes-file-size=#
numeric
0
-1
to 9223372036854775807
rocksdb_compaction_sequential_deletes_window
--rocksdb-compaction-sequential-deletes-window=#
numeric
0
0
to 2000000
rocksdb_concurrent_prepare
--rocksdb-coconcurrent-prepare={0|1}
boolean
1
rocksdb_create_checkpoint
--rocksdb-create-checkpoint=value
string
rocksdb_create_if_missing
--rocksdb-create-if-missing={0|1}
boolean
ON
rocksdb_create_missing_column_families
--rocksdb-create-missing-column-families={0|1}
boolean
OFF
rocksdb_datadir
--rocksdb-datadir[=value]
string
./.rocksdb
rocksdb_db_write_buffer_size
--rocksdb-db-write-buffer-size=#
numeric
0
0
to 18446744073709551615
rocksdb_deadlock_detect
--rocksdb-deadlock-detect={0|1}
boolean
OFF
rocksdb_deadlock_detect_depth
--rocksdb-deadlock-detect-depth=#
numeric
50
2
to 18446744073709551615
rocksdb_debug_optimizer_no_zero_cardinality
--rocksdb-debug-optimizer-no-zero-cardinality={0|1}
boolean
ON
rocksdb_debug_ttl_ignore_pk
--rocksdb-debug-ttl-ignore-pk={0|1}
boolean
OFF
rocksdb_debug_ttl_read_filter_ts
--rocksdb-debug-ttl-read-filter-ts=#
numeric
0
-3600
to 3600
rocksdb_debug_ttl_rec_ts
--rocksdb-debug-ttl-read-filter-ts=#
numeric
0
-3600
to 3600
rocksdb_debug_ttl_snapshot_ts
--rocksdb-debug-ttl-snapshot-ts=#
numeric
0
-3600
to 3600
rocksdb_default_cf_options
--rocksdb-default-cf-options=value
string
rocksdb_delayed_write_rate
--rocksdb-delayed-write-rate=#
numeric
16777216
0
to 18446744073709551615
rocksdb_delete_obsolete_files_period_micros
--rocksdb-delete-obsolete-files-period-micros=#
numeric
21600000000
0
to 9223372036854775807
rocksdb_enable_2pc
--rocksdb-enable-2pc={0|1}
boolean
ON
rocksdb_enable_bulk_load_api
--rocksdb-enable-bulk-load-api={0|1}
boolean
ON
rocksdb_enable_thread_tracking
--rocksdb-enable-thread-tracking={0|1}
boolean
OFF
rocksdb_enable_ttl
--rocksdb-enable-ttl={0|1}
boolean
ON
rocksdb_enable_ttl_read_filtering
--rocksdb-enable-ttl-read-filtering={0|1}
boolean
ON
rocksdb_enable_write_thread_adaptive_yield
--rocksdb-enable-write-thread-adaptive-yield={0|1}
boolean
OFF
rocksdb_error_if_exists
--rocksdb-error-if-exists={0|1}
boolean
OFF
rocksdb_flush_log_at_trx_commit
--rocksdb-flush-log-at-trx-commit=#
numeric
1
0
to 2
rocksdb_flush_memtable_on_analyze
--rocksdb-flush-memtable-on-analyze={0|1}
boolean
ON
rocksdb_force_compute_memtable_stats
--rocksdb-force-compute-memtable-stats={0|1}
boolean
ON
rocksdb_force_compute_memtable_stats_cachetime
--rocksdb-force-compute-memtable-stats-cachetime=#
numeric
60000000
0
to 2147483647
rocksdb_force_flush_memtable_and_lzero_now
--rocksdb-force-flush-memtable-and-lzero-now={0|1}
boolean
OFF
rocksdb_force_flush_memtable_now
--rocksdb-force-flush-memtable-now={0|1}
boolean
OFF
rocksdb_force_index_records_in_range
--rocksdb-force-index-records-in-range=#
numeric
1
0
to 2147483647
rocksdb_git_hash
--rocksdb-git-hash=value=#
string
rocksdb_hash_index_allow_collision
--rocksdb-hash-index-allow-collision={0|1}
boolean
ON
rocksdb_index_type
--rocksdb-index-type=value
enum
kBinarySearch
kBinarySearch
, kHashSearch
rocksdb_info_log_level
--rocksdb-info-log-level=value
enum
error_level
error_level
, debug_level
, info_level
, warn_level
, fatal_level
rocksdb_io_write_timeout
--rocksdb-io-write-timeout=#
numeric
0
0
to 4294967295
rocksdb_is_fd_close_on_exec
--rocksdb-is-fd-close-on-exec={0|1}
boolean
ON
rocksdb_keep_log_file_num
--rocksdb-keep-log-file-num=#
numeric
1000
0
to 18446744073709551615
rocksdb_large_prefix
--rocksdb-large_prefix={0|1}
boolean
OFF
rocksdb_lock_scanned_rows
--rocksdb-lock-scanned-rows={0|1}
boolean
OFF
rocksdb_lock_wait_timeout
--rocksdb-lock-wait-timeout=#
numeric
1
1
to 1073741824
rocksdb_log_file_time_to_roll
--rocksdb-log-file-time-to_roll=#
numeric
0
0
to 18446744073709551615
rocksdb_manifest_preallocation_size
--rocksdb-manifest-preallocation-size=#
numeric
0
0
to 18446744073709551615
rocksdb_manual_wal_flush
--rocksdb-manual-wal-flush={0|1}
boolean
ON
rocksdb_master_skip_tx_api
--rocksdb-master-skip-tx-api={0|1}
boolean
OFF
rocksdb_max_background_compactions
--rocksdb-max-background-compactions=#
numeric
1
1
to 64
rocksdb_max_background_flushes
--rocksdb-max-background-flushes=#
numeric
1
1
to 64
rocksdb_max_background_jobs
--rocksdb-max-background-jobs=#
numeric
2
-1
to 64
rocksdb_max_latest_deadlocks
--rocksdb-max-latest-deadlocks=#
numeric
5
0
to 4294967295
rocksdb_max_log_file_size
--rocksdb-max-log-file-size=#
numeric
0
0
to 18446744073709551615
rocksdb_max_manifest_file_size
--rocksdb-manifest-log-file-size=#
numeric
18446744073709551615
0
to 18446744073709551615
rocksdb_max_open_files
--rocksdb-max-open-files=#
numeric
-1
-1
to 2147483647
rocksdb_max_row_locks
--rocksdb-max-row-locks=#
numeric
1048576
1
to 1073741824
(>= MariaDB 10.3.10, MariaDB 10.2.18) 1
to 1048576
(<= MariaDB 10.3.9, MariaDB 10.2.17) rocksdb_max_subcompactions
--rocksdb-max-subcompactions=#
numeric
1
1
to 64
rocksdb_max_total_wal_size
--rocksdb-max-total-wal-size=#
numeric
0
0
to 9223372036854775807
rocksdb_merge_buf_size
--rocksdb-merge-buf-size=#
numeric
67108864
100
to 18446744073709551615
rocksdb_merge_combine_read_size
--rocksdb-merge-combine-read-size=#
numeric
1073741824
100
to 18446744073709551615
rocksdb_merge_tmp_file_removal_delay_ms
--rocksdb-merge-tmp-file-removal-delay-ms=#
numeric
0
0
to 18446744073709551615
rocksdb_new_table_reader_for_compaction_inputs
--rocksdb-new-table-reader-for-compaction-inputs={0|1}
boolean
OFF
rocksdb_no_block_cache
--rocksdb-no-block-cache={0|1}
boolean
OFF
rocksdb_override_cf_options
--rocksdb-override-cf-options=value
string
rocksdb_paranoid_checks
--rocksdb-paranoid-checks={0|1}
boolean
ON
rocksdb_pause_background_work
--rocksdb-pause-background-work={0|1}
boolean
OFF
rocksdb_perf_context_level
--rocksdb-perf-context-level=#
numeric
0
0
to 4
rocksdb_persistent_cache_path
--rocksdb-persistent-cache-path=value
string
rocksdb_persistent_cache_size_mb
--rocksdb-persistent-cache-size-mb=#
numeric
0
0
to 18446744073709551615
rocksdb_pin_l0_filter_and_index_blocks_in_cache
--rocksdb-pin-l0-filter-and-index-blocks-in-cache={0|1}
boolean
ON
rocksdb_print_snapshot_conflict_queries
--rocksdb-print-snapshot-conflict-queries={0|1}
boolean
OFF
rocksdb_rate_limiter_bytes_per_sec
--rocksdb-rate-limiter-bytes-per-sec=#
numeric
0
0
to 9223372036854775807
rocksdb_read_free_rpl_tables
--rocksdb-read-free-rpl-tables=value
string
rocksdb_records_in_range
--rocksdb-records-in-range=#
numeric
0
0
to 2147483647
rocksdb_reset_stats
--rocksdb-reset-stats={0|1}
boolean
OFF
rocksdb_seconds_between_stat_computes
--rocksdb-seconds-between-stat-computes=#
numeric
3600
0
to 4294967295
rocksdb_signal_drop_index_thread
--rocksdb-signal-drop-index-thread={0|1}
boolean
OFF
rocksdb_sim_cache_size
--rocksdb-sim-cache-size=#
numeric
0
0
to 9223372036854775807
rocksdb_skip_bloom_filter_on_read
--rocksdb-skip-bloom-filter-on_read={0|1}
boolean
OFF
rocksdb_skip_fill_cache
--rocksdb-skip-fill-cache={0|1}
boolean
OFF
rocksdb_skip_unique_check_tables
--rocksdb-skip-unique-check-tables=value
string
.*
rocksdb_sst_mgr_rate_bytes_per_sec
--rocksdb-sst-mgr-rate-bytes-per-sec=#
numeric
0
0
to 18446744073709551615
rocksdb_stats_dump_period_sec
--rocksdb-stats-dump-period-sec=#
numeric
600
0
to 2147483647
rocksdb_store_row_debug_checksums
--rocksdb-store-row-debug-checksums={0|1}
boolean
OFF
rocksdb_strict_collation_check
--rocksdb-strict-collation-check={0|1}
boolean
ON
rocksdb_strict_collation_exceptions
--rocksdb-strict-collation-exceptions=value
string
rocksdb_supported_compression_types
--rocksdb-supported-compression-types=value
string
Snappy,Zlib
rocksdb_table_cache_numshardbits
--rocksdb-table-cache-numshardbits=#
numeric
6
0
to 2147483647
rocksdb_table_stats_sampling_pct
--rocksdb-table-stats-sampling-pct=#
numeric
10
0
to 100
rocksdb_tmpdir
--rocksdb-tmpdir[=value]
string
rocksdb_trace_sst_api
--rocksdb-trace-sst-api={0|1}
boolean
OFF
rocksdb_unsafe_for_binlog
--rocksdb-unsafe-for-binlog={0|1}
boolean
OFF
rocksdb_update_cf_options
--rocksdb-update-cf-options=value
varchar
rocksdb_use_adaptive_mutex
--rocksdb-use-adaptive-mutex={0|1}
boolean
OFF
rocksdb_use_clock_cache
--rocksdb-use-clock-cache={0|1}
boolean
OFF
rocksdb_use_direct_io_for_flush_and_compaction
--rocksdb-use-direct-io-for-flush-and-compaction={0|1}
boolean
OFF
rocksdb_use_direct_reads
--rocksdb-use-direct-reads={0|1}
boolean
OFF
rocksdb_use_direct_writes
--rocksdb-use-direct-reads={0|1}
boolean
OFF
rocksdb_use_fsync
--rocksdb-use-fsync={0|1}
boolean
OFF
rocksdb_validate_tables
--rocksdb-validate-tables=#
numeric
1
0
to 2
rocksdb_verify_row_debug_checksums
--rocksdb-verify-row-debug-checksums={0|1}
boolean
OFF
rocksdb_wal_bytes_per_sync
--rocksdb-wal-bytes-per-sync=#
numeric
0
0
to 18446744073709551615
rocksdb_wal_dir
--rocksdb-wal-dir=value
string
rocksdb_wal_recovery_mode
--rocksdb-wal-recovery-mode=#
numeric
1
0
to 3
rocksdb_wal_size_limit_mb
--rocksdb-wal-size-limit-mb=#
numeric
0
0
to 9223372036854775807
rocksdb_wal_ttl_seconds
--rocksdb-wal-ttl-seconds=#
numeric
0
0
to 9223372036854775807
rocksdb_whole_key_filtering
--rocksdb-whole-key-filtering={0|1}
boolean
ON
rocksdb_write_batch_max_bytes
--rocksdb-write-batch-max-bytes=#
numeric
0
0
to 18446744073709551615
rocksdb_write_disable_wal
--rocksdb-write-disable-wal={0|1}
boolean
OFF
rocksdb_write_ignore_missing_column_families
--rocksdb-write-ignore-missing-column-familiesl={0|1}
boolean
OFF
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/myrocks-system-variables/