mariadbd & mysqld for MariaDB Enterprise Server 10.6

--allow-suspicious-udfs

Allows use of UDFs consisting of only one symbol xxx() without corresponding xxx_init() or xxx_deinit(). That also means that one can load any function from any library, for example exit() from libc.so

--analyze-sample-percentage

Percentage of rows from the table ANALYZE TABLE will sample to collect table statistics. Set to 0 to let MariaDB decide what percentage of rows to sample.

--aria-block-size

Block size to be used for Aria index pages.

--aria-checkpoint-log-activity

Number of bytes that the transaction log has to grow between checkpoints before a new checkpoint is written to the log.

--aria-force-start-after-recovery-failures

Number of consecutive log recovery failures after which logs will be automatically deleted to cure the problem; 0 (the default) disables the feature.

--aria-group-commit-interval

Interval between commits in microseconds (1/1000000 sec). 0 stands for no waiting for other threads to come and do a commit in "hard" mode and no sync()/commit at all in "soft" mode. Option has only an effect if aria_group_commit is used

--aria-log-file-size

Limit for transaction log size

--aria-max-sort-file-size

Don't use the fast sort index method to created index if the temporary file would get bigger than this.

--aria-pagecache-age-threshold

This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in the page cache.

--aria-pagecache-division-limit

The minimum percentage of warm blocks in key cache

--aria-recover-options

Specifies how corrupted tables should be automatically repaired. Any combination of: NORMAL, BACKUP, FORCE, QUICK, OFF

--aria-sort-buffer-size

The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.

--aria-sync-log-dir

Controls syncing directory after log file growth and new file creation. One of: NEVER, NEWFILE, ALWAYS

--auto-increment-offset

Offset added to Auto-increment columns. Used when auto-increment-increment != 1

--automatic-sp-privileges

Creating and dropping stored procedures alters ACLs (Defaults to on; use --skip-automatic-sp-privileges to disable.)

--basedir (-b)

Path to installation directory. All paths are usually resolved relative to this

--bind-address

IP address to bind to.

--binlog-cache-size

The size of the transactional cache for updates to transactional engines for the binary log. If you often use transactions containing many statements, you can increase this to get more performance

--binlog-commit-wait-count

If non-zero, binlog write will wait at most binlog_commit_wait_usec microseconds for at least this many commits to queue up for group commit to the binlog. This can reduce I/O on the binlog and provide increased opportunity for parallel apply on the slave, but too high a value will decrease commit throughput.

--binlog-direct-non-transactional-updates

Causes updates to non-transactional engines using statement format to be written directly to binary log. Before using this option make sure that there are no dependencies between transactional and non-transactional tables such as in the statement INSERT INTO t_myisam SELECT * FROM t_innodb; otherwise, slaves may diverge from the master.

--binlog-expire-logs-seconds

If non-zero, binary logs will be purged after binlog_expire_logs_seconds seconds; It and expire_logs_days are linked, such that changes in one are converted into the other. Possible purges happen at startup and at binary log rotation.

--binlog-format

What form of binary logging the master will use: either ROW for row-based binary logging, STATEMENT for statement-based binary logging, or MIXED. MIXED is statement-based binary logging except for those statements where only row-based is correct: those which involve user-defined functions (i.e., UDFs) or the UUID() function; for those, row-based binary logging is automatically used.

--binlog-optimize-thread-scheduling

Run fast part of group commit in a single thread, to optimize kernel thread scheduling. On by default. Disable to run each transaction in group commit in its own thread, which can be slower at very high concurrency. This option is mostly for testing one algorithm versus the other, and it should not normally be necessary to change it. (Defaults to on; use --skip-binlog-optimize-thread-scheduling to disable.)

--binlog-row-image

Controls whether rows should be logged in 'FULL', 'NOBLOB' or 'MINIMAL' formats. 'FULL', means that all columns in the before and after image are logged. 'NOBLOB', means that mysqld avoids logging blob columns whenever possible (e.g., blob column was not changed or is not part of primary key). 'MINIMAL', means that a PK equivalent (PK columns or full row if there is no PK in the table) is logged in the before image, and only changed columns are logged in the after image. (Default: FULL).

--binlog-stmt-cache-size

The size of the statement cache for updates to non-transactional engines for the binary log. If you often use statements updating a great number of rows, you can increase this to get more performance.

--bootstrap

Used by mysql installation scripts.

--character-set-client-handshake

Don't ignore client side character set value sent during handshake. (Defaults to on; use --skip-character-set-client-handshake to disable.)

--character-set-server (-C)

Set the default character set.

--chroot (-r)

Chroot mysqld daemon during startup.

--column-compression-threshold

Minimum column data length eligible for compression

--column-compression-zlib-strategy

The strategy parameter is used to tune the compression algorithm. Use the value DEFAULT_STRATEGY for normal data, FILTERED for data produced by a filter (or predictor), HUFFMAN_ONLY to force Huffman encoding only (no string match), or RLE to limit match distances to one (run-length encoding). Filtered data consists mostly of small values with a somewhat random distribution. In this case, the compression algorithm is tuned to compress them better. The effect of FILTERED is to force more Huffman coding and less string matching; it is somewhat intermediate between DEFAULT_STRATEGY and HUFFMAN_ONLY. RLE is designed to be almost as fast as HUFFMAN_ONLY, but give better compression for PNG image data. The strategy parameter only affects the compression ratio but not the correctness of the compressed output even if it is not set appropriately. FIXED prevents the use of dynamic Huffman codes, allowing for a simpler decoder for special applications.

--columnstore

Enable or disable Columnstore plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--columnstore-cache-inserts

Perform cache-based inserts to ColumnStore

--columnstore-columns

Enable or disable COLUMNSTORE_COLUMNS plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--columnstore-decimal-overflow-check

Enable/disable for ColumnStore to check for overflow in arithmetic operation.

--columnstore-derived-handler

Enable/Disable the MCS derived_handler (Defaults to on; use --skip-columnstore-derived-handler to disable.)

--columnstore-diskjoin-force-run

Force run for the disk join step.

--columnstore-diskjoin-max-partition-tree-depth

The maximum size of partition tree depth.

--columnstore-double-for-decimal-math

Enable/disable for ColumnStore to replace DECIMAL with DOUBLE in arithmetic operation.

--columnstore-files

Enable or disable COLUMNSTORE_FILES plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--columnstore-import-for-batchinsert-delimiter

ASCII value of the delimiter used by LDI and INSERT..SELECT

--columnstore-local-query

Enable/disable the ColumnStore local PM query only feature.

--columnstore-max-pm-join-result-count

The maximum size of the join result for the single block on BPP.

--columnstore-ordered-only

Always use the first table in the from clause as the large side table for joins

--columnstore-select-handler

Set the MCS select_handler to Disabled, Enabled, or Automatic. One of: OFF, ON, AUTO

--columnstore-string-scan-threshold

Max number of blocks in a dictionary file to be scanned for filtering

--columnstore-tables

Enable or disable COLUMNSTORE_TABLES plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--columnstore-use-decimal-scale

Enable/disable the MCS decimal scale to be used internally

--columnstore-varbin-always-hex

Always display/process varbinary columns as if they have been hexified.

--concurrent-insert

Use concurrent insert with MyISAM. One of: NEVER, AUTO, ALWAYS

--console

Write error output on screen; don't remove the console window on windows.

--cracklib-password-check

