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/