MyRocks System Variables
You are viewing an old version of this article. View
the current version here.
Contents
- rocksdb_access_hint_on_compaction_start
- rocksdb_advise_random_on_open
- rocksdb_allow_concurrent_memtable_write
- rocksdb_allow_mmap_reads
- rocksdb_allow_mmap_writes
- rocksdb_background_sync
- rocksdb_base_background_compactions
- rocksdb_blind_delete_primary_key
- rocksdb_block_cache_size
- rocksdb_block_restart_interval
- rocksdb_block_size
- rocksdb_block_size_deviation
- rocksdb_bulk_load
- rocksdb_bulk_load_size
- rocksdb_bytes_per_sync
- rocksdb_cache_index_and_filter_blocks
- rocksdb_checksums_pct
- rocksdb_collect_sst_properties
- rocksdb_commit_in_the_middle
- rocksdb_compact_cf
- rocksdb_compaction_readahead_size
- rocksdb_compaction_sequential_deletes
- rocksdb_compaction_sequential_deletes_count_sd
- rocksdb_compaction_sequential_deletes_file_size
- rocksdb_compaction_sequential_deletes_window
- rocksdb_create_checkpoint
- rocksdb_create_if_missing
- rocksdb_create_missing_column_families
- rocksdb_datadir
- rocksdb_db_write_buffer_size
- rocksdb_deadlock_detect
- rocksdb_debug_optimizer_no_zero_cardinality
- rocksdb_default_cf_options
- rocksdb_delayed_write_rate
- rocksdb_delete_obsolete_files_period_micros
- rocksdb_enable_2pc
- rocksdb_enable_bulk_load_api
- rocksdb_enable_thread_tracking
- rocksdb_enable_write_thread_adaptive_yield
- rocksdb_error_if_exists
- rocksdb_flush_log_at_trx_commit
- rocksdb_flush_memtable_on_analyze
- rocksdb_force_compute_memtable_stats
- rocksdb_force_flush_memtable_now
- rocksdb_force_index_records_in_range
- rocksdb_hash_index_allow_collision
- rocksdb_index_type
- rocksdb_info_log_level
- rocksdb_is_fd_close_on_exec
- rocksdb_keep_log_file_num
- rocksdb_lock_scanned_rows
- rocksdb_lock_wait_timeout
- rocksdb_log_file_time_to_roll
- rocksdb_manifest_preallocation_size
- rocksdb_master_skip_tx_api
- rocksdb_max_background_compactions
- rocksdb_max_background_flushes
- rocksdb_max_log_file_size
- rocksdb_max_manifest_file_size
- rocksdb_max_open_files
- rocksdb_max_row_locks
- rocksdb_max_subcompactions
- rocksdb_max_total_wal_size
- rocksdb_merge_buf_size
- rocksdb_merge_combine_read_size
- rocksdb_new_table_reader_for_compaction_inputs
- rocksdb_no_block_cache
- rocksdb_override_cf_options
- rocksdb_paranoid_checks
- rocksdb_pause_background_work
- rocksdb_perf_context_level
- rocksdb_persistent_cache_path
- rocksdb_persistent_cache_size_mb
- rocksdb_pin_l0_filter_and_index_blocks_in_cache
- rocksdb_print_snapshot_conflict_queries
- rocksdb_rate_limiter_bytes_per_sec
- rocksdb_read_free_rpl_tables
- rocksdb_records_in_range
- rocksdb_seconds_between_stat_computes
- rocksdb_signal_drop_index_thread
- rocksdb_skip_bloom_filter_on_read
- rocksdb_skip_fill_cache
- rocksdb_skip_unique_check_tables
- rocksdb_stats_dump_period_sec
- rocksdb_store_row_debug_checksums
- rocksdb_strict_collation_check
- rocksdb_strict_collation_exceptions
- rocksdb_supported_compression_types
- rocksdb_table_cache_numshardbits
- rocksdb_table_stats_sampling_pct
- rocksdb_tmpdir
- rocksdb_trace_sst_api
- rocksdb_unsafe_for_binlog
- rocksdb_use_adaptive_mutex
- rocksdb_use_direct_io_for_flush_and_compaction
- rocksdb_use_direct_reads
- rocksdb_use_fsync
- rocksdb_validate_tables
- rocksdb_verify_row_debug_checksums
- rocksdb_wal_bytes_per_sync
- rocksdb_wal_dir
- rocksdb_wal_recovery_mode
- rocksdb_wal_size_limit_mb
- rocksdb_wal_ttl_seconds
- rocksdb_whole_key_filtering
- rocksdb_write_disable_wal
- rocksdb_write_ignore_missing_column_families
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
- 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
to3
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
to64
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
to9223372036854775807
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
to2147483647
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
to18446744073709551615
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
to2147483647
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
to1073741824
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
to18446744073709551615
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
to100
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
to18446744073709551615
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
to2000000
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
to9223372036854775807
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
to2000000
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
to18446744073709551615
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
to18446744073709551615
rocksdb_delete_obsolete_files_period_micros
- Description: DBOptions::delete_obsolete_files_period_micros for RocksDB.
- Commandline:
--rocksdb-delete-obsolete-files-period-micros=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
21600000000
- Range:
0
to9223372036854775807
rocksdb_enable_2pc
- Description: Enable two phase commit for MyRocks.
- Commandline:
--rocksdb-enable-2pc={0|1}
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
ON
rocksdb_enable_bulk_load_api
- Description: Enables using SstFileWriter for bulk loading.
- Commandline:
--rocksdb-enable-bulk-load-api={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
ON
rocksdb_enable_thread_tracking
- Description: DBOptions::enable_thread_tracking for RocksDB.
- Commandline:
--rocksdb-enable-thread-tracking={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
OFF
rocksdb_enable_write_thread_adaptive_yield
- Description: DBOptions::enable_write_thread_adaptive_yield for RocksDB.
- Commandline:
--rocksdb-enable-write-thread-adaptive-yield={0|1}
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_error_if_exists
- Description: DBOptions::error_if_exists for RocksDBB.
- Commandline:
--rocksdb-error-if-exists={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
OFF
rocksdb_flush_log_at_trx_commit
- Description: Sync on transaction commit. Similar to innodb_flush_log_at_trx_commit. 1: sync on commit, 0,2: not sync on commit. One can check the flushing by examining the rocksdb_wal_synced and rocksdb_wal_bytes status variables.
- Commandline:
--rocksdb-flush-log-at-trx-commit=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1
- Range:
0
to2
rocksdb_flush_memtable_on_analyze
- Description: Forces memtable flush on ANALZYE table to get accurate cardinality.
- Commandline:
--rocksdb-flush-memtable-on-analyze={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
ON
rocksdb_force_compute_memtable_stats
- Description: Force to always compute memtable stats.
- Commandline:
--rocksdb-force-compute-memtable-stats={0|1}
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
ON
rocksdb_force_flush_memtable_now
- Description: Forces memstore flush which may block all write requests so be careful.
- Commandline:
--rocksdb-force-flush-memtable-now={0|1}
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_force_index_records_in_range
- Description: Used to override the result of records_in_range() when FORCE INDEX is used.
- Commandline:
--rocksdb-force-index-records-in-range=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1
- Range:
0
to2147483647
rocksdb_hash_index_allow_collision
- Description: BlockBasedTableOptions::hash_index_allow_collision for RocksDB.
- Commandline:
--rocksdb-hash-index-allow-collision={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
ON
rocksdb_index_type
- Description: BlockBasedTableOptions::index_type for RocksDB.
- Commandline:
--rocksdb-index-type=value
- Scope: Global
- Dynamic: No
- Data Type:
enum
- Default Value:
kBinarySearch
- Valid Values:
kBinarySearch
,kHashSearch
rocksdb_info_log_level
- Description: Filter level for info logs to be written mysqld error log. Valid values include 'debug_level', 'info_level', 'warn_level''error_level' and 'fatal_level'..
- Commandline:
--rocksdb-info-log-level=value
- Scope: Global
- Dynamic: Yes
- Data Type:
enum
- Default Value:
error_level
- Valid Values:
error_level
,debug_level
,info_level
,warn_level
,fatal_level
rocksdb_is_fd_close_on_exec
- Description: DBOptions::is_fd_close_on_exec for RocksDB.
- Commandline:
--rocksdb-is-fd-close-on-exec={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
ON
rocksdb_keep_log_file_num
- Description: DBOptions::keep_log_file_num for RocksDB.
- Commandline:
--rocksdb-keep-log-file-num=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
1000
- Range:
0
to18446744073709551615
rocksdb_lock_scanned_rows
- Description: Take and hold locks on rows that are scanned but not updated.
- Commandline:
--rocksdb-lock-scanned-rows={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_lock_wait_timeout
- Description: Number of seconds to wait for lock.
- Commandline:
--rocksdb-lock-wait-timeout=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1
- Range:
1
to1073741824
rocksdb_log_file_time_to_roll
- Description: DBOptions::log_file_time_to_roll for RocksDB.
- Commandline:
--rocksdb-log-file-time-to_roll=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
0
- Range:
0
to18446744073709551615
rocksdb_manifest_preallocation_size
- Description: DBOptions::manifest_preallocation_size for RocksDB.
- Commandline:
--rocksdb-manifest-preallocation-size=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
0
- Range:
0
to18446744073709551615
rocksdb_master_skip_tx_api
- Description: Skipping holding any lock on row access. Not effective on slave.
- Commandline:
--rocksdb-master-skip-tx-api={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_max_background_compactions
- Description: DBOptions::max_background_compactions for RocksDB.
- Commandline:
--rocksdb-max-background-compactions=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1
- Range:
1
to64
rocksdb_max_background_flushes
- Description: DBOptions::max_background_flushes for RocksDB.
- Commandline:
--rocksdb-max-background-flushes=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
1
- Range:
1
to64
rocksdb_max_log_file_size
- Description: DBOptions::max_log_file_size for RocksDB.
- Commandline:
--rocksdb-max-log-file-size=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
0
- Range:
0
to18446744073709551615
rocksdb_max_manifest_file_size
- Description: DBOptions::max_manifest_file_size for RocksDB.
- Commandline:
--rocksdb-manifest-log-file-size=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
18446744073709551615
- Range:
0
to18446744073709551615
rocksdb_max_open_files
- Description: DBOptions::max_open_files for RocksDB.
- Commandline:
--rocksdb-max-open-files=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
-1
- Range:
-1
to2147483647
rocksdb_max_row_locks
- Description: Maximum number of locks a transaction can have.
- Commandline:
--rocksdb-max-row-locks=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1073741824
- Range:
1
to1073741824
rocksdb_max_subcompactions
- Description: DBOptions::max_subcompactions for RocksDB.
- Commandline:
--rocksdb-max-subcompactions=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
1
- Range:
1
to64
rocksdb_max_total_wal_size
- Description: DBOptions::max_total_wal_size for RocksDB.
- Commandline:
--rocksdb-max-total-wal-size=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
0
- Range:
0
to9223372036854775807
rocksdb_merge_buf_size
- Description: Size to allocate for merge sort buffers written out to disk during inplace index creation.
- Commandline:
--rocksdb-merge-buf-size=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
67108864
- Range:
100
to18446744073709551615
rocksdb_merge_combine_read_size
- Description: Size that we have to work with during combine (reading from disk) phase of external sort during fast index creation.
- Commandline:
--rocksdb-merge-combine-read-size=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1073741824
- Range:
100
to18446744073709551615
rocksdb_new_table_reader_for_compaction_inputs
- Description: DBOptions::new_table_reader_for_compaction_inputs for RocksDB.
- Commandline:
--rocksdb-new-table-reader-for-compaction-inputs={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
OFF
rocksdb_no_block_cache
- Description: BlockBasedTableOptions::no_block_cache for RocksDB.
- Commandline:
--rocksdb-no-block-cache={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
OFF
rocksdb_override_cf_options
- Description: Option overrides per cf for RocksDB.
- Commandline:
--rocksdb-override-cf-options=value
- Scope: Global
- Dynamic: No
- Data Type:
string
- Default Value: (Empty)
rocksdb_paranoid_checks
- Description: DBOptions::paranoid_checks for RocksDB.
- Commandline:
--rocksdb-paranoid-checks={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
ON
rocksdb_pause_background_work
- Description: Disable all rocksdb background operations.
- Commandline:
--rocksdb-pause-background-work={0|1}
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_perf_context_level
- Description: Perf Context Level for rocksdb internal timer stat collection.
- Commandline:
--rocksdb-perf-context-level=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
0
- Range:
0
to4
rocksdb_persistent_cache_path
- Description: Path for BlockBasedTableOptions::persistent_cache for RocksDB.
- Commandline:
--rocksdb-persistent-cache-path=value
- Scope: Global
- Dynamic: No
- Data Type:
string
- Default Value: (Empty)
rocksdb_persistent_cache_size_mb
- Description: Size of cache in MB for BlockBasedTableOptions::persistent_cache for RocksDB.
- Commandline:
--rocksdb-persistent-cache-size-mb=#
- Scope: Global, Session
- Dynamic: No
- Data Type:
numeric
- Default Value:
0
- Range:
0
to18446744073709551615
rocksdb_pin_l0_filter_and_index_blocks_in_cache
- Description: pin_l0_filter_and_index_blocks_in_cache for RocksDB.
- Commandline:
--rocksdb-pin-l0-filter-and-index-blocks-in-cache={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
ON
rocksdb_print_snapshot_conflict_queries
- Description: Logging queries that got snapshot conflict errors into *.err log.
- Commandline:
--rocksdb-print-snapshot-conflict-queries={0|1}
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_rate_limiter_bytes_per_sec
- Description: DBOptions::rate_limiter bytes_per_sec for RocksDB.
- Commandline:
--rocksdb-rate-limiter-bytes-per-sec=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
0
- Range:
0
to9223372036854775807
rocksdb_read_free_rpl_tables
- Description: List of tables that will use read-free replication on the slave (i.e. not lookup a row during replication).
- Commandline:
--rocksdb-read-free-rpl-tables=value
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
string
- Default Value: (Empty)
rocksdb_records_in_range
- Description: Used to override the result of records_in_range(). Set to a positive number to override.
- Commandline:
--rocksdb-records-in-range=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
0
- Range:
0
to2147483647
rocksdb_seconds_between_stat_computes
- Description: Sets a number of seconds to wait between optimizer stats recomputation. Only changed indexes will be refreshed.
- Commandline:
--rocksdb-seconds-between-stat-computes=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
3600
- Range:
0
to4294967295
rocksdb_signal_drop_index_thread
- Description: Wake up drop index thread.
- Commandline:
--rocksdb-signal-drop-index-thread={0|1}
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_skip_bloom_filter_on_read
- Description: Skip using bloom filter for reads.
- Commandline:
--rocksdb-skip-bloom-filter-on_read={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_skip_fill_cache
- Description: Skip filling block cache on read requests.
- Commandline:
--rocksdb-skip-fill-cache={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_skip_unique_check_tables
- Description: Skip unique constraint checking for the specified tables.
- Commandline:
--rocksdb-skip-unique-check-tables=value
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
string
- Default Value:
.*
rocksdb_stats_dump_period_sec
- Description: DBOptions::stats_dump_period_sec for RocksDB.
- Commandline:
--rocksdb-stats-dump-period-sec=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
600
- Range:
0
to2147483647
rocksdb_store_row_debug_checksums
- Description: Include checksums when writing index/table records.
- Commandline:
--rocksdb-store-row-debug-checksums={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_strict_collation_check
- Description: Enforce case sensitive collation for MyRocks indexes.
- Commandline:
--rocksdb-strict-collation-check={0|1}
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
ON
rocksdb_strict_collation_exceptions
- Description: List of tables (using regex) that are excluded from the case sensitive collation enforcement.
- Commandline:
--rocksdb-strict-collation-exceptions=value
- Scope: Global
- Dynamic: Yes
- Data Type:
string
- Default Value: (Empty)
rocksdb_supported_compression_types
- Description: Compression algorithms supported by RocksDB.
- Commandline:
--rocksdb-supported-compression-types=value
- Scope: Global
- Dynamic: No
- Data Type:
string
- Default Value:
Snappy,Zlib
rocksdb_table_cache_numshardbits
- Description: DBOptions::table_cache_numshardbits for RocksDB.
- Commandline:
--rocksdb-table-cache-numshardbits=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
6
- Range:
0
to2147483647
rocksdb_table_stats_sampling_pct
- Description: Percentage of entries to sample when collecting statistics about table properties. Specify either 0 to sample everything or percentage [1..100]. By default 10% of entries are sampled.
- Commandline:
--rocksdb-table-stats-sampling-pct=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
10
- Range:
0
to100
rocksdb_tmpdir
- Description: Directory for temporary files during DDL operations.
- Commandline:
--rocksdb-tmpdir[=value]
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
string
- Default Value: (Empty)
rocksdb_trace_sst_api
- Description: Generate trace output in the log for each call to the SstFileWriter.
- Commandline:
--rocksdb-trace-sst-api={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_unsafe_for_binlog
- Description: Allowing statement based binary logging which may break consistency.
- Commandline:
--rocksdb-unsafe-for-binlog={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_use_adaptive_mutex
- Description: DBOptions::use_adaptive_mutex for RocksDB.
- Commandline:
--rocksdb-use-adaptive-mutex={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
OFF
rocksdb_use_direct_io_for_flush_and_compaction
- Description: DBOptions::use_direct_io_for_flush_and_compaction for RocksDB.
- Commandline:
--rocksdb-use-direct-io-for-flush-and-compaction={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
OFF
rocksdb_use_direct_reads
- Description: DBOptions::use_direct_reads for RocksDB.
- Commandline:
--rocksdb-use-direct-reads={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
OFF
rocksdb_use_fsync
- Description: DBOptions::use_fsync for RocksDB.
- Commandline:
--rocksdb-use-fsync={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
OFF
rocksdb_validate_tables
- Description: Verify all .frm files match all RocksDB tables (0 means no verification, 1 means verify and fail on error, and 2 means verify but continue.
- Commandline:
--rocksdb-validate-tables=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
1
- Range:
0
to2
rocksdb_verify_row_debug_checksums
- Description: Verify checksums when reading index/table records.
- Commandline:
--rocksdb-verify-row-debug-checksums={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_wal_bytes_per_sync
- Description: DBOptions::wal_bytes_per_sync for RocksDB.
- Commandline:
--rocksdb-wal-bytes-per-sync=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
0
- Range:
0
to18446744073709551615
rocksdb_wal_dir
- Description: DBOptions::wal_dir for RocksDB.
- Commandline:
--rocksdb-wal-dir=value
- Scope: Global
- Dynamic: No
- Data Type:
string
- Default Value: (Empty)
rocksdb_wal_recovery_mode
- Description: DBOptions::wal_recovery_mode for RocksDB. Default is kAbsoluteConsistency.
- Commandline:
--rocksdb-wal-recovery-mode=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1
- Range:
0
to3
rocksdb_wal_size_limit_mb
- Description: DBOptions::WAL_size_limit_MB for RocksDB.
- Commandline:
--rocksdb-wal-size-limit-mb=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
0
- Range:
0
to9223372036854775807
rocksdb_wal_ttl_seconds
- Description: DBOptions::WAL_ttl_seconds for RocksDB.
- Commandline:
--rocksdb-wal-ttl-seconds=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
0
- Range:
0
to9223372036854775807
rocksdb_whole_key_filtering
- Description: BlockBasedTableOptions::whole_key_filtering for RocksDB.
- Commandline:
--rocksdb-whole-key-filtering={0|1}
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
ON
rocksdb_write_disable_wal
- Description: WriteOptions::disableWAL for RocksDB.
- Commandline:
--rocksdb-write-disable-wal={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
rocksdb_write_ignore_missing_column_families
- Description: WriteOptions::ignore_missing_column_families for RocksDB.
- Commandline:
--rocksdb-write-ignore-missing-column-familiesl={0|1}
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
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.