Enable or disable cracklib_password_check plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--datadir (-h)

Path to the database root directory

--datetime-format

The DATETIME format (ignored)

--deadlock-search-depth-short

Short search depth for the two-step deadlock detection

--deadlock-timeout-short

Short timeout for the two-step deadlock detection (in microseconds)

--debug-abort-slave-event-count

Option used by mysql-test for debugging and testing of replication.

--debug-exit-info (-T)

Used for debugging. Use at your own risk.

--debug-max-binlog-dump-events

Option used by mysql-test for debugging and testing of replication.

--debug-no-thread-alarm

Disable system thread alarm calls. Disabling it may be useful in debugging or testing, never do it in production

--default-password-lifetime

This defines the global password expiration policy. 0 means automatic password expiration is disabled. If the value is a positive integer N, the passwords must be changed every N days. This behavior can be overridden using the password expiration options in ALTER USER.

--default-storage-engine

The default storage engine for new tables

--default-tmp-storage-engine

The default storage engine for user-created temporary tables

--defaults-extra-file

Read this file after the global files are read.

--defaults-group-suffix

Additionally read default groups with # appended as a suffix.

--delayed-insert-limit

After inserting delayed_insert_limit rows, the INSERT DELAYED handler will check if there are any SELECT statements pending. If so, it allows these to execute before continuing.

--delayed-queue-size

What size queue (in rows) should be allocated for handling INSERT DELAYED. If the queue becomes full, any client that does INSERT DELAYED will wait until there is room in the queue again

--disconnect-on-expired-password

This variable controls how the server handles clients that are not aware of the sandbox mode. If enabled, the server disconnects the client, otherwise the server puts the client in a sandbox mode.

--div-precision-increment

Precision of the result of '/' operator will be increased on that value

--encrypt-binlog

Encrypt binary logs (including relay logs)

--encrypt-tmp-files

Encrypt temporary files (created for filesort, binary log cache, etc)

--eq-range-index-dive-limit

The optimizer will use existing index statistics instead of doing index dives for equality ranges if the number of equality ranges for the index is larger than or equal to this number. If set to 0, index dives are always used.

--expensive-subquery-limit

The maximum number of rows a subquery may examine in order to be executed during optimization and used for constant optimization

--explicit-defaults-for-timestamp

This option causes CREATE TABLE to create all TIMESTAMP columns as NULL with DEFAULT NULL attribute, Without this option, TIMESTAMP columns are NOT NULL and have implicit DEFAULT clauses.

--extra-max-connections

The number of connections on extra-port

--feedback

Enable or disable FEEDBACK plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--feedback-send-retry-wait

Wait this many seconds before retrying a failed send.

--feedback-url

Space separated URLs to send the feedback report to.

--file-key-management

Enable or disable file_key_management plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--file-key-management-filekey

Key to encrypt / decrypt the keyfile.

--flashback

Setup the server to use flashback. This enables binary log in row mode and will enable extra logging for DDL's needed by flashback feature

--flush-time

A dedicated thread is created to flush all tables at the given interval

--ft-max-word-len

The maximum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable

--ft-query-expansion-limit

Number of best matches to use for query expansion

--gdb

Set up signals usable for debugging. Deprecated, use --debug-gdb instead.

--general-log-file

Log connections and queries to given file

--group-concat-max-len

The maximum length of the result of function GROUP_CONCAT()

--gssapi-keytab-path

Keytab file path for Kerberos authentication

--gtid-cleanup-batch-size

Normally does not need tuning. How many old rows must accumulate in the mysql.gtid_slave_pos table before a background job will be run to delete them. Can be increased to reduce number of commits if using many different engines with --gtid_pos_auto_engines, or to reduce CPU overhead if using a huge number of different gtid_domain_ids. Can be decreased to reduce number of old rows in the table.

--gtid-ignore-duplicates

When set, different master connections in multi-source replication are allowed to receive and process event groups with the same GTID (when using GTID mode). Only one will be applied, any others will be ignored. Within a given replication domain, just the sequence number will be used to decide whether a given GTID has been already applied; this means it is the responsibility of the user to ensure that GTID sequence numbers are strictly increasing.

--gtid-strict-mode

Enforce strict seq_no ordering of events in the binary log. Slave stops with an error if it encounters an event that would cause it to generate an out-of-order binlog if executed. When ON the same server-id semisync-replicated transactions that duplicate exising ones in binlog are ignored without error and slave interruption.

--hashicorp-key-management-cache-timeout

Cache timeout for key data (in milliseconds)

--hashicorp-key-management-caching-enabled

Enable key caching (storing key values received from the Hashicorp Vault server in the local memory) (Defaults to on; use --skip-hashicorp-key-management-caching-enabled to disable.)

--hashicorp-key-management-max-retries

Number of server request retries in case of timeout

--hashicorp-key-management-token

Authentication token that passed to the Hashicorp Vault in the request header

--hashicorp-key-management-vault-ca

Path to the Certificate Authority (CA) bundle (is a file that contains root and intermediate certificates)

--help (-?)

Display this help and exit.

--histogram-type

Specifies type of the histograms created by ANALYZE. Possible values are: SINGLE_PREC_HB - single precision height-balanced, DOUBLE_PREC_HB - double precision height-balanced.

--idle-readonly-transaction-timeout

The number of seconds the server waits for read-only idle transaction

--idle-write-transaction-timeout

The number of seconds the server waits for write idle transaction

--ignore-db-dirs

Specifies a directory to add to the ignore list when collecting database names from the datadir. Put a blank argument to reset the list accumulated so far.

--init-connect

Command(s) that are executed for each new connection (unless the user has SUPER privilege)

--init-rpl-role

Set the replication role. One of: MASTER, SLAVE

--innodb

Enable or disable InnoDB plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-adaptive-flushing-lwm

Percentage of log capacity below which no adaptive flushing happens.

--innodb-adaptive-hash-index-parts

Number of InnoDB Adaptive Hash Index Partitions (default 8)

--innodb-autoinc-lock-mode

The AUTOINC lock modes supported by InnoDB: 0 => Old style AUTOINC locking (for backward compatibility); 1 => New style AUTOINC locking; 2 => No AUTOINC locking (unsafe for SBR)

--innodb-buffer-page

Enable or disable INNODB_BUFFER_PAGE plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-buffer-pool-chunk-size

Size of a single memory chunk for resizing buffer pool. Online buffer pool resizing happens at this granularity. 0 means disable resizing buffer pool.

--innodb-buffer-pool-dump-now

Trigger an immediate dump of the buffer pool into a file named @@innodb_buffer_pool_filename

--innodb-buffer-pool-filename

Filename to/from which to dump/load the InnoDB buffer pool

--innodb-buffer-pool-load-at-startup

Load the buffer pool from a file named @@innodb_buffer_pool_filename (Defaults to on; use --skip-innodb-buffer-pool-load-at-startup to disable.)

--innodb-buffer-pool-size

The size of the memory buffer InnoDB uses to cache data and indexes of its tables.

--innodb-change-buffer-max-size

Maximum on-disk size of change buffer in terms of percentage of the buffer pool.

--innodb-checksum-algorithm

The algorithm InnoDB uses for page checksumming. Possible values are FULL_CRC32 for new files, always use CRC-32C; for old, see CRC32 below; STRICT_FULL_CRC32 for new files, always use CRC-32C; for old, see STRICT_CRC32 below; CRC32 write crc32, allow any of the other checksums to match when reading; STRICT_CRC32 write crc32, do not allow other algorithms to match when reading; INNODB write a software calculated checksum, allow any other checksums to match when reading; STRICT_INNODB write a software calculated checksum, do not allow other algorithms to match when reading; NONE write a constant magic number, do not do any checksum verification when reading; STRICT_NONE write a constant magic number, do not allow values other than that magic number when reading; Files updated when this option is set to crc32 or strict_crc32 will not be readable by MariaDB versions older than 10.0.4; new files created with full_crc32 are readable by MariaDB 10.4.3+

--innodb-cmp-per-index

Enable or disable INNODB_CMP_PER_INDEX plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-cmp-per-index-reset

Enable or disable INNODB_CMP_PER_INDEX_RESET plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-cmpmem

Enable or disable INNODB_CMPMEM plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-compression-algorithm

Compression algorithm used on page compression. One of: none, zlib, lz4, lzo, lzma, bzip2, or snappy

--innodb-compression-failure-threshold-pct

If the compression failure rate of a table is greater than this number more padding is added to the pages to reduce the failures. A value of zero implies no padding

--innodb-compression-pad-pct-max

Percentage of empty space on a data page that can be reserved to make the page compressible.

--innodb-data-home-dir

The common part for InnoDB table spaces.

--innodb-deadlock-report

How to report deadlocks (if innodb_deadlock_detect=ON).. One of: off, basic, full

--innodb-default-row-format

The default ROW FORMAT for all innodb tables created without explicit ROW_FORMAT. Possible values are REDUNDANT, COMPACT, and DYNAMIC. The ROW_FORMAT value COMPRESSED is not allowed. One of: redundant, compact, dynamic

--innodb-defragment-fill-factor

A number between [0.7, 1] that tells defragmentation how full it should fill a page. Default is 0.9. Number below 0.7 won't make much sense.This variable, together with innodb_defragment_fill_factor_n_recs, is introduced so defragmentation won't pack the page too full and cause page split on the next insert on every page. The variable indicating more defragmentation gain is the one effective.

--innodb-defragment-frequency

Do not defragment a single index more than this number of time per second.This controls the number of time defragmentation thread can request X_LOCK on an index. Defragmentation thread will check whether 1/defragment_frequency (s) has passed since it worked on this index last time, and put the index back to the queue if not enough time has passed. The actual frequency can only be lower than this given number.

--innodb-defragment-stats-accuracy

How many defragment stats changes there are before the stats are written to persistent storage. Set to 0 meaning disable defragment stats tracking.

--innodb-doublewrite

Enable InnoDB doublewrite buffer (enabled by default). Disable with --skip-innodb-doublewrite. (Defaults to on; use --skip-innodb-doublewrite to disable.)

--innodb-encrypt-tables

Enable encryption for tables. Don't forget to enable --innodb-encrypt-log too. One of: OFF, ON, FORCE

--innodb-encryption-rotate-key-age

Key rotation - re-encrypt in background all pages that were encrypted with a key that many (or more) versions behind. Value 0 indicates that key rotation is disabled.

--innodb-encryption-threads

Number of threads performing background key rotation

--innodb-fatal-semaphore-wait-threshold

Maximum number of seconds that semaphore times out in InnoDB.

--innodb-fill-factor

Percentage of B-tree page filled during bulk insert

--innodb-flush-log-at-trx-commit

Controls the durability/speed trade-off for commits. Set to 0 (write and flush redo log to disk only once per second), 1 (flush to disk at each commit), 2 (write to log at commit but flush to disk only once per second) or 3 (flush to disk at prepare and at commit, slower and usually redundant). 1 and 3 guarantees that after a crash, committed transactions will not be lost and will be consistent with the binlog and other transactional engines. 2 can get inconsistent and lose transactions if there is a power failure or kernel crash but not if mysqld crashes. 0 has no guarantees in case of crash. 0 and 2 can be faster than 1 or 3.

--innodb-flush-neighbors

Set to 0 (don't flush neighbors from buffer pool), 1 (flush contiguous neighbors from buffer pool) or 2 (flush neighbors from buffer pool), when flushing a block

--innodb-flushing-avg-loops

Number of iterations over which the background flushing is averaged.

--innodb-force-recovery

Helps to save your data in case the disk image of the database becomes corrupt. Value 5 can return bogus data, and 6 can permanently corrupt data.

--innodb-ft-being-deleted

Enable or disable INNODB_FT_BEING_DELETED plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-ft-config

Enable or disable INNODB_FT_CONFIG plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-ft-deleted

Enable or disable INNODB_FT_DELETED plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-ft-enable-stopword

Create FTS index with stopword. (Defaults to on; use --skip-innodb-ft-enable-stopword to disable.)

--innodb-ft-index-table

Enable or disable INNODB_FT_INDEX_TABLE plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-ft-min-token-size

InnoDB Fulltext search minimum token size in characters

--innodb-ft-result-cache-limit

InnoDB Fulltext search query result cache limit in bytes

--innodb-ft-sort-pll-degree

InnoDB Fulltext search parallel sort degree, will round up to nearest power of 2 number

--innodb-ft-user-stopword-table

User supplied stopword table name, effective in the session level.

--innodb-instant-alter-column-allowed

File format constraint for ALTER TABLE. One of: never, add_last, add_drop_reorder

--innodb-io-capacity-max

Limit to which innodb_io_capacity can be inflated.

--innodb-lock-waits

Enable or disable INNODB_LOCK_WAITS plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-log-buffer-size

The size of the buffer which InnoDB uses to write log to the log files on disk.

--innodb-log-group-home-dir

Path to InnoDB log files.

--innodb-lru-flush-size

How many pages to flush on LRU eviction

--innodb-max-dirty-pages-pct

Percentage of dirty pages allowed in bufferpool.

--innodb-max-purge-lag

Desired maximum length of the purge queue (0 = no limit)

--innodb-max-purge-lag-wait

Wait until History list length is below the specified limit

--innodb-metrics

Enable or disable INNODB_METRICS plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-monitor-enable

Turn on a monitor counter

--innodb-monitor-reset-all

Reset all values for a monitor counter

--innodb-old-blocks-time

Move blocks to the 'new' end of the buffer pool if the first access was at least this many milliseconds ago. The timeout is disabled if 0.

--innodb-open-files

How many files at the maximum InnoDB keeps open at the same time.

--innodb-page-size

Page size to use for all InnoDB tablespaces.

--innodb-print-all-deadlocks

Print all deadlocks to MariaDB error log (off by default)

--innodb-purge-rseg-truncate-frequency

Dictates rate at which UNDO records are purged. Value N means purge rollback segment(s) on every Nth iteration of purge invocation

--innodb-random-read-ahead

Whether to use read ahead for random access within an extent.

--innodb-read-io-threads

Number of background read I/O threads in InnoDB.

--innodb-read-only-compressed

Make ROW_FORMAT=COMPRESSED tables read-only

--innodb-sort-buffer-size

Memory buffer size for index creation

--innodb-stats-auto-recalc

InnoDB automatic recalculation of persistent statistics enabled for all tables unless overridden at table level (automatic recalculation is only done when InnoDB decides that the table has changed too much and needs a new statistics) (Defaults to on; use --skip-innodb-stats-auto-recalc to disable.)

--innodb-stats-method

Specifies how InnoDB index statistics collection code should treat NULLs. Possible values are NULLS_EQUAL (default), NULLS_UNEQUAL and NULLS_IGNORED. One of: nulls_equal, nulls_unequal, nulls_ignored

--innodb-stats-on-metadata

Enable statistics gathering for metadata commands such as SHOW TABLE STATUS for tables that use transient statistics (off by default)

--innodb-stats-persistent-sample-pages

The number of leaf index pages to sample when calculating persistent statistics (by ANALYZE, default 20)

--innodb-stats-transient-sample-pages

The number of leaf index pages to sample when calculating transient statistics (if persistent statistics are not used, default 8)

--innodb-status-output

Enable InnoDB monitor output to the error log.

--innodb-strict-mode

Use strict mode when evaluating create options. (Defaults to on; use --skip-innodb-strict-mode to disable.)

--innodb-sys-columns

Enable or disable INNODB_SYS_COLUMNS plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-sys-foreign

Enable or disable INNODB_SYS_FOREIGN plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-sys-indexes

Enable or disable INNODB_SYS_INDEXES plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-sys-tablespaces

Enable or disable INNODB_SYS_TABLESPACES plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-sys-virtual

Enable or disable INNODB_SYS_VIRTUAL plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-tablespaces-encryption

Enable or disable INNODB_TABLESPACES_ENCRYPTION plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--innodb-tmpdir

Directory for temporary non-tablespace files.

--innodb-undo-directory

Directory where undo tablespace files live, this path can be absolute.

--innodb-undo-tablespaces

Number of undo tablespaces to use.

--innodb-use-native-aio

Use native AIO if supported on this platform. (Defaults to on; use --skip-innodb-use-native-aio to disable.)

--interactive-timeout

The number of seconds the server waits for activity on an interactive connection before closing it

--join-buffer-space-limit

The limit of the space for all join buffers used by a query

--keep-files-on-create

Don't overwrite stale .MYD and .MYI even if no directory is specified

--key-cache-age-threshold

This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in key cache

--key-cache-division-limit

The minimum percentage of warm blocks in key cache

--key-cache-segments

The number of segments in a key cache

--large-pages

Enable support for large pages

--lc-messages-dir (-L)

Directory where error messages are

--local-infile

Enable LOAD DATA LOCAL INFILE (Defaults to on; use --skip-local-infile to disable.)

--lock-wait-timeout

Timeout in seconds to wait for a lock before returning an error.

--log-bin

Log update queries in binary format. Optional argument should be name for binary log. If not given 'datadir'/'log-basename'-bin or 'datadir'/mysql-bin will be used (the later if --log-basename is not specified). We strongly recommend to use either --log-basename or specify a filename to ensure that replication doesn't stop if the real hostname of the computer changes.

--log-bin-compress-min-len

Minimum length of sql statement(in statement mode) or record(in row mode)that can be compressed.

--log-bin-trust-function-creators

If set to FALSE (the default), then when --log-bin is used, creation of a stored function (or trigger) is allowed only to users having the SUPER privilege and only if this stored function (trigger) may not break binary logging. Note that if ALL connections to this server ALWAYS use row-based binary logging, the security issues do not exist and the binary logging cannot break, so you can safely set this to TRUE

--log-disabled-statements

Don't log certain types of statements to general log. Any combination of: slave, sp

--log-isam

Log all MyISAM changes to file.

--log-queries-not-using-indexes

Log queries that are executed without benefit of any index to the slow log if it is open. Same as log_slow_filter='not_using_index'

--log-slave-updates

Tells the slave to log the updates from the slave thread to the binary log. You will need to turn it on if you plan to daisy-chain the slaves.

--log-slow-disabled-statements

Don't log certain types of statements to slow log. Any combination of: admin, call, slave, sp

--log-slow-rate-limit

Write to slow log every #th slow query. Set to 1 to log everything. Increase it to reduce the size of the slow or the performance impact of slow logging

--log-slow-verbosity

Verbosity level for the slow log. Any combination of: innodb, query_plan, explain, engine, full

--log-tc-size

Size of transaction coordinator log.

--long-query-time

Log all queries that have taken more than long_query_time seconds to execute to the slow query log file. The argument will be treated as a decimal value with microsecond precision

--lower-case-table-names

If set to 1 table names are stored in lowercase on disk and table names will be case-insensitive. Should be set to 2 if you are using a case insensitive file system

--master-retry-count

The number of tries the slave will make to connect to the master before giving up.

--max-allowed-packet

Max packet length to send to or receive from the server

--max-binlog-size

Binary log will be rotated automatically when the size exceeds this value.

--max-connect-errors

If there is more than this number of interrupted connections from a host this host will be blocked from further connections

--max-delayed-threads

Don't start more than this number of threads to handle INSERT DELAYED statements. If set to zero INSERT DELAYED will be not used

--max-error-count

Max number of errors/warnings to store for a statement

--max-join-size

Joins that are probably going to read more than max_join_size records return an error

--max-password-errors

If there is more than this number of failed connect attempts due to invalid password, user will be blocked from further connections until FLUSH_PRIVILEGES.

--max-recursive-iterations

Maximum number of iterations when executing recursive queries

--max-rowid-filter-size

The maximum size of the container of a rowid filter

--max-session-mem-used

Amount of memory a single user session is allowed to allocate. This limits the value of the session variable MEM_USED

--max-sp-recursion-depth

Maximum stored procedure recursion depth

--max-tmp-tables

Unused, will be removed.

--max-write-lock-count

After this many write locks, allow some read locks to run in between

--metadata-lock-info

Enable or disable METADATA_LOCK_INFO plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--metadata-locks-hash-instances

Unused

--mrr-buffer-size

Size of buffer to use when using MRR with range access

--myisam-data-pointer-size

Default pointer size to be used for MyISAM tables

--myisam-mmap-size

Restricts the total memory used for memory mapping of MySQL tables

--myisam-repair-threads

If larger than 1, when repairing a MyISAM table all indexes will be created in parallel, with one thread per index. The value of 1 disables parallel repair

--myisam-stats-method

Specifies how MyISAM index statistics collection code should treat NULLs. Possible values of name are NULLS_UNEQUAL (default behavior for 4.1 and later), NULLS_EQUAL (emulate 4.0 behavior), and NULLS_IGNORED

--mysql56-temporal-format

Use MySQL-5.6 (instead of MariaDB-5.3) format for TIME, DATETIME, TIMESTAMP columns. (Defaults to on; use --skip-mysql56-temporal-format to disable.)

--net-read-timeout

Number of seconds to wait for more data from a connection before aborting the read

--net-write-timeout

Number of seconds to wait for a block to be written to a connection before aborting the write

--old

Use compatible behavior from previous MariaDB version. See also --old-mode

--old-mode

Used to emulate old behavior from earlier MariaDB or MySQL versions. Any combination of: NO_DUP_KEY_WARNINGS_WITH_IGNORE, NO_PROGRESS_INFO, ZERO_DATE_TIME_CAST, UTF8_IS_UTF8MB3

--old-style-user-limits

Enable old-style user limits (before 5.0.3, user resources were counted per each user+host vs. per account).

--optimizer-max-sel-arg-weight

The maximum weight of the SEL_ARG graph. Set to 0 for no limit

--optimizer-search-depth

Maximum depth of search performed by the query optimizer. Values larger than the number of relations in a query result in better query plans, but take longer to compile a query. Values smaller than the number of tables in a relation result in faster optimization, but may produce very bad query plans. If set to 0, the system will automatically pick a reasonable value.

--optimizer-switch

Fine-tune the optimizer behavior. Takes a comma-separated list of option=value pairs, where value is on, off, or default, and options are: index_merge, index_merge_union, index_merge_sort_union, index_merge_intersection, index_merge_sort_intersection, engine_condition_pushdown, index_condition_pushdown, derived_merge, derived_with_keys, firstmatch, loosescan, materialization, in_to_exists, semijoin, partial_match_rowid_merge, partial_match_table_scan, subquery_cache, mrr, mrr_cost_based, mrr_sort_keys, outer_join_with_cache, semijoin_with_cache, join_cache_incremental, join_cache_hashed, join_cache_bka, optimize_join_buffer_size, table_elimination, extended_keys, exists_to_in, orderby_uses_equalities, condition_pushdown_for_derived, split_materialized, condition_pushdown_for_subquery, rowid_filter, condition_pushdown_from_having, not_null_range_scan, hash_join_cardinality, sargable_casefold

--optimizer-trace-max-mem-size

Maximum allowed size of an optimizer trace

--pam

Enable or disable pam plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--pam-winbind-workaround

Compare usernames case insensitively to work around pam_winbind unconditional username lowercasing

--password-reuse-check

Enable or disable password_reuse_check plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--performance-schema

Enable the performance schema.

--performance-schema-consumer-events-stages-current

Default startup value for the events_stages_current consumer.

--performance-schema-consumer-events-stages-history-long

Default startup value for the events_stages_history_long consumer.

--performance-schema-consumer-events-statements-history

Default startup value for the events_statements_history consumer.

--performance-schema-consumer-events-transactions-current

Default startup value for the events_transactions_current consumer.

--performance-schema-consumer-events-transactions-history-long

Default startup value for the events_transactions_history_long consumer.

--performance-schema-consumer-events-waits-history

Default startup value for the events_waits_history consumer.

--performance-schema-consumer-global-instrumentation

Default startup value for the global_instrumentation consumer. (Defaults to on; use --skip-performance-schema-consumer-global-instrumentation to disable.)

--performance-schema-consumer-thread-instrumentation

Default startup value for the thread_instrumentation consumer. (Defaults to on; use --skip-performance-schema-consumer-thread-instrumentation to disable.)

--performance-schema-events-stages-history-long-size

Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to disable, -1 for automated sizing.

--performance-schema-events-statements-history-long-size

Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing.

--performance-schema-events-transactions-history-long-size

Number of rows in EVENTS_TRANSACTIONS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing.

--performance-schema-events-waits-history-long-size

Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing.

--performance-schema-hosts-size

Maximum number of instrumented hosts. Use 0 to disable, -1 for automated sizing.

--performance-schema-max-cond-classes

Maximum number of condition instruments.

--performance-schema-max-digest-length

Maximum length considered for digest text, when stored in performance_schema tables.

--performance-schema-max-file-handles

Maximum number of opened instrumented files.

--performance-schema-max-index-stat

Maximum number of index statistics for instrumented tables. Use 0 to disable, -1 for automated scaling.

--performance-schema-max-metadata-locks

Maximum number of metadata locks. Use 0 to disable, -1 for automated scaling.

--performance-schema-max-mutex-instances

Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing.

--performance-schema-max-program-instances

Maximum number of instrumented programs. Use 0 to disable, -1 for automated scaling.

--performance-schema-max-rwlock-instances

Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing.

--performance-schema-max-socket-instances

Maximum number of opened instrumented sockets. Use 0 to disable, -1 for automated sizing.

--performance-schema-max-stage-classes

Maximum number of stage instruments.

--performance-schema-max-statement-stack

Number of rows per thread in EVENTS_STATEMENTS_CURRENT.

--performance-schema-max-table-instances

Maximum number of instrumented tables. Use 0 to disable, -1 for automated sizing.

--performance-schema-max-thread-classes

Maximum number of thread instruments.

--performance-schema-session-connect-attrs-size

Size of session attribute string buffer per thread. Use 0 to disable, -1 for automated sizing.

--performance-schema-setup-objects-size

Maximum number of rows in SETUP_OBJECTS.

--pid-file

Pid file used by safe_mysqld

--plugin-load

Semicolon-separated list of plugins to load, where each plugin is specified as ether a plugin_name=library_file pair or only a library_file. If the latter case, all plugins from a given library_file will be loaded.

--plugin-maturity

The lowest desirable plugin maturity. Plugins less mature than that will not be installed or loaded. One of: unknown, experimental, alpha, beta, gamma, stable

--port-open-timeout

Maximum time in seconds to wait for the port to become free. (Default: No wait).

--print-defaults

Print the program argument list and exit.

--progress-report-time

Seconds between sending progress reports to the client for time-consuming statements. Set to 0 to disable progress reporting.

--query-alloc-block-size

Allocation block size for query parsing and execution

--query-cache-min-res-unit

The minimum size for blocks allocated by the query cache

--query-cache-strip-comments

Strip all comments from a query before storing it in the query cache

--query-cache-wlock-invalidate

Invalidate queries in query cache on LOCK for write

--query-response-time

Enable or disable QUERY_RESPONSE_TIME plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--query-response-time-range-base

Select base of log for query_response_time ranges. WARNING: variable change affect only after flush

--range-alloc-block-size

Allocation block size for storing ranges during optimization

--read-buffer-size

Each thread that does a sequential scan allocates a buffer of this size for each table it scans. If you do many sequential scans, you may want to increase this value

--read-rnd-buffer-size

When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks

--relay-log-index

The location and name to use for the file that keeps a list of the last relay logs

--relay-log-purge

if disabled - do not purge relay logs. if enabled - purge them as soon as they are no more needed. (Defaults to on; use --skip-relay-log-purge to disable.)

--relay-log-space-limit

Maximum space to use for all relay logs

--replicate-do-db

Tells the slave thread to restrict replication to the specified database. To specify more than one database, use the directive multiple times, once for each database. Note that this will only work if you do not use cross-database queries such as UPDATE some_db.some_table SET foo='bar' while having selected a different or no database. If you need cross database updates to work, make sure you have 3.23.28 or later, and use replicate-wild-do-table=db_name.%.

--replicate-events-marked-for-skip

Whether the slave should replicate events that were created with @@skip_replication=1 on the master. Default REPLICATE (no events are skipped). Other values are FILTER_ON_SLAVE (events will be sent by the master but ignored by the slave) and FILTER_ON_MASTER (events marked with @@skip_replication=1 will be filtered on the master and never be sent to the slave).

--replicate-ignore-table

Tells the slave thread to not replicate to the specified table. To specify more than one table to ignore, use the directive multiple times, once for each table. This will work for cross-database updates, in contrast to replicate-ignore-db.

--replicate-same-server-id

In replication, if set to 1, do not skip events having our server id. Default value is 0 (to break infinite loops in circular replication). Can't be set to 1 if --log-slave-updates is used.

--replicate-wild-ignore-table

Tells the slave thread to not replicate to the tables that match the given wildcard pattern. To specify more than one table to ignore, use the directive multiple times, once for each table. This will work for cross-database updates. Example: replicate-wild-ignore-table=foo%.bar% will not do updates to tables in databases that start with foo and whose table names start with bar.

--report-password

The account password of the slave to be reported to the master during slave registration

--report-user

The account user name of the slave to be reported to the master during slave registration

--rocksdb

Enable or disable ROCKSDB plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--rocksdb-advise-random-on-open

DBOptions::advise_random_on_open for RocksDB (Defaults to on; use --skip-rocksdb-advise-random-on-open to disable.)

--rocksdb-allow-mmap-reads

DBOptions::allow_mmap_reads for RocksDB

--rocksdb-allow-to-start-after-corruption

Allow server still to start successfully even if RocksDB corruption is detected.

--rocksdb-block-cache-size

block_cache size for RocksDB

--rocksdb-block-size

BlockBasedTableOptions::block_size for RocksDB

--rocksdb-bulk-load

Use bulk-load mode for inserts. This disables unique_checks and enables rocksdb_commit_in_the_middle.

--rocksdb-bulk-load-allow-unsorted

Allow unsorted input during bulk-load. Can be changed only when bulk load is disabled.

--rocksdb-bytes-per-sync

DBOptions::bytes_per_sync for RocksDB

--rocksdb-cache-high-pri-pool-ratio

Specify the size of block cache high-pri pool

--rocksdb-cache-index-and-filter-with-high-priority

cache_index_and_filter_blocks_with_high_priority for RocksDB (Defaults to on; use --skip-rocksdb-cache-index-and-filter-with-high-priority to disable.)

--rocksdb-cfstats

Enable or disable ROCKSDB_CFSTATS plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--rocksdb-collect-sst-properties

Enables collecting SST file properties on each flush (Defaults to on; use --skip-rocksdb-collect-sst-properties to disable.)

--rocksdb-commit-time-batch-for-recovery

TransactionOptions::commit_time_batch_for_recovery for RocksDB (Defaults to on; use --skip-rocksdb-commit-time-batch-for-recovery to disable.)

--rocksdb-compaction-readahead-size

DBOptions::compaction_readahead_size for RocksDB

--rocksdb-compaction-sequential-deletes-count-sd

Counting SingleDelete as rocksdb_compaction_sequential_deletes

--rocksdb-compaction-sequential-deletes-window

Size of the window for counting rocksdb_compaction_sequential_deletes

--rocksdb-create-checkpoint

Checkpoint directory

--rocksdb-create-missing-column-families

DBOptions::create_missing_column_families for RocksDB

--rocksdb-db-write-buffer-size

DBOptions::db_write_buffer_size for RocksDB

--rocksdb-ddl

Enable or disable ROCKSDB_DDL plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--rocksdb-deadlock-detect

Enables deadlock detection

--rocksdb-debug-manual-compaction-delay

For debugging purposes only. Sleeping specified seconds for simulating long running compactions.

--rocksdb-debug-optimizer-no-zero-cardinality

In case if cardinality is zero, overrides it with some value (Defaults to on; use --skip-rocksdb-debug-optimizer-no-zero-cardinality to disable.)

--rocksdb-debug-ttl-read-filter-ts

For debugging purposes only. Overrides the TTL read filtering time to time + debug_ttl_read_filter_ts. A value of 0 denotes that the variable is not set. This variable is a no-op in non-debug builds.

--rocksdb-debug-ttl-snapshot-ts

For debugging purposes only. Sets the snapshot during compaction to now() + debug_set_ttl_snapshot_ts. The value can be +/- to simulate a snapshot in the past vs a snapshot created in the 'future'. A value of 0 denotes that the variable is not set. This variable is a no-op in non-debug builds.

--rocksdb-delayed-write-rate

DBOptions::delayed_write_rate

--rocksdb-delete-obsolete-files-period-micros

DBOptions::delete_obsolete_files_period_micros for RocksDB

--rocksdb-enable-bulk-load-api

Enables using SstFileWriter for bulk loading (Defaults to on; use --skip-rocksdb-enable-bulk-load-api to disable.)

--rocksdb-enable-thread-tracking

DBOptions::enable_thread_tracking for RocksDB (Defaults to on; use --skip-rocksdb-enable-thread-tracking to disable.)

--rocksdb-enable-ttl-read-filtering

For tables with TTL, expired records are skipped/filtered out during processing and in query results. Disabling this will allow these records to be seen, but as a result rows may disappear in the middle of transactions as they are dropped during compaction. Use with caution. (Defaults to on; use --skip-rocksdb-enable-ttl-read-filtering to disable.)

--rocksdb-error-if-exists

DBOptions::error_if_exists for RocksDB

--rocksdb-flush-log-at-trx-commit

Sync on transaction commit. Similar to innodb_flush_log_at_trx_commit. 1: sync on commit, 0,2: not sync on commit

--rocksdb-force-compute-memtable-stats-cachetime

Time in usecs to cache memtable estimates

--rocksdb-force-flush-memtable-now

Forces memstore flush which may block all write requests so be careful

--rocksdb-git-hash

Git revision of the RocksDB library used by MyRocks

--rocksdb-hash-index-allow-collision

BlockBasedTableOptions::hash_index_allow_collision for RocksDB (Defaults to on; use --skip-rocksdb-hash-index-allow-collision to disable.)

--rocksdb-ignore-unknown-options

Enable ignoring unknown options passed to RocksDB (Defaults to on; use --skip-rocksdb-ignore-unknown-options to disable.)

--rocksdb-index-type

BlockBasedTableOptions::index_type for RocksDB. One of: kBinarySearch, kHashSearch

--rocksdb-io-write-timeout

Timeout for experimental I/O watchdog.

--rocksdb-keep-log-file-num

DBOptions::keep_log_file_num for RocksDB

--rocksdb-lock-scanned-rows

Take and hold locks on rows that are scanned but not updated

--rocksdb-locks

Enable or disable ROCKSDB_LOCKS plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--rocksdb-manifest-preallocation-size

DBOptions::manifest_preallocation_size for RocksDB

--rocksdb-manual-wal-flush

DBOptions::manual_wal_flush for RocksDB (Defaults to on; use --skip-rocksdb-manual-wal-flush to disable.)

--rocksdb-max-background-jobs

DBOptions::max_background_jobs for RocksDB

--rocksdb-max-log-file-size

DBOptions::max_log_file_size for RocksDB

--rocksdb-max-manual-compactions

Maximum number of pending + ongoing number of manual compactions.

--rocksdb-max-row-locks

Maximum number of locks a transaction can have

--rocksdb-max-total-wal-size

DBOptions::max_total_wal_size for RocksDB

--rocksdb-merge-combine-read-size

Size that we have to work with during combine (reading from disk) phase of external sort during fast index creation.

--rocksdb-new-table-reader-for-compaction-inputs

DBOptions::new_table_reader_for_compaction_inputs for RocksDB

--rocksdb-override-cf-options

option overrides per cf for RocksDB

--rocksdb-pause-background-work

Disable all rocksdb background operations

--rocksdb-perf-context-global

Enable or disable ROCKSDB_PERF_CONTEXT_GLOBAL plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--rocksdb-persistent-cache-path

Path for BlockBasedTableOptions::persistent_cache for RocksDB

--rocksdb-pin-l0-filter-and-index-blocks-in-cache

pin_l0_filter_and_index_blocks_in_cache for RocksDB (Defaults to on; use --skip-rocksdb-pin-l0-filter-and-index-blocks-in-cache to disable.)

--rocksdb-rate-limiter-bytes-per-sec

DBOptions::rate_limiter bytes_per_sec for RocksDB

--rocksdb-remove-mariabackup-checkpoint

Remove mariabackup checkpoint

--rocksdb-rollback-on-timeout

Whether to roll back the complete transaction or a single statement on lock wait timeout (a single statement by default)

--rocksdb-signal-drop-index-thread

Wake up drop index thread

--rocksdb-skip-bloom-filter-on-read

Skip using bloom filter for reads

--rocksdb-skip-unique-check-tables

Skip unique constraint checking for the specified tables

--rocksdb-sst-props

Enable or disable ROCKSDB_SST_PROPS plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--rocksdb-stats-level

Statistics Level for RocksDB. Default is 0 (kExceptHistogramOrTimers)

--rocksdb-store-row-debug-checksums

Include checksums when writing index/table records

--rocksdb-strict-collation-exceptions

List of tables (using regex) that are excluded from the case sensitive collation enforcement

--rocksdb-table-stats-sampling-pct

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.

--rocksdb-trace-sst-api

Generate trace output in the log for each call to the SstFileWriter

--rocksdb-two-write-queues

DBOptions::two_write_queues for RocksDB (Defaults to on; use --skip-rocksdb-two-write-queues to disable.)

--rocksdb-update-cf-options

Option updates per column family for RocksDB

--rocksdb-use-clock-cache

Use ClockCache instead of default LRUCache for RocksDB

--rocksdb-use-direct-reads

DBOptions::use_direct_reads for RocksDB

--rocksdb-validate-tables

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

--rocksdb-wal-bytes-per-sync

DBOptions::wal_bytes_per_sync for RocksDB

--rocksdb-wal-recovery-mode

DBOptions::wal_recovery_mode for RocksDB. Default is kAbsoluteConsistency

--rocksdb-wal-ttl-seconds

DBOptions::WAL_ttl_seconds for RocksDB

--rocksdb-write-batch-max-bytes

Maximum size of write batch in bytes. 0 means no limit.

--rocksdb-write-ignore-missing-column-families

WriteOptions::ignore_missing_column_families for RocksDB

--rowid-merge-buff-size

The size of the buffers used [NOT] IN evaluation via partial matching

--rpl-semi-sync-master-timeout

The timeout value (in ms) for semi-synchronous replication in the master

--rpl-semi-sync-master-wait-no-slave

Wait until timeout when no semi-synchronous replication slave available (enabled by default). (Defaults to on; use --skip-rpl-semi-sync-master-wait-no-slave to disable.)

--rpl-semi-sync-slave-delay-master

Only write master info file when ack is needed.

--rpl-semi-sync-slave-kill-conn-timeout

Timeout for the mysql connection used to kill the slave io_thread's connection on master. This timeout comes into play when stop slave is executed.

--s3

Enable or disable S3 plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--s3-block-size

Block size for S3

--s3-debug

Generates trace file from libmarias3 on stderr for debugging

--s3-pagecache-age-threshold

This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in the page cache.

--s3-pagecache-division-limit

The minimum percentage of warm blocks in key cache

--s3-port

Port number to connect to (0 means use default)

--s3-region

AWS region

--s3-secret-key

AWS secret key

--s3-use-http

If true, force use of HTTP protocol

--safe-user-create

Don't allow new user creation by the user who has no write privileges to the mysql.user table.

--secure-file-priv

Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within specified directory

--sequence

Enable or disable SEQUENCE plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--server-audit-file-rotate-now

Force log rotation now.

--server-audit-file-rotations

Number of rotations before log is removed.

--server-audit-logging

Turn on/off the logging.

--server-audit-output-type

Desired output type. Possible values - 'syslog', 'file' or 'null' as no output.

--server-audit-reload-filters

Reload filter definitions from tables.

--server-audit-syslog-ident

The SYSLOG identifier - the beginning of each SYSLOG record.

--server-audit-syslog-priority

The 'priority' parameter of the SYSLOG record. The default is LOG_INFO.. One of: LOG_EMERG, LOG_ALERT, LOG_CRIT, LOG_ERR, LOG_WARNING, LOG_NOTICE, LOG_INFO, LOG_DEBUG

--session-track-schema

Track changes to the default schema. (Defaults to on; use --skip-session-track-schema to disable.)

--session-track-system-variables

Track changes in registered system variables.

--show-slave-auth-info

Show user and password in SHOW SLAVE HOSTS on this master.

--silent-startup

Don't print [Note] to the error log during startup.

--simple-password-check-digits

Minimal required number of digits

--simple-password-check-minimal-length

Minimal required password length

--skip-grant-tables

Start without grant tables. This gives all users FULL ACCESS to all tables.

--skip-name-resolve

Don't resolve hostnames. All hostnames are IP's or 'localhost'.

--skip-show-database

Don't allow 'SHOW DATABASE' commands

--slave-compressed-protocol

Use compression on master/slave protocol

--slave-domain-parallel-threads

Maximum number of parallel threads to use on slave for events in a single replication domain. When using multiple domains, this can be used to limit a single domain from grabbing all threads and thus stalling other domains. The default of 0 means to allow a domain to grab as many threads as it wants, up to the value of slave_parallel_threads.

--slave-load-tmpdir

The location where the slave should put its temporary files when replicating a LOAD DATA INFILE command

--slave-max-statement-time

A query that has taken more than slave_max_statement_time seconds to run on the slave will be aborted. The argument will be treated as a decimal value with microsecond precision. A value of 0 (default) means no timeout

--slave-parallel-max-queued

Limit on how much memory SQL threads should use per parallel replication thread when reading ahead in the relay log looking for opportunities for parallel replication. Only used when --slave-parallel-threads > 0.

--slave-parallel-threads

If non-zero, number of threads to spawn to apply in parallel events on the slave that were group-committed on the master or were logged with GTID in different replication domains. Note that these threads are in addition to the IO and SQL threads, which are always created by a replication slave

--slave-run-triggers-for-rbr

Modes for how triggers in row-base replication on slave side will be executed. Legal values are NO (default), YES, LOGGING and ENFORCE. NO means that trigger for RBR will not be running on slave. YES and LOGGING means that triggers will be running on slave, if there was not triggers running on the master for the statement. LOGGING also means results of that the executed triggers work will be written to the binlog. ENFORCE means that triggers will always be run on the slave, even if there are triggers on the master. ENFORCE implies LOGGING.

--slave-sql-verify-checksum

Force checksum verification of replication events after reading them from relay log. Note: Events are always checksum-verified by slave on receiving them from the network before writing them to the relay log (Defaults to on; use --skip-slave-sql-verify-checksum to disable.)

--slave-transaction-retry-errors

Tells the slave thread to retry transaction for replication when a query event returns an error from the provided list. Deadlock error, elapsed lock wait timeout, net read error, net read timeout, net write error, net write timeout, connect error and 2 types of lost connection error are automatically added to this list

--slave-type-conversions

Configures how data type conversions are handled when row-based binary log events are applied. When set to the empty string, data types must match exactly, and no conversions are allowed.

--slow-query-log

Log slow queries to a table or log file. Defaults logging to a file 'hostname'-slow.log or a table mysql.slow_log if --log-output=TABLE is used. Must be enabled to activate other slow log options.

--socket

Socket file to use for connection

--spider

Enable or disable SPIDER plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--spider-auto-increment-mode

Mode of auto increment.

--spider-bgs-mode

Mode of background search

--spider-bka-engine

Temporary table's engine for BKA

--spider-bka-table-name-type

The type of temporary table name for bka

--spider-buffer-size

Buffer size

--spider-bulk-update-mode

The mode of bulk updating and deleting

--spider-casual-read

Read casually if it is possible

--spider-conn-recycle-strict

Strict connection recycle

--spider-connect-error-interval

Return same error code until interval passes if connection is failed

--spider-connect-retry-count

Connect retry count

--spider-connect-timeout

Wait timeout of connecting to remote server

--spider-crd-interval

Interval of cardinality confirmation.(second)

--spider-crd-sync

Cardinality synchronization in partitioned table.

--spider-crd-weight

Weight coefficient to calculate effectiveness of index from cardinality of column.

--spider-direct-aggregate

Pushdown aggregation functions if possible (Defaults to on; use --skip-spider-direct-aggregate to disable.)

--spider-direct-order-limit

Send 'ORDER BY' and 'LIMIT' to remote server directly

--spider-error-read-mode

Read error mode if error

--spider-first-read

Number of first read records

--spider-general-log

Log query to remote server in general log

--spider-init-sql-alloc-size

Initial sql string alloc size

--spider-internal-offset

Internal offset

--spider-internal-optimize-local

Execute optimize to remote server with local

--spider-internal-unlock

Unlock tables for using connections in sql

--spider-internal-xa-id-type

The type of internal_xa id

--spider-load-crd-at-startup

Load crd from system table at startup

--spider-local-lock-table

Remote server transmission when lock tables is executed at local

--spider-log-result-error-with-sql

Log sql at logging result errors

--spider-low-mem-read

Use low memory mode when SQL(SELECT) internally issued to a remote server is executed and get a result list

--spider-max-order

Max columns for order by

--spider-net-read-timeout

Wait timeout of receiving data from remote server

--spider-ping-interval-at-trx-start

Ping interval at transaction start

--spider-quick-page-byte

The limitation of memory size in a page when acquisition one by one

--spider-read-only-mode

Read only

--spider-remote-autocommit

Set autocommit mode at connecting for improvement performance of connection if you know

--spider-remote-sql-log-off

Set SQL_LOG_OFF mode on connecting for improved performance of connection, if you know

--spider-remote-trx-isolation

Set transaction isolation level at connecting for improvement performance of connection if you know

--spider-reset-sql-alloc

Reset sql string alloc after execute

--spider-second-read

Number of second read records

--spider-selupd-lock-mode

Lock for select with update

--spider-semi-split-read-limit

The limit value for semi_split_read

--spider-semi-table-lock-connection

Use different connection if semi_table_lock is enabled

--spider-semi-trx-isolation

Transaction isolation level during execute a sql

--spider-skip-parallel-search

Skip parallel search by specific conditions

--spider-split-read

Number of rows at a select

--spider-store-last-sts

Store last sts result into system table

--spider-sts-bg-mode

Mode of table state confirmation at background.

--spider-sts-mode

Mode of table state confirmation.

--spider-support-xa

XA support (Defaults to on; use --skip-spider-support-xa to disable.)

--spider-sync-sql-mode

Sync sql_mode (Defaults to on; use --skip-spider-sync-sql-mode to disable.)

--spider-table-crd-thread-count

Static thread count of table crd

--spider-table-sts-thread-count

Static thread count of table sts

--spider-udf-ct-bulk-insert-rows

The number of rows inserted with bulk insert of one time at coping

--spider-udf-ds-table-loop-mode

Table loop mode if the number of tables in table list are less than the number of result sets

--spider-udf-table-lock-mutex-count

Mutex count of table lock for Spider UDFs

--spider-use-all-conns-snapshot

When start trx with snapshot, it send to all connections

--spider-use-consistent-snapshot

Use start transaction with consistent snapshot

--spider-use-flash-logs

Execute flush logs to remote server

--spider-use-pushdown-udf

Remote server transmission existence when UDF is used at condition and "engine_condition_pushdown=1"

--spider-use-table-charset

Use table charset for remote access

--spider-wrapper-protocols

Enable or disable SPIDER_WRAPPER_PROTOCOLS plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--sql-mode

Sets the sql mode. Any combination of: REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, IGNORE_BAD_TABLE_OPTIONS, ONLY_FULL_GROUP_BY, NO_UNSIGNED_SUBTRACTION, NO_DIR_IN_CREATE, POSTGRESQL, ORACLE, MSSQL, DB2, MAXDB, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS, MYSQL323, MYSQL40, ANSI, NO_AUTO_VALUE_ON_ZERO, NO_BACKSLASH_ESCAPES, STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ALLOW_INVALID_DATES, ERROR_FOR_DIVISION_BY_ZERO, TRADITIONAL, NO_AUTO_CREATE_USER, HIGH_NOT_PRECEDENCE, NO_ENGINE_SUBSTITUTION, PAD_CHAR_TO_FULL_LENGTH, EMPTY_STRING_IS_NULL, SIMULTANEOUS_ASSIGNMENT, TIME_ROUND_FRACTIONAL, EXTENDED_ALIASES

--ssl

Enable SSL for connection (automatically enabled if an ssl option is used).

--ssl-capath

CA directory (check OpenSSL docs, implies --ssl)

--ssl-cipher

SSL cipher to use (implies --ssl)

--ssl-crlpath

CRL directory (check OpenSSL docs, implies --ssl)

--stack-trace

Print a symbolic stack trace on failure (Defaults to on; use --skip-stack-trace to disable.)

--stored-program-cache

The soft upper limit for number of cached stored routines for one connection.

--symbolic-links (-s)

Enable symbolic link support. (Defaults to on; use --skip-symbolic-links to disable.)

--sync-frm

Sync .frm files to disk on creation (Defaults to on; use --skip-sync-frm to disable.)

--sync-relay-log

Synchronously flush relay log to disk after every #th event. Use 0 to disable synchronous flushing

--sysdate-is-now

Non-default option to alias SYSDATE() to NOW() to make it safe-replicable. Since 5.0, SYSDATE() returns a `dynamic' value different for different invocations, even within the same statement.

--table-cache

Deprecated; use --table-open-cache instead.

--table-open-cache

The number of cached open tables

--tc-heuristic-recover

Decision to use in heuristic recover process. One of: OFF, COMMIT, ROLLBACK

--tcp-keepalive-probes

The number of unacknowledged probes to send before considering the connection dead and notifying the application layer.If set to 0, system dependent default is used. (Automatically configured unless set explicitly)

--tcp-nodelay

Set option TCP_NODELAY (disable Nagle's algorithm) on socket (Defaults to on; use --skip-tcp-nodelay to disable.)

--thread-cache-size

Controls how many threads are cached for use by new client connections. Threads are freed after 5 minutes of idle time.

--thread-pool-connections

Enable or disable THREAD_POOL_CONNECTIONS plugin. One of: ON, OFF, FORCE (don't start if the plugin fails to load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not be uninstalled).

--thread-pool-exact-stats

If set to 1, provides better statistics in information_schema threadpool tables

--thread-pool-idle-timeout

Timeout in seconds for an idle thread in the thread pool.Worker thread will be shut down after timeout

--thread-pool-oversubscribe

How many additional active worker threads in a group are allowed.

--thread-pool-priority

Threadpool priority. High priority connections usually start executing earlier than low priority.If priority set to 'auto', the the actual priority(low or high) is determined based on whether or not connection is inside transaction.