# mariadbd Options This page lists all of the options for `mariadbd` (called mysqld before [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105)), ordered by topic. For a full alphabetical list of all mariadbd options, as well as server and status variables, see [Full list of MariaDB options, system and status variables](https://mariadb.com/docs/server/server-management/variables-and-modes/full-list-of-mariadb-options-system-and-status-variables). In many cases, the entry here is a summary, and links to the full description. By convention, [server variables](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables) have usually been specified with an underscore in the configuration files, and a dash on the command line. You can however specify underscores as dashes - they are interchangeable. See [Configuring MariaDB with Option Files](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files) for which files and groups mariadbd reads for it's default options. {% hint style="info" %} Previously, the client used to be called `mysqld`, and can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows. {% endhint %} ## Option Prefixes #### `--autoset-*` * Description: Sets the option value automatically. Only supported for certain options. #### `--disable-*` * Description: For all boolean options, disables the setting (equivalent to setting it to `0`). Same as `--skip`. #### `--enable-*` * Description: For all boolean options, enables the setting (equivalent to setting it to `1`). #### `--loose-*` * Description: Don't produce an error if the option doesn't exist. #### `--maximum-*` * Description: Sets the maximum value for the option. #### `--skip-*` * Description: For all boolean options, disables the setting (equivalent to setting it to `0`). Same as `--disable`. ## Option File Options #### `--defaults-extra-file` * Command line: `--defaults-extra-file=name` * Description: Read this extra option file after all other option files are read. * See [Configuring MariaDB with Option Files](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files). #### `--defaults-file` * Command line: `--defaults-file=name` * Description: Only read options from the given option file. * See [Configuring MariaDB with Option Files](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files). #### `--defaults-group-suffix` * Command line: `--defaults-group-suffix=name` * Description: In addition to the default option groups, also read option groups with the given suffix. * See [Configuring MariaDB with Option Files](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files). #### `--no-defaults` * Command line: `--no-defaults` * Description: Don't read options from any option file. * See [Configuring MariaDB with Option Files](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files). #### `--print-defaults` * Command line: `--print-defaults` * Description: Read options from option files, print all option values, and then exit the program. * See [Configuring MariaDB with Option Files](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files). ## Compatibility Options The following options have been added to MariaDB to make it more compliant with\ other MariaDB and MySQL versions. Options that are also system variables are listed after: #### `-a, --ansi` * Description: Use ANSI SQL syntax instead of MariaDB syntax. This mode will also set [transaction isolation level](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-transaction) [serializable](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-transaction#serializable). #### `--new` * Description: Use new functionality that will exist in next version of MariaDB. This function exists to make it easier to prepare for an upgrade. #### `--old-style-user-limits` * Description: Enable old-style user limits (before MySQL 5.0.3, user resources were counted per each user+host vs. per account). #### `--safe-mode` * Description: Disable some potential unsafe optimizations. For 5.2, [INSERT DELAYED](https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert-delayed) is disabled, [myisam\_recover\_options](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_recover_options) is set to DEFAULT (automatically recover crashed MyISAM files) and the [query cache](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/query-cache) is disabled. For [Aria](https://mariadb.com/docs/server/server-usage/storage-engines/aria) tables, disable bulk insert optimization to enable one to use [aria\_read\_log](https://mariadb.com/docs/server/clients-and-utilities/aria-clients-and-utilities/aria_read_log) to recover tables even if tables are deleted (good for testing recovery). #### `--skip-new` * Description: Disables [--new](#-new). ### Compatibility Options and System Variables * [--new-mode](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#new_mode) * [--old](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#old) * [--old-alter-table](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#old_alter_table) * [--old-mode](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#old_mode) * [--old-passwords](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#old_passwords) * [--show-old-temporals](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#show_old_temporals) ## Locale Options Options that are also system variables are listed after: #### `--character-set-client-handshake` * Command line: `--character-set-client-handshake` * Description: Don't ignore client side character set value sent during handshake. `--skip-character-set-client-handshake` will ignore the client value and use the default server value. #### `--default-character-set` * Command line: `--default-character-set=name` * Description: Still available as an option for setting the default character set for clients and their connections, it was deprecated and removed in [MariaDB 10.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/what-is-mariadb-102) as a server option. Use [character-set-server](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_server) instead. #### `--language` * Description: This option can be used to set the server's language for error messages. This option can be specified either as a language name or as the path to the directory storing the language's [error message file](https://mariadb.com/docs/server/server-monitoring-logs/error-log#error-messages-file). See [Server Locales](https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/internationalization-and-localization/server-locale) for a list of supported locales and their associated languages. * This option is deprecated. Use the [lc\_messages](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#lc_messages) and [lc\_messages\_dir](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#lc_messages_dir) system variables instead. * See [Setting the Language for Error Messages](https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/internationalization-and-localization/setting-the-language-for-error-messages) for more information. ### Locale Options and System Variables * [character-set-filesystem](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_filesystem) * [character-set-client](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_client) * [character-set-connection](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_connection) * [character-set-database](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_database) * [character-set-filesystem](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_filesystem) * [character-set-results](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_results) * [character-set-server](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_server) * [character-set-system](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_system) * [character-sets-dir](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_sets_dir) * [collation-connection](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#collation_connection) * [collation-database](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#collation_database) * [collation-server](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#collation_server) * [default-week-format](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#default_week_format) * [default-time-zone](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#time_zone) * [lc-messages](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#lc_messages) * [lc-messages-dir](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#lc_messages_dir) * [lc-time-names](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#lc_time_names) ## Windows Options Options that are also system variables are listed after: #### `--console` * Description: Windows-only option that keeps the console window open and for writing log messages to stderr and stdout. If specified together with [--log-error](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_error), the last option will take precedence. #### `--install` * Description: Windows-only option that installs the `mariadbd` process as a Windows service. * The Windows service created with this option [auto-starts](https://mariadb.com/docs/server/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-binary-tarballs#auto-start-of-mariadbd). If you want a service that is started on demand, then use the [--install-manual](#install-manual) option. * This option takes a service name as an argument. If this option is provided without a service name, then the service name defaults to "MARIADB". * This option is deprecated and may be removed in a future version. See [MDEV-19358](https://jira.mariadb.org/browse/MDEV-19358) for more information. #### `--install-manual` * Description: Windows-only option that installs the `mariadbd` process as a Windows service. * The Windows service created with this option is started on demand. If you want a service that [auto-starts](https://mariadb.com/docs/server/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-binary-tarballs#auto-start-of-mariadbd), use the [--install](#install) option. * This option takes a service name as an argument. If this option is provided without a service name, then the service name defaults to "MARIADB". * This option is deprecated and may be removed in a future version. See [MDEV-19358](https://jira.mariadb.org/browse/MDEV-19358) for more information. #### `--remove` * Description: Windows-only option that removes the Windows service created by the [--install](#install) or [--install-manual](#install-manual) options. * This option takes a service name as an argument. If this option is provided without a service name, then the service name defaults to "MARIADB". * This option is deprecated and may be removed in a future version. See [MDEV-19358](https://jira.mariadb.org/browse/MDEV-19358) for more information. #### `--slow-start-timeout` * Description: Windows-only option that defines the maximum number of milliseconds that the service control manager should wait before trying to kill the Windows service during startup. Defaults to `15000`. #### `--standalone` * Description: Windows-only option that has no effect. Kept for compatibility reasons. ### Windows Options and System Variables The following options and system variables are related to using MariaDB on Windows: * [--named-pipe](https://app.gitbook.com/s/0pSbu5DcMSW4KwAkUcmX/maxscale-archive/archive/mariadb-maxscale-23-02/mariadb-maxscale-23-02-filters/mariadb-maxscale-2302-transaction-performance-monitoring-filter#named_pipe) ## Replication and Binary Logging Options The following options are related to [replication](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-replication) and the [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log). Options that are also system variables are listed after: #### `--abort-slave-event-count` * Command line: `--abort-slave-event-count=#` * Description: Option used by mysql-test for debugging and testing of replication. #### `--binlog-do-db` * Command line: `--binlog-do-db=name` * Description: This option allows you to configure a [replication master](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-overview) to write statements and transactions affecting databases that match a specified name into its [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log). Since the filtered statements or transactions will not be present in the [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log), its replicas will not be able to replicate them. * This option will not work with cross-database updates with [statement-based logging](https://mariadb.com/docs/server/server-monitoring-logs/binary-log/binary-log-formats#statement-based-logging). See the [Statement-Based Logging](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-filters#statement-based-logging) section for more information. * This option can not be set dynamically. Available as a [system variable](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#binlog_do_db) from [MariaDB 11.2.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.2/11.2.0). * When setting it on the command-line or in a server [option group](https://mariadb.com/docs/server/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files#option-groups) in an [option file](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files), the option does not accept a comma-separated list. If you would like to specify multiple filters, then you need to specify the option multiple times. * See [Replication Filters](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-filters) for more information. #### `--binlog-ignore-db` * Command line: `--binlog-ignore-db=name` * Description: This option allows you to configure a [replication master](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-overview) to not write statements and transactions affecting databases that match a specified name into its [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log). Since the filtered statements or transactions will not be present in the [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log), its replicas will not be able to replicate them. * This option will not work with cross-database updates with [statement-based logging](https://mariadb.com/docs/server/server-monitoring-logs/binary-log/binary-log-formats#statement-based-logging). See the [Statement-Based Logging](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-filters#statement-based-logging) section for more information. * This option can not be set dynamically. Available as a [system variable](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#binlog_ignore_db) from [MariaDB 11.2.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.2/11.2.0). * When setting it on the command-line or in a server [option group](https://mariadb.com/docs/server/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files#option-groups) in an [option file](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files), the option does not accept a comma-separated list. If you would like to specify multiple filters, then you need to specify the option multiple times. * See [Replication Filters](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-filters) for more information. #### `--binlog-row-event-max-size` * Command line: `--binlog-row-event-max-size=#` * Description: The maximum size of a row-based [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log) event in bytes. Rows will be grouped into events smaller than this size if possible. The value has to be a multiple of 256. Available as a [system variable](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#binlog_row_event_max_size) from [MariaDB 11.2.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.2/11.2.0). * Default value `8192` #### `--disconnect-slave-event-count` * Command line: `--disconnect-slave-event-count=#` * Description: Option used by mysql-test for debugging and testing of replication. #### `--flashback` * Command line: `--flashback` * Description: Setup the server to use flashback. This enables the [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log) and sets `binlog_format=ROW`. #### `--init-rpl-role` * Command line: `--init-rpl-role=name` * Description: Sets the replication role for the server. In older versions of MariaDB, a primary server configured with both `rpl_semi_sync_master_enabled=1` and `rpl_semi_sync_slave_enabled=1` could experience data loss after a restart. Upon recovery, the primary might truncate its binary log, dropping transactions that replicas had already received and executed. This caused the replica's `gtid_slave_pos` to be ahead of the primary's `gtid_binlog_pos`, leading to an error state. Starting with MariaDB 10.6.19, MariaDB 10.11.9, MariaDB 11.1.6, MariaDB 11.2.5, MariaDB 11.4.3, and MariaDB 11.5.2, the condition for binary log truncation during semi-synchronous recovery has changed: * Preventing Data Loss: If you restart a primary server and do not set `--init-rpl-role` to `SLAVE`, the server will not truncate transactions required by the replicas. * Requirements: This protection allows you to keep both `rpl_semi_sync_master_enabled` and `rpl_semi_sync_slave_enabled` active on a primary to ensure no transactions are lost during a restart. * Default value: `MASTER` * Valid values: `MASTER` or `SLAVE` #### `--log-basename` * Command line: `--log-basename=name` * Description: Basename for all log files and the .pid file. This sets all log file names at once (in 'datadir') and is normally the only option you need for specifying log files. This is especially recommended to be set if you are using [replication](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-replication) as it ensures that your log file names are not dependent on your host name. Sets names for the [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log), [relay log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/relay-log), [general query log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/general-query-log), [slow query log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/slow-query-log) and [error log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/error-log). Note that if you explicity set log file names with any of these other options; [log-bin-index](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables), [relay-log](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables), [relay-log-index](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables), [general-log-file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#general_log_file), [log\_slow\_query\_file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_query_file) ([slow\_query\_log\_file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#slow_query_log_file)), [log\_error](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_error), and [pid-file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#pid_file), these should be placed after `--log-basename` in the config files. Later settings override earlier settings, so `log-basename` will override any earlier log file name settings. #### `--log-bin-trust-routine-creators` * Command line: `--log-bin-trust-routine-creators` * Description: Deprecated, use [log-bin-trust-function-creators](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables). #### `--master-host` * Command line: `--master-host=name` * Description: Primary hostname or IP address for replication. If not set, the replica thread will not be started. Note that the setting of master-host will be ignored if there exists a valid master.info file. #### `--master-info-file` * Command line: `--master-info-file=name` * Description: Name and location of the file on the replica where the `MASTER_LOG_FILE` and `MASTER_LOG_POS` options (i.e. the [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log) position on the primary) and most other [CHANGE MASTER](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/change-master-to) options are written. The [replica's I/O thread](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-threads#replica-io-thread) keeps this [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log) position updated as it downloads events. * See [CHANGE MASTER TO: Option Persistence](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/change-master-to#option-persistence) for more information. #### `--master-password` * Command line: `--master-password=name` * Description: The password the replica thread will authenticate with when connecting to the primary. If not set, an empty password is assumed. The value in master.info will take precedence if it can be read. #### `--master-port` * Command line: `--master-port=#` * Description: The port the master is listening on. If not set, the compiled setting of MYSQL\_PORT is assumed. If you have not tinkered with configure options, this should be 3306. The value in master.info will take precedence if it can be read. #### `--master-retry-count` * Command line: `--master-retry-count=#` * Description: Number of times a replica will attempt to connect to a primary before giving up. The retry interval is determined by the MASTER\_CONNECT\_RETRY option for the CHANGE MASTER statement. A value of 0 means the replica will not stop attempting to reconnect. Reconnects are triggered when a replica has timed out. See [slave\_net\_timeout](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables). * Default Value: `86400` through 10.5, `100000` as of 10.6 * Range - 32 bit: `0 to 4294967295` * Range - 64 bit: `0 to 18446744073709551615` #### `--master-ssl` * Command line: `--master-ssl` * Description: Enable the replica to [connect to the master using TLS](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/secure-connections-overview). #### `--master-ssl-ca` * Command line: `--master-ssl-ca[=name]` * Description: Master TLS CA file. Only applies if you have enabled [master-ssl](#-master-ssl). #### `--master-ssl-capath` * Command line: `--master-ssl-capath[=name]` * Description: Master TLS CA path. Only applies if you have enabled [master-ssl](#-master-ssl). #### `--master-ssl-cert` * Command line: `--master-ssl-cert[=name]` * Description: Master TLS certificate file name. Only applies if you have enabled [master-ssl](#-master-ssl). #### `--master-ssl-cipher` * Command line: `--master-ssl-cipher[=name]` * Description: Master TLS cipher. Only applies if you have enabled [master-ssl](#-master-ssl). #### `--master-ssl-key` * Command line: `--master-ssl-key[=name]` * Description: Master TLS keyfile name. Only applies if you have enabled [master-ssl](#-master-ssl). #### `--master-user` * Command line: `--master-user=name` * Description: The username the replica thread will use for authentication when connecting to the primary. The user must have FILE privilege. If the primary user is not set, user test is assumed. The value in master.info will take precedence if it can be read. #### `--max-binlog-dump-events` * Command line: `--max-binlog-dump-events=#` * Description: Option used by mysql-test for debugging and testing of replication. #### `--replicate-same-server-id` * Command line: `--replicate-same-server-id` * Description: 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](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) is used. Added as a [system variable](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#replicate_same_server_id) in [MariaDB 12.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/12.0/what-is-mariadb-120). #### `--sporadic-binlog-dump-fail` * Command line: `--sporadic-binlog-dump-fail` * Description: Option used by mysql-test for debugging and testing of replication. #### `--sysdate-is-now` * Command line: `--sysdate-is-now` * Description: Non-default option to alias [SYSDATE()](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/sysdate) to [NOW()](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/now) to make it safe for [replication](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-replication). Since 5.0, SYSDATE() has returned a \`dynamic' value different for different invocations, even within the same statement. ### Replication and Binary Logging Options and System Variables The options and system variables related to [Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication) and [Binary Logging](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log) are described on [Replication and Binary Logging System Variables](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables). ### Semisynchronous Replication Options and System Variables The options and system variables related to [Semisynchronous Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication) are described [here](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication#system-variables). ## Optimizer Options Options that are also system variables are listed after: #### `--record-buffer` * Command line: `--record-buffer=#` * Description: Old alias for [read\_buffer\_size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#read_buffer_size). * Removed: [MariaDB 5.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5) #### `--table-cache` * Command line: `--table-open-cache=#` * Description: Removed; use [--table-open-cache](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#table_open_cache) instead. * Removed: [MariaDB 5.3.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/5.3/5.3.1) ### Optimizer Options and System Variables * [alter-algorithm](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#alter_algorithm) * [analyze-max-length](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#analyze_max_length) * [analyze-sample-percentage](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#analyze_sample_percentage) * [big-tables](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#big_tables) * [bulk-insert-buffer-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#bulk_insert_buffer_size) * [expensive-subquery-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#expensive_subquery_limit) * [join-buffer-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#join_buffer_size) * [join-buffer-space-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#join_buffer_space_limit) * [join-cache-level](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#join_cache_level) * [max-heap-table-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_heap_table_size) * [max-join-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_join_size) * [max-seeks-for-key](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_seeks_for_key) * [max-sort-length](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_sort_length) * [mrr-buffer-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#mrr_buffer_size) * [optimizer-adjust-secondary-key-costs](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer_adjust_secondary_key_costs) * [optimizer-extra-pruning-depth](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_extra_pruning_depth) * [optimizer-join-limit-pref-ratio](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_join_limit_pref_ratio) * [optimizer-max-sel-arg-weight](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_max_sel_arg_weight) * [optimizer-max-sel-args](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_max_sel_args) * [optimizer-prune-level](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_prune_level) * [optimizer-record-context](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_record_context) * [optimizer-search-depth](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_search_depth) * [optimizer-selectivity-sampling-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_selectivity_sampling_limit) * [optimizer-switch](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_switch) * [optimizer-trace](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_trace) * [optimizer-trace-max-mem-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_trace_max_mem_size) * [optimizer-use-condition-selectivity](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#optimizer_use_condition_selectivity) * [query-alloc-block-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#query_alloc_block_size) * [query-prealloc-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#query_prealloc_size) * [range-alloc-block-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#range_alloc_block_size) * [read-buffer-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#read_buffer_size) * [rowid-merge-buff-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#rowid_merge_buff_size) * [table-definition-cache](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#table_definition_cache) * [table-open-cache](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#table_open_cache) * [table-open-cache-instances](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#table_open_cache_instances) * [tmp-disk-table-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#tmp_disk_table_size) * [tmp-memory-table-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#tmp_memory_table_size) * [tmp-table-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#tmp_table_size) * [use-stat-tables](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#use_stat_tables) ## Storage Engine Options #### `--skip-bdb` * Command line: `----skip-bdb` * Description: Deprecated option; Exists only for compatibility with very old my.cnf files. * Removed: [MariaDB 10.5.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.1) #### `--external-locking` * Command line: `--external-locking` * Description: Use system (external) locking (disabled by default). With this option enabled you can run [myisamchk](https://mariadb.com/docs/server/clients-and-utilities/myisam-clients-and-utilities/myisamchk) to test (not repair) tables while the server is running. Disable with [--skip-external-locking](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#skip_external_locking). From [MariaDB 10.2.40](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.40), [MariaDB 10.3.31](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.3/10.3.31), [MariaDB 10.4.21](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.4/10.4.21), [MariaDB 10.5.12](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.12), [MariaDB 10.6.4](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/10.6.4) and all later version, this effects InnoDB and can be used to prevent multiple instances running on the same data. ### MyISAM Storage Engine Options The options related to the [MyISAM](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine) storage engine are described below. Options that are also system variables are listed after: #### `--log-isam` * Command line: `--log-isam[=file_name]` * Description: Enable the [MyISAM log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/myisam-log), which logs all MyISAM changes to file. If no filename is provided, the default, myisam.log is used. #### MyISAM Storage Engine Options and System Variables Some options and system variables related to the [MyISAM](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine) storage engine can be found [here](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-storage-formats). Direct links to many of them can be found below. * [concurrent-insert](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#concurrent_insert) * [delayed-insert-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#delayed_insert_limit) * [delayed-insert-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#delayed_insert_timeout) * [delayed-queue-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#delayed_queue_size) * [keep-files-on-create](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#keep_files_on_create) * [key-buffer-size](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_buffer_size) * [key-cache-age-threshold](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_cache_age_threshold) * [key-cache-block-size](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_cache_block_size) * [key-cache-division-limit](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_cache_division_limit) * [key-cache-file-hash-size](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_cache_division_limit) * [key-cache-segments](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_cache_segments) * [myisam-block-size](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_block_size) * [myisam-data-pointer-size](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_data_pointer_size) * [myisam-max-sort-file-size](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_max_sort_file_size) * [myisam-mmap-size](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_mmap_size) * [myisam-recover-options](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_recover_options) * [myisam-repair-threads](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_repair_threads) * [myisam-sort-buffer-size](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_sort_buffer_size) * [myisam-stats-method](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_stats_method) * [myisam-use-mmap](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_use_mmap) ### InnoDB Storage Engine Options The options related to the [InnoDB](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-storage-engine-introduction) storage engine are described below. Options that are also system variables are listed after: #### `--innodb` * Command line: `--innodb=value`, `--skip-innodb` * Description: This variable controls whether or not to load the InnoDB storage engine. Possible values are `ON`, `OFF`, `FORCE` or `FORCE_PLUS_PERMANENT` (from [MariaDB 5.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5)). If set to `OFF` (the same as --skip-innodb), since InnoDB is the default storage engine, the server will not start unless another storage engine has been chosen with [--default-storage-engine](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#default_storage_engine). `FORCE` means that the storage engine must be successfully loaded, or else the server won't start. `FORCE_PLUS_PERMANENT` enables the plugin, but if plugin cannot initialize, the server will not start. In addition, the plugin cannot be uninstalled while the server is running. #### `--innodb-cmp` * Command line: `--innodb-cmp` * Description: * Default: `ON` #### `--innodb-cmp-reset` * Command line: `--innodb-cmp-reset` * Description: * Default: `ON` #### `--innodb-cmpmem` * Command line: `--innodb-cmpmem` * Description: * Default: `ON` #### `--innodb-cmpmem-reset` * Command line: `--innodb-cmpmem-reset` * Description: * Default: `ON` #### `--innodb-file-io-threads` * Command line: `--innodb-file-io-threads` * Description: * Default: `4` * Removed: [MariaDB 10.3.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.3/10.3.0) #### `--innodb-index-stats` * Command line: `--innodb-index-stats` * Description: * Default: `ON` * Removed: [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0) #### `--innodb-lock-waits` * Command line: `--innodb-lock-waits` * Description: * Default: `ON` #### `--innodb-locks` * Command line: `--innodb-locks` * Description: * Default: `ON` #### `--innodb-rseg` * Command line: `--innodb-rseg` * Description: * Default: `ON` * Removed: [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0) #### `--innodb-status-file` * Command line: `--innodb-status-file` * Description: * Default: `FALSE` #### `--innodb-sys-indexes` * Command line: `--innodb-sys-indexes` * Description: * Default: `ON` #### `--innodb-sys-stats` * Command line: `--innodb-sys-stats` * Description: * Default: `ON` * Removed: [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0) #### `--innodb-sys-tables` * Command line: `--innodb-sys-tables` * Description: * Default: `ON` #### `--innodb-table-stats` * Command line: `--innodb-table-stats` * Description: * Default: `ON` * Removed: [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0) #### `--innodb-trx` * Command line: `--innodb-trx` * Description: * Default: `ON` #### InnoDB Storage Engine Options and System Variables Some options and system variables related to the [InnoDB](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-storage-engine-introduction) storage engine can be found [here](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-storage-engine-introduction). Direct links to many of them can be found below. * [ignore-builtin-innodb](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#ignore_builtin_innodb) * [innodb-adaptive-checkpoint](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_adaptive_checkpoint) * [innodb-adaptive-flushing](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_adaptive_flushing) * [innodb-adaptive-flushing-lwm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_adaptive_flushing_lwm) * [innodb-adaptive-flushing-method](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_adaptive_flushing_method) * [innodb-adaptive-hash-index](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_adaptive_hash_index) * [innodb-adaptive-hash-index-partitions](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_adaptive_hash_index_partitions) * [innodb-adaptive-hash-index-parts](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_adaptive_hash_index_parts) * [innodb-adaptive-max-sleep-delay](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_adaptive_max_sleep_delay) * [innodb-additional-mem-pool-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_additional_mem_pool_size) * [innodb-alter-copy-bulk](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_alter_copy_bulk) * [innodb-api-bk-commit-interval](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_api_bk_commit_interval) * [innodb-api-disable-rowlock](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_api_disable_rowlock) * [innodb-api-enable-binlog](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_api_enable_binlog) * [innodb-api-enable-mdl](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_api_trx_level) * [innodb-api-trx-level](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_api_trx_level) * [innodb-auto-lru-dump](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_auto_lru_dump) * [innodb-autoextend-increment](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_autoextend_increment) * [innodb-autoinc-lock-mode](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_autoinc_lock_mode) * [innodb-background-scrub-data-check-interval](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_background_scrub_data_check_interval) * [innodb-background-scrub-data-compressed](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_background_scrub_data_compressed) * [innodb-background-scrub-data-interval](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_background_scrub_data_interval) * [innodb-background-scrub-data-uncompressed](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_background_scrub_data_uncompressed) * [innodb-blocking-buffer-pool-restore](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_blocking_buffer_pool_restore) * [innodb-buf-dump-status-frequency](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buf_dump_status_frequency) * [innodb-buffer-pool-chunk-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_chunk_size) * [innodb-buffer-pool-dump-at-shutdown](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_dump_at_shutdown) * [innodb-buffer-pool-dump-now](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_dump_now) * [innodb-buffer-pool-dump-pct](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_dump_pct) * [innodb-buffer-pool-evict](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_evict) * [innodb-buffer-pool-filename](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_filename) * [innodb-buffer-pool-instances](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_instances) * [innodb-buffer-pool-load-abort](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_load_abort) * [innodb-buffer-pool-load-at-startup](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_load_at_startup) * [innodb-buffer-pool-load-now](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_load_now) * [innodb-buffer-pool-load-pages-abort](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_load_pages_abort) * [innodb-buffer-pool-populate](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_populate) * [innodb-buffer-pool-restore-at-startup](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_restore_at_startup) * [innodb-buffer-pool-shm-checksum](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_shm_checksum) * [innodb-buffer-pool-shm-key](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_shm_key) * [innodb-buffer-pool-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_size) * [innodb-buffer-pool-size-auto-min](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_size_auto_min) * [innodb-buffer-pool-size-max](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_size_max) * [innodb-change-buffer-max-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_change_buffer_max_size) * [innodb-change-buffering](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_change_buffering) * [innodb-change-buffering-debug](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_change_buffering_debug) * [innodb-checkpoint-age-target](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_checkpoint_age_target) * [innodb-checksum-algorithm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_checksums) * [innodb-checksums](https://mariadb.com/docs/server/clients-and-utilities/administrative-tools/innochecksum) * [innodb-cleaner-lsn-age-factor](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_cleaner_lsn_age_factor) * [innodb-cmp-per-index-enabled](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_cmp_per_index_enabled) * [innodb-commit-concurrency](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_commit_concurrency) * [innodb-compression-algorithm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_compression_algorithm) * [innodb-compression-failure-threshold-pct](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_compression_failure_threshold_pct) * [innodb-compression-level](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_compression_level) * [innodb-compression-pad-pct-max](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_compression_pad_pct_max) * [innodb-concurrency-tickets](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_concurrency_tickets) * [innodb-corrupt-table-action](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_corrupt_table_action) * [innodb-data-file-buffering](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_data_file_buffering) * [innodb-data-file-path](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_data_file_path) * [innodb-data-file-write-through](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_data_file_write_through) * [innodb-data-home-dir](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_data_home_dir) * [innodb-deadlock-detect](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_deadlock_detect) * [innodb-deadlock-report](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_deadlock_report) * [innodb-default-encryption-key-id](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_default_encryption_key_id) * [innodb-default-page-encryption-key](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_default_page_encryption_key) * [innodb-default-row-format](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_default_row_format) * [innodb-defragment](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_defragment) * [innodb-defragment-fill-factor](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_defragment_fill_factor) * [innodb-defragment-fill-factor-n-recs](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_defragment_fill_factor_n_recs) * [innodb-defragment-frequency](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_defragment_frequency) * [innodb-defragment-n-pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_defragment_n_pages) * [innodb-defragment-stats-accuracy](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_defragment_stats_accuracy) * [innodb-dict-size-limit](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_dict_size_limit) * [innodb\_disable\_sort\_file\_cache](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_disable_sort_file_cache) * [innodb-doublewrite](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_doublewrite) * [innodb-doublewrite-file](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_doublewrite_file) * [innodb-empty-free-list-algorithm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_empty_free_list_algorithm) * [innodb-enable-unsafe-group-commit](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_enable_unsafe_group_commit) * [innodb-encrypt-log](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_encrypt_log) * [innodb-encrypt-tables](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_encrypt_tables) * [innodb-encrypt-temporary-tables](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_encrypt_temporary_tables) * [innodb-encryption-rotate-key-age](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_encryption_rotate_key_age) * [innodb-encryption-rotation\_iops](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_encryption_rotation_iops) * [innodb-encryption-threads](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_encryption_threads) * [innodb-extra-rsegments](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_extra_rsegments) * [innodb-extra-undoslots](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_extra_undoslots) * [innodb-fake-changes](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_fake_changes) * [innodb-fast-checksum](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_fast_checksum) * [innodb-fast-shutdown](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_fast_shutdown) * [innodb-fatal-semaphore-wait-threshold](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_fatal_semaphore_wait_threshold) * [innodb-file-format](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-file-format) * [innodb-file-format-check](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_file_format_check) * [innodb-file-format-max](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_file_format_max) * [innodb-file-per-table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_file_per_table) * [innodb-fill-factor](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_fill_factor) * [innodb-flush-log-at-trx-commit](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_flush_log_at_trx_commit) * [innodb-flush-method](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_flush_method) * [innodb-flush-neighbor-pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_flush_neighbor_pages) * [innodb-flush-neighbors](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_flush_neighbors) * [innodb-flush-sync](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_flush_sync) * [innodb-flushing-avg-loops](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_flushing_avg_loops) * [innodb-force-load-corrupted](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_force_load_corrupted) * [innodb-force-primary-key](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_force_primary_key) * [innodb-force-recovery](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_force_recovery) * [innodb-foreground-preflush](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_foreground_preflush) * [innodb-ft-aux-table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_aux_table) * [innodb-ft-cache-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_cache_size) * [innodb-ft-enable-diag-print](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_enable_diag_print) * [innodb-ft-enable-stopword](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_enable_stopword) * [innodb-ft-max-token-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_max_token_size) * [innodb-ft-min-token-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_min_token_size) * [innodb-ft-num-word-optimize](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_num_word_optimize) * [innodb-ft-result-cache-limit](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_result_cache_limit) * [innodb-ft-server-stopword-table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_server_stopword_table) * [innodb-ft-sort-pll-degree](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_sort_pll_degree) * [innodb-ft-total-cache-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_total_cache_size) * [innodb-ft-user-stopword-table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_user_stopword_table) * [innodb-ibuf-accel-rate](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ibuf_accel_rate) * [innodb-ibuf-active-contract](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ibuf_active_contract) * [innodb-ibuf-max-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ibuf_max_size) * [innodb-idle-flush-pct](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_idle_flush_pct) * [innodb-immediate-scrub-data-uncompressed](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_immediate_scrub_data_uncompressed) * [innodb-import-table-from-xtrabackup](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_import_table_from_xtrabackup) * [innodb-instant-alter-column-allowed](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_instant_alter_column_allowed) * [innodb-instrument-semaphores](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_instrument_semaphores) * [innodb-io-capacity](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_io_capacity) * [innodb-io-capacity-max](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_io_capacity_max) * [innodb-large-prefix](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_large_prefix) * [innodb-lazy-drop-table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_lazy_drop_table) * [innodb-lock-schedule-algorithm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_lock_schedule_algorithm) * [innodb-locking-fake-changes](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_locking_fake_changes) * [innodb-locks-unsafe-for-binlog](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_locks_unsafe_for_binlog) * [innodb-log-arch-dir](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_arch_dir) * [innodb-log-arch-expire-sec](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_arch_expire_sec) * [innodb-log-archive](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_archive) * [innodb-log-block-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_block_size) * [innodb-log-buffer-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_buffer_size) * [innodb-log-checkpoint-now](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_checkpoint_now) * [innodb-log-checksum-algorithm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_checksum_algorithm) * [innodb-log-checksums](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_checksums) * [innodb-log-compressed-pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) * [innodb-log-file-buffering](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_file_buffering) * [innodb-log-file-mmap](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_file_mmap) * [innodb-log-file-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_file_size) * [innodb-log-file-write-through](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_files_in_group) * [innodb-log-files-in-group](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_files_in_group) * [innodb-log-group-home-dir](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_group_home_dir) * [innodb-log-optimize-ddl](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_optimize_ddl) * [innodb-log-spin-wait-delay](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_spin_wait_delay) * [innodb-log-write-ahead-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_write_ahead_size) * [innodb-lru-flush-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_lru_flush_size) * [innodb-lru-scan-depth](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_lru_scan_depth) * [innodb-max-bitmap-file-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_max_bitmap_file_size) * [innodb-max-changed-pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_max_changed_pages) * [innodb-max-dirty-pages-pct](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_max_dirty_pages_pct) * [innodb-max-dirty-pages-pct-lwm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_max_dirty_pages_pct_lwm) * [innodb-max-purge-lag](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_max_purge_lag) * [innodb-max-purge-lag-delay](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_max_purge_lag_delay) * [innodb-max-purge-lag-wait](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_max_purge_lag_wait) * [innodb-max-undo-log-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_max_undo_log_size) * [innodb-merge-sort-block-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_merge_sort_block_size) * [innodb-mirrored-log-groups](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_mirrored_log_groups) * [innodb-monitor-disable](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_monitor_disable) * [innodb-monitor-enable](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_monitor_enable) * [innodb-monitor-reset](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_monitor_reset) * [innodb-monitor-reset-all](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_monitor_reset_all) * [innodb-mtflush-threads](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_mtflush_threads) * [innodb-numa-interleave](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_numa_interleave) * [innodb-old-blocks-pct](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_old_blocks_pct) * [innodb-old-blocks-time](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_old_blocks_time) * [innodb-online-alter-log-max-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_online_alter_log_max_size) * [innodb-open-files](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_open_files) * [innodb-optimize-fulltext-only](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_optimize_fulltext_only) * [innodb-page-cleaners](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_page_cleaners) * [innodb-page-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_page_size) * [innodb-pass-corrupt-table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_pass_corrupt_table) * [innodb-prefix-index-cluster-optimization](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_prefix_index_cluster_optimization) * [innodb-print-all-deadlocks](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_print_all_deadlocks) * [innodb-purge-batch-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_purge_batch_size) * [innodb-purge-rseg-truncate-frequency](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_purge_rseg_truncate_frequency) * [innodb-purge-threads](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_purge_threads) * [innodb-random-read-ahead](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_random_read_ahead) * [innodb-read-ahead](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_read_ahead) * [innodb-read-ahead-threshold](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_read_ahead_threshold) * [innodb-read-io-threads](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_read_io_threads) * [innodb-read-only](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_read_only) * [innodb-recovery-update-relay-log](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_recovery_update_relay_log) * [innodb-replication-delay](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_replication_delay) * [innodb-rollback-on-timeout](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_rollback_on_timeout) * [innodb-rollback-segments](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_rollback_segments) * [innodb-safe-truncate](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_safe_truncate) * [innodb-sched-priority-cleaner](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_sched_priority_cleaner) * [innodb-scrub-log](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_scrub_log) * [innodb-scrub-log-interval](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_scrub_log_interval) * [innodb-scrub-log-speed](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_scrub_log_speed) * [innodb-show-locks-held](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_show_locks_held) * [innodb-show-verbose-locks](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_show_verbose_locks) * [innodb-snapshot-isolation](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_snapshot_isolation) * [innodb-sort-buffer-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_sort_buffer_size) * [innodb-spin-wait-delay](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_spin_wait_delay) * [innodb-stats-auto-recalc](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_auto_recalc) * [innodb-stats-auto-update](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_auto_update) * [innodb-stats-include-delete-marked](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_include_delete_marked) * [innodb-stats-method](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_method) * [innodb-stats-modified-counter](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_modified_counter) * [innodb-stats-on-metadata](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_on_metadata) * [innodb-stats-persistent](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_persistent) * [innodb-stats-persistent-sample-pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_persistent_sample_pages) * [innodb-stats-sample-pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_sample_pages) * [innodb-stats-transient-sample-pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_transient_sample_pages) * [innodb-stats-traditional](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_traditional) * [innodb-stats-update-need-lock](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_stats_update_need_lock) * [innodb-status-output](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_status_output) * [innodb-status-output-locks](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_status_output_locks) * [innodb-strict-mode](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_strict_mode) * [innodb-support-xa](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_support_xa) * [innodb-sync-array-size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_sync_array_size) * [innodb-sync-spin-loops](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_sync_spin_loops) * [innodb-table-locks](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_table_locks) * [innodb-temp-data-file-path](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_temp_data_file_path) * [innodb-thread-concurrency](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_thread_concurrency) * [innodb-thread-concurrency-timer-based](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_thread_concurrency_timer_based) * [innodb-thread-sleep-delay](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_thread_sleep_delay) * [innodb-tmpdir](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_tmpdir) * [innodb-track-changed-pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_track_changed_pages) * [innodb-track-redo-log-now](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_track_redo_log_now) * [innodb-truncate-temporary-tablespace-now](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_truncate_temporary_tablespace_now) * [innodb-undo-directory](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_undo_directory) * [innodb-undo-log-truncate](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_undo_log_truncate) * [innodb-undo-logs](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_undo_logs) * [innodb-undo-tablespaces](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_undo_tablespaces) * [innodb-use-atomic-writes](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_use_atomic_writes) * [innodb-use-fallocate](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_use_fallocate) * [innodb-use-global-flush-log-at-trx-commit](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_use_global_flush_log_at_trx_commit) * [innodb-use-mtflush](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_use_mtflush) * [innodb-use-native\_aio](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_use_native_aio) * [innodb-use-purge-thread](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_use_purge_thread) * [innodb-use-stacktrace](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_use_stacktrace) * [innodb-use-sys-malloc](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_use_sys_malloc) * [innodb-use-sys-stats-table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_use_sys_stats_table) * [innodb-use-trim](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_use_trim) * [innodb-write-io-threads](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_write_io_threads) * skip-innodb * [skip-innodb-checksums](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-options#skip-innodb-log-checksums) * [skip-innodb-doublewrite](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-options#skip-innodb-doublewrite) ### Aria Storage Engine Options Options related to the [Aria](https://mariadb.com/docs/server/server-usage/storage-engines/aria) storage engine are listed below: #### Aria Storage Engine Options and System Variables Some options and system variables related to the [Aria](https://mariadb.com/docs/server/server-usage/storage-engines/aria) storage engine can be found [here](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables). Direct links to many of them can be found below. * [aria-block-size](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_block_size) * [aria-checkpoint-interval](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_checkpoint_interval) * [aria-checkpoint-log-activity](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_checkpoint_log_activity) * [aria-encrypt-tables](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_encrypt_tables) * [aria-force-start-after-recovery-failures](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_force_start_after_recovery_failures) * [aria-group-commit](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_group_commit) * [aria-group-commit-interval](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_group_commit_interval) * [aria-log-dir-path](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_log_dir_path) * [aria-log-file-size](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_log_file_size) * [aria-log-purge-type](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_log_purge_type) * [aria-max-sort-file-size](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_max_sort_file_size) * [aria-page-checksum](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_page_checksum) * [aria-pagecache-age-threshold](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_pagecache_age_threshold) * [aria-pagecache-buffer-size](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_pagecache_buffer_size) * [aria-pagecache-division-limit](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_pagecache_division_limit) * [aria-pagecache-file-hash-size](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_pagecache_file_hash_size) * [aria-pagecache-segments](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_pagecache_segments) * [aria-recover](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_recover) * [aria-recover-options](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_recover_options) * [aria-repair-threads](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_repair_threads) * [aria-sort-buffer-size](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_sort_buffer_size) * [aria-stats-method](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_stats_method) * [aria-sync-log-dir](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_sync_log_dir) * [aria-used-for-temp-tables](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_used_for_temp_tables) * [deadlock-search-depth-long](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#deadlock_search_depth_long) * [deadlock-search-depth-short](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#deadlock_search_depth_short) * [deadlock-timeout-long](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#deadlock_timeout_long) * [deadlock-timeout-short](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#deadlock_timeout_short) ### MyRocks Storage Engine Options The options and system variables related to the [MyRocks](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks) storage engine can be found [here](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-system-variables). ### S3 Storage Engine Options The options and system variables related to the [S3](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine) storage engine can be found [here](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-status-variables). ### CONNECT Storage Engine Options The options related to the [CONNECT](https://mariadb.com/docs/server/server-usage/storage-engines/connect) storage engine are described below. #### CONNECT Storage Engine Options and System Variables Some options and system variables related to the [CONNECT](https://mariadb.com/docs/server/server-usage/storage-engines/connect) storage engine can be found [here](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables). Direct links to many of them can be found below. * [connect-class-path](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_class_path) * [connect-cond-push](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_cond_push) * [connect-conv-size](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_conv_size) * [connect-default-depth](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_default_depth) * [connect-default-prec](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_default_prec) * [connect-enable-mongo](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_enable_mongo) * [connect-exact-info](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_exact_info) * [connect-force\_bson](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_force_bson) * [connect-indx-map](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_indx_map) * [connect-java-wrapper](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_java_wrapper) * [connect-json-all-path](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_json_all_path) * [connect-json-grp-size](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_json_grp_size) * [connect-json-null](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_json_null) * [connect-jvm-path](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_jvm_path) * [connect-type-conv](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_type_conv) * [connect-use-tempfile](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_use_tempfile) * [connect-work-size](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_work_size) * [connect-xtrace](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables#connect_xtrace) ### Spider Storage Engine Options The options and system variables related to the [Spider](https://mariadb.com/docs/server/server-usage/storage-engines/spider) storage engine can be found [here](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables). ### Mroonga Storage Engine Options The options and system variables related to the [Mroonga](https://mariadb.com/docs/server/server-usage/storage-engines/mroonga) storage engine can be found [here](https://mariadb.com/docs/server/server-usage/storage-engines/mroonga/mroonga-system-variables). ### TokuDB Storage Engine Options The options and system variables related to the [TokuDB](https://mariadb.com/docs/server/server-usage/storage-engines/legacy-storage-engines/tokudb) storage engine can be found [here](https://mariadb.com/docs/server/server-usage/storage-engines/legacy-storage-engines/tokudb/tokudb-system-variables). ### Vector Options The options and system variables related to [Vectors](https://mariadb.com/docs/server/reference/sql-structure/vectors) storage engine (beginning with `mhnsw`) can be found [here](https://mariadb.com/docs/server/reference/sql-structure/vectors/vector-system-variables). ## Performance Schema Options The options related to the [Performance Schema](https://mariadb.com/docs/server/reference/system-tables/performance-schema) are described below. Options that are also system variables are listed after: #### `--performance-schema-consumer-events-stages-current` * Command line: `--performance-schema-consumer-events-stages-current` * Description: Enable the [events-stages-current](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_current-table) consumer. * Default: `OFF` #### `--performance-schema-consumer-events-stages-history` * Command line: `--performance-schema-consumer-events-stages-history` * Description: Enable the [events-stages-history](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_history-table) consumer. * Default: `OFF` #### `--performance-schema-consumer-events-stages-history-long` * Command line: `--performance-schema-consumer-events-stages-history-long` * Description: Enable the [events-stages-history-long](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_history_long-table) consumer. * Default: `OFF` #### `--performance-schema-consumer-events-statements-current` * Command line: `--performance-schema-consumer-events-statements-current` * Description: Enable the [events-statements-current](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_current-table) consumer. Use `--skip-performance-schema-consumer-events-statements-current` to disable. * Default: `ON` #### `--performance-schema-consumer-events-statements-history` * Command line: `--performance-schema-consumer-events-statements-history` * Description: Enable the [events-statements-history](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_history-table) consumer. * Default: `OFF` #### `--performance-schema-consumer-events-statements-history-long` * Command line: `--performance-schema-consumer-events-statements-history-long` * Description: Enable the [events-statements-history-long](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_history_long-table) consumer. * Default: `OFF` #### `--performance-schema-consumer-events-waits-current` * Command line: `--performance-schema-consumer-events-waits-current` * Description: Enable the [events-waits-current](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_current-table) consumer. * Default: `OFF` #### `--performance-schema-consumer-events-waits-history` * Command line: `--performance-schema-consumer-events-waits-history` * Description: Enable the [events-waits-history](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_history-table) consumer. * Default: `OFF` #### `--performance-schema-consumer-events-waits-history-long` * Command line: `--performance-schema-consumer-events-waits-history-long` * Description: Enable the [events-waits-history-long](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_history_long-table) consumer. * Default: `OFF` #### `--performance-schema-consumer-global-instrumentation` * Command line: `--performance-schema-consumer-global-instrumentation` * Description: Enable the global-instrumentation consumer. Use `--skip-performance-schema-consumer-global-instrumentation` to disable. * Default: `ON` #### `--performance-schema-consumer-statements-digest` * Command line: `--performance-schema-consumer-statements-digest` * Description: Enable the statements-digest consumer. Use `--skip-performance-schema-consumer-statements-digest` to disable. * Default: `ON` #### `--performance-schema-consumer-thread-instrumentation` * Command line: `--performance-schema-consumer-thread-instrumentation` * Description: Enable the statements-thread-instrumentation. Use `--skip-performance-schema-thread-instrumentation` to disable. * Default: `ON` ### Performance Schema Options and System Variables Some options and system variables related to the [Performance Schema](https://mariadb.com/docs/server/reference/system-tables/performance-schema) can be found [here](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables). Direct links to many of them can be found below. * [performance-schema](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema) * [performance-schema-accounts-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_accounts_size) * [performance-schema-digests-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_digests_size) * [performance-schema-events-stages-history-long-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_stages_history_long_size) * [performance-schema-events-stages-history-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_stages_history_size) * [performance-schema-events-statements-history-long-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_statements_history_long_size) * [performance-schema-events-statements-history-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_statements_history_size) * [performance-schema-events-waits-history-long-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_waits_history_long_size) * [performance-schema-events-waits-history-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_waits_history_size) * [performance-schema-hosts-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_hosts_size) * [performance-schema-max-cond-classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_cond_classes) * [performance-schema-max-cond-instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_cond_instances) * [performance-schema-max-digest-length](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_digest_length) * [performance-schema-max-file-classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_file_classes) * [performance-schema-max-file-handles](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_file_handles) * [performance-schema-max-file-instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_file_instances) * [performance-schema-max-mutex-classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_mutex_classes) * [performance-schema-max-mutex-instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_mutex_instances) * [performance-schema-max-rwlock-classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_rwlock_classes) * [performance-schema-max-rwlock-instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_rwlock_instances) * [performance-schema-max-socket-classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_socket_classes) * [performance-schema-max-socket-instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_socket_instances) * [performance-schema-max-stage-classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_stage_classes) * [performance-schema-max-statement-classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_statement_classes) * [performance-schema-max-table-handles](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_table_handles) * [performance-schema-max-table-instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_table_instances) * [performance-schema-max-thread-classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_thread_classes) * [performance-schema-max-thread-instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_thread_instances) * [performance-schema-session-connect-attrs-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_session_connect_attrs_size) * [performance-schema-setup-actors-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_setup_actors_size) * [performance-schema-setup-objects-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_setup_objects_size) * [performance-schema-users-size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_users_size) ## Galera Cluster Options The options related to [Galera Cluster](https://mariadb.com/docs/server/architecture/topologies/galera-cluster) are described below. Options that are also system variables are listed after: #### `--wsrep-new-cluster` * Command line: `--wsrep-new-cluster` * Description: Bootstrap a cluster. It works by overriding the current value of wsrep\_cluster\_address. It is recommended not to add this option to the config file as this will trigger bootstrap on every server start. ### Galera Cluster Options and System Variables Some options and system variables related to [Galera Cluster](https://github.com/mariadb-corporation/docs-server/blob/test/kb/en/galera/README.md) can be found [here](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables). Direct links to many of them can be found below. * [wsrep-allowlist](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_allowlist) * [wsrep\_applier\_retry\_count](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_applier_retry_count) * [wsrep-auto-increment-control](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_auto_increment_control) * [wsrep-causal-reads](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_causal_reads) * [wsrep-certify-nonPK](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_certify_nonpk) * [wsrep-cluster-address](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_cluster_address) * [wsrep-cluster-name](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_cluster_name) * [wsrep-convert-LOCK-to-trx](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_convert_lock_to_trx) * [wsrep-data-home-dir](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_data_home_dir) * [wsrep-dbug-option](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_dbug_option) * [wsrep-debug](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_debug) * [wsrep-desync](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_desync) * [wsrep-dirty-reads](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_dirty_reads) * [wsrep-drupal-282555-workaround](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_drupal_282555_workaround) * [wsrep-forced-binlog-format](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_forced_binlog_format) * [wsrep-gtid-domain-id](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_gtid_domain_id) * [wsrep-gtid-mode](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_gtid_mode) * [wsrep-ignore-apply-errors](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_ignore_apply_errors) * [wsrep-load-data-splitting](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_load_data_splitting) * [wsrep-log-conflicts](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_log_conflicts) * [wsrep-max-ws-rows](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_max_ws_rows) * [wsrep-max-ws-size](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_max_ws_size) * [wsrep-mode](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_mode) * [wsrep-mysql-replication-bundle](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_mysql_replication_bundle) * [wsrep-node-address](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_node_address) * [wsrep-node-incoming-address](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_node_incoming_address) * [wsrep-node-name](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_node_name) * [wsrep-notify-cmd](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_notify_cmd) * [wsrep-on](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_on) * [wsrep-OSU-method](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_osu_method) * [wsrep-provider](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_provider) * [wsrep-provider-options](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_provider_options) * [wsrep-recover](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_recover) * [wsrep-reject\_queries](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_reject_queries) * [wsrep-retry-autocommit](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_retry_autocommit) * [wsrep-slave-FK-checks](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_slave_fk_checks) * [wsrep-slave-threads](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_slave_threads) * [wsrep-slave-UK-checks](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_slave_uk_checks) * [wsrep-sr-store](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_sr_store) * [wsrep-sst-auth](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_sst_auth) * [wsrep-sst-donor](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_sst_donor) * [wsrep-sst-donor-rejects-queries](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_sst_donor_rejects_queries) * [wsrep-sst-method](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_sst_method) * [wsrep-sst-receive-address](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_sst_receive_address) * [wsrep-start-position](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_start_position) * [wsrep-status-file](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_status_file) * [wsrep-strict-ddl](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_strict_ddl) * [wsrep-sync-wait](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_sync_wait) * [wsrep-trx\_fragment\_size](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_trx_fragment_size) * [wsrep-trx\_fragment\_unit](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_trx_fragment_unit) ## Options When Debugging mariadbd #### `--debug-assert-if-crashed-table` * Description: Do an assert in handler::print\_error() if we get a crashed table. #### `--debug-binlog-fsync-sleep` * Description: `--debug-binlog-fsync-sleep=#`If not set to zero, sets the number of micro-seconds to sleep after running fsync() on the [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log) to flush transactions to disk. This can thus be used to artificially increase the perceived cost of such an fsync(). #### `--debug-crc-break` * Description: `--debug-crc-break=#`Call my\_debug\_put\_break\_here() if crc matches this number (for debug). #### `--debug-flush` * Description: Default debug log with flush after write. #### `--debug-no-sync` * Description: `debug-no-sync[=#]`Disables system sync calls. Only for running tests or debugging! #### `--debug-sync-timeout` * Description: `debug-sync-timeout[=#]`Enable the debug sync facility and optionally specify a default wait timeout in seconds. A zero value keeps the facility disabled. #### `--gdb` * Description: Set up signals usable for debugging. #### `--silent-startup` * Description: Don't print Notes to the [error log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/error-log) during startup. #### `--sync-sys` * Description: Enable/disable system sync calls. Syncs should only be turned off (`--disable-sync-sys`) when running tests or debugging! Replaced by [debug-no-sync](#-debug-no-sync) from [MariaDB 5.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5). * Removed: [MariaDB 5.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5) #### `--thread-alarm` * Description: Enable/disable system thread alarm calls. Should only be turned off (`--disable-thread-alarm`) when running tests or debugging! ### Debugging Options and System Variables * [core-file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#core_file) * [debug](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#debug) * [debug-no-thread-alarm](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#debug_no_thread_alarm) ## Other Options Options that are also system variables are listed after: #### `--allow-suspicious-udfs` * Command line: `--allow-suspicious-udfs` * Description: Allows use of [user-defined functions](https://mariadb.com/docs/server/server-usage/user-defined-functions) consisting of only one symbol `x()` without corresponding `x_init()` or `x_deinit()`. That also means that one can load any function from any library, for example `exit()` from `libc.so`. Not recommended unless you require old UDFs with one symbol that cannot be recompiled. From [MariaDB 10.10](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.10/what-is-mariadb-1010), available as a [system variable](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#allow_suspicious_udfs) as well. #### `--bootstrap` * Command line: `--bootstrap` * Description: Used by mariadb installation scripts, such as [mariadb-install-db](https://mariadb.com/docs/server/clients-and-utilities/deployment-tools/mariadb-install-db) to execute SQL scripts before any privilege or system tables exist. Do no use while an existing MariaDB instance is running. #### `--chroot` * Command line: `--chroot=name` * Description: Chroot mariadbd daemon during startup. #### `--des-key-file` * Command line: `--des-key-file=name` * Description: Load keys for [des\_encrypt()](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/des_encrypt) and des\_encrypt from given file. #### `--exit-info` * Command line: `--exit-info[=#]` * Description: Used for debugging. Use at your own risk. #### `--getopt-prefix-matching` * Command line: `--getopt-prefix-matching={0|1}` * Description: Makes it possible to disable historical "unambiguous prefix" matching in the command-line option parsing. * Default: TRUE * Introduced: [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) #### `--help` * Command line: `--help` * Description: Displays help with many commandline options described, and exits. From [MariaDB 11.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.5/what-is-mariadb-115), includes deprecation information. #### `--log-ddl-recovery` * Command line: `--log-ddl-recovery=name` * Description: Path to file used for recovery of DDL statements after a crash. * Default Value: `ddl-recover.log` * Introduced: [MariaDB 10.6.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/10.6.1) #### `--log-short-format` * Command line: `--log-short-format` * Description: Don't log extra information to update and [slow-query](https://mariadb.com/docs/server/server-management/server-monitoring-logs/slow-query-log) logs. #### `--log-slow-file` * Command line: `--log-slow-file=name` * Description: Log [slow queries](https://mariadb.com/docs/server/server-management/server-monitoring-logs/slow-query-log) to given log file. Defaults logging to hostname-slow\.log #### `--log-slow-time` * Command line: `--log-slow-time=#` * Description: Log all queries that have taken more than [long-query-time](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#long_query_time) seconds to execute to the slow query log, if active. The argument will be treated as a decimal value with microsecond precision. #### `--log-tc` * Command line: `--log-tc=name` * Description: Defines the path to the memory-mapped file-based transaction coordinator log, which is only used if the [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log) is disabled. If you have two or more XA-capable storage engines enabled, then a transaction coordinator log must be available. See [Transaction Coordinator Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/transaction-coordinator-log) for more information. Also see the [log\_tc\_size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_tc_size) system variable and the [--tc-heuristic-recover](#-tc-heuristic-recover) option. * Default Value: `tc.log` #### `--master-connect-retry` * Command line: `--master-connect-retry=#` * Description: Deprecated in 5.1.17 and removed in 5.5. The number of seconds the replica thread will sleep before retrying to connect to the master, in case the master goes down or the connection is lost. #### `--memlock` * Command line: `--memlock` * Description: Lock mariadbd in memory. #### `--ndb-use-copying-alter-table` * Command line: `--ndb-use-copying-alter-table` * Description: Force ndbcluster to always copy tables at alter table (should only be used if on-line alter table fails). #### `--one-thread` * Command line: `--one-thread` * Description: (Deprecated): Only use one thread (for debugging under Linux). Use [thread-handling=no-threads](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) instead. * Removed: [MariaDB 10.0.4](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.4) #### `--plugin-load` * Command line: `--plugin-load=name` * Description: This option can be used to configure the server to load specific [plugins](https://mariadb.com/docs/server/reference/plugins). This option uses the following format: * Plugins can be specified in the format `name=library`, where `name` is the plugin name and `library` is the plugin library. This format installs a single plugin from the given plugin library. * Plugins can also be specified in the format `library`, where `library` is the plugin library. This format installs all plugins from the given plugin library. * Multiple plugins can be specified by separating them with semicolons. * Special care must be taken when specifying the [--plugin-load](#-plugin-load) option multiple times, or when specifying both the [--plugin-load](#-plugin-load) option and the [--plugin-load-add](#-plugin-load-add) option together. The [--plugin-load](#-plugin-load) option resets the plugin load list, and this can cause unexpected problems if you are not aware. The [--plugin-load-add](#-plugin-load-add) option does not reset the plugin load list, so it is much safer to use. See [Plugin Overview: Specifying Multiple Plugin Load Options](https://mariadb.com/docs/server/reference/plugins/plugin-overview#specifying-multiple-plugin-load-options) for more information. * See [Plugin Overview: Installing a Plugin with Plugin Load Options](https://mariadb.com/docs/server/reference/plugins/plugin-overview#installing-a-plugin-with-plugin-load-options) for more information. #### `--plugin-load-add` * Command line: `--plugin-load-add=name` * Description: This option can be used to configure the server to load specific [plugins](https://mariadb.com/docs/server/reference/plugins). This option uses the following format: * Plugins can be specified in the format `name=library`, where `name` is the plugin name and `library` is the plugin library. This format installs a single plugin from the given plugin library. * Plugins can also be specified in the format `library`, where `library` is the plugin library. This format installs all plugins from the given plugin library. * Multiple plugins can be specified by separating them with semicolons. * Special care must be taken when specifying both the [--plugin-load](#-plugin-load) option and the [--plugin-load-add](#-plugin-load-add) option together. The [--plugin-load](#-plugin-load) option resets the plugin load list, and this can cause unexpected problems if you are not aware. The [--plugin-load-add](#-plugin-load-add) option does not reset the plugin load list, so it is much safer to use. See [Plugin Overview: Specifying Multiple Plugin Load Options](https://mariadb.com/docs/server/reference/plugins/plugin-overview#specifying-multiple-plugin-load-options) for more information. * See [Plugin Overview: Installing a Plugin with Plugin Load Options](https://mariadb.com/docs/server/reference/plugins/plugin-overview#installing-a-plugin-with-plugin-load-options) for more information. #### `--port-open-timeout` * Command line: `--port-open-timeout=#` * Description: Maximum time in seconds to wait for the port to become free. (Default: No wait). #### `--safe-user-create` * Command line: `--safe-user-create` * Description: Don't allow new user creation by the user who has no write privileges to the [mysql.user](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-user-table) table. #### `--safemalloc-mem-limit` * Command line: `--safemalloc-mem-limit=#` * Description: Simulate memory shortage when compiled with the `--with-debug=full` option. #### `--show-slave-auth-info` * Command line: `--show-slave-auth-info` * Description: Show user and password in [SHOW REPLICA HOSTS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-hosts) (SHOW SLAVE HOSTS) on this primary. Also added as a [system variable](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#show_slave_auth_info) in [MariaDB 12.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/12.0/what-is-mariadb-120). #### `--skip-grant-tables` * Command line: `--skip-grant-tables` * Description: Start without grant tables. This gives all users FULL ACCESS to all tables, which is useful in case of a lost root password. Use [mariadb-admin flush-privileges](https://mariadb.com/docs/server/clients-and-utilities/administrative-tools/mariadb-admin), [mariadb-admin reload](https://mariadb.com/docs/server/clients-and-utilities/administrative-tools/mariadb-admin) or [FLUSH PRIVILEGES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush) to resume using the grant tables. From [MariaDB 10.10](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.10/what-is-mariadb-1010), available as a [system variable](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#skip_grant_tables) as well. Because the [Event Scheduler](https://mariadb.com/docs/server/server-usage/triggers-events/event-scheduler) also depends on the grant tables for its functionality, it is automatically disabled when running with `--skip-grant-tables`. #### `--skip-host-cache` * Command line: `--skip-host-cache` * Description: Don't cache host names. #### `--skip-partition` * Command line: `--skip-partition`, `--disable-partition` * Description: Disables user-defined [partitioning](https://mariadb.com/docs/server/server-usage/partitioning-tables). Previously partitioned tables cannot be accessed or modifed. Tables can still be seen with [SHOW TABLES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-tables) or by viewing the [INFORMATION\_SCHEMA.TABLES table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-tables-table). Tables can be dropped with [DROP TABLE](https://mariadb.com/docs/server/server-usage/tables/drop-table), but this only removes .frm files, not the associated .par files, which will need to be removed manually. #### `--skip-slave-start` * Command line: `--skip-slave-start` * Description: If set, replica is not autostarted. From [MariaDB 12.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/12.0/what-is-mariadb-120), server will display in the log if this option is set. #### `--skip-ssl` * Command line: `--skip-ssl` * Description: Disable [TLS connections](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/secure-connections-overview). #### `--skip-symlink` * Command line: `--skip-symlink` * Description: Don't allow symlinking of tables. Deprecated and removed in [MariaDB 5.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5). Use [symbolic-links](#-symbolic-links) with the `skip` [option prefix](#option-prefixes) instead. * Removed: [MariaDB 5.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5) #### `--skip-thread-priority` * Command line: `--skip-thread-priority` * Description: Don't give threads different priorities. Deprecated and removed in [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0). * Removed: [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) #### `--sql-bin-update-same` * Command line: `--sql-bin-update-same=#` * Description: The update log was deprecated in version 5.0 and replaced by the [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log), so this option did nothing since then. Deprecated and removed in [MariaDB 5.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5). * Removed: [MariaDB 5.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5) #### `--ssl` * Command line: `--ssl` * Description: Enable [TLS for connection](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/secure-connections-overview) (automatically enabled with other flags). Disable with '`--skip-ssl`'. #### `--stack-trace` * Command line: `--stack-trace`, `--skip-stack-trace` * Description: Print a stack trace on failure. Enabled by default, disable with `-skip-stack-trace`. #### `--symbolic-links` * Command line: `--symbolic-links` * Description: Enables symbolic link support. When set, the [have\_symlink](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#have_symlink) system variable shows as `YES`. Silently ignored in Windows. Use `--skip-symbolic-links` to disable. #### `--tc-heuristic-recover` * Command line: `--tc-heuristic-recover=name` * Description: If [manual heuristic recovery](https://mariadb.com/docs/server/server-management/server-monitoring-logs/transaction-coordinator-log/heuristic-recovery-with-the-transaction-coordinator-log) is needed, this option defines the decision to use in the heuristic recovery process. Manual heuristic recovery may be needed if the [transaction coordination log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/transaction-coordinator-log) is missing or if it doesn't contain all prepared transactions. This option can be set to `OFF`, `COMMIT`, or `ROLLBACK`. The default is `OFF`. See also the [--log-tc](#-log-tc) server option and the [log\_tc\_size](https://github.com/mariadb-corporation/mariadb-docs/blob/main/server-usage/replication-cluster-multi-master/optimization-and-tuning/system-variables/server-system-variables.md#log_tc_size) system variable. #### `--temp-pool` * Command line: `--temp-pool` * Description: Using this option will cause most temporary files created to use a small set of names, rather than a unique name for each new file. This behavior works around a bug in old Linux kernels where the kernel appeared to "leak" memory. In a Docker environment it might look like an unbounded working-set memory growth.\ Defaults to `1` until [MariaDB 10.5.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.6), use `--skip-temp-pool` to disable. Defaults to `0` from [MariaDB 10.5.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.7), as benchmarking shows it causes a heavy mutex contention. #### `--test-expect-abort` * Command line: `--test-expect-abort` * Description: Expect that server aborts with 'abort'; Don't write out server variables on 'abort'. Useful only for test scripts. #### `--test-ignore-wrong-options` * Command line: `--test-ignore-wrong-options` * Description: Ignore wrong enums values in command line arguments. Useful only for test scripts. #### `--user` * Command line: `--user=name` * Description: Run mariadbd daemon as user. #### `--verbose` * Command line: `-v`, `--verbose` * Description: Used with [help](#help) option for detailed help. ## Other Options and System Variables * [allow-suspicious-udfs](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#allow-suspicious-udfs) * [automatic-sp-privileges](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#automatic_sp_privileges) * [back-log](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#back_log) * [basedir](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#basedir) * [check-constraint-checks](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#check_constraint_checks) * [column-compression-threshold](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression/storage-engine-independent-column-compression#column_compression_threshold) * [column-compression-zlib-level](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression/storage-engine-independent-column-compression#column_compression_zlib_level) * [column-compression-zlib-strategy](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression/storage-engine-independent-column-compression#column_compression_zlib_strategy) * [column-compression-zlib-wrap](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression/storage-engine-independent-column-compression#column_compression_zlib_wrap) * [completion-type](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#completion_type) * [connect-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#connect_timeout) * [datadir](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#datadir) * [date-format](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#date_format) * [datetime-format](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#datetime_format) * [deadlock-search-depth-long](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#deadlock_search_depth_long) * [deadlock-search-depth-short](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#deadlock_search_depth_short) * [deadlock-timeout-long](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#deadlock_timeout_long) * [deadlock-timeout-short](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#deadlock_timeout_short) * [default-password-lifetime](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#default_password_lifetime) * [default-regex-flags](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#default_regex_flags) * [default-storage-engine](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#default_storage_engine) * [default-table-type](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#default_table_type) * [delay-key-write](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#delay_key_write) * [disconnect-on-expired-password](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#disconnect_on_expired_password) * [div-precision-increment](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#div_precision_increment) * [enable-named-pipe](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#named_pipe) * [encrypt-binlog](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#encrypt_binlog) * [encrypt-tmp-disk-tables](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#encrypt_tmp_disk_tables) * [encrypt-tmp-files](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#encrypt_tmp_files) * [encryption-algorithm](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#encryption_algorithm) * [engine-condition-pushdown](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#engine_condition_pushdown) * [eq-range-index-dive-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#eq_range_index_dive_limit) * [event-scheduler](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#event_scheduler) * [expire-logs-days](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#expire_logs_days) * [explicit-defaults-for-timestamp](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#explicit_defaults_for_timestamp) * [extra-max-connections](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [extra-port](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [flush](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#flush) * [flush-time](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#flush_time) * [ft-boolean-syntax](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#ft_boolean_syntax) * [ft-max-word-len](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#ft_max_word_len) * [ft-min-word-len](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#ft_min_word_len) * [ft-query-expansion-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#ft_query_expansion_limit) * [ft-stopword-file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#ft_stopword_file) * [general-log](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#general_log) * [general-log-file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#general_log_file) * [group-concat-max-len](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#group_concat_max_len) * [histogram-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#histogram_size) * [histogram-type](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#histogram_type) * [host-cache-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#host_cache_size) * [idle-readonly-transaction-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#idle_readonly_transaction_timeout) * [idle-transaction-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#idle_transaction_timeout) * [idle-write-transaction-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#idle_write_transaction_timeout) * [ignore-db-dirs](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#ignore_db_dirs) * [in-predicate-conversion-threshold](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#in_predicate_conversion_threshold) * [init-connect](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#init_connect) * [init-file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#init_file) * [interactive-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#interactive_timeout) * [large-pages](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#large_pages) * [local-infile](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#local_infile) * [lock-wait-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#lock_wait_timeout) * [log](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log) * [log-disabled-statements](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_disabled_statements) * [log-error](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_error) * [log-output](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_output) * [log-queries-not-using-indexes](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_queries_not_using_indexes) * [log-slow-admin-statements](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_admin_statements) * [log-slow-always-query-time](https://mariadb.com/docs/server/server-management/server-monitoring-logs/slow-query-log/log_slow_always_query_time-system-variable) * [log-slow-disabled-statements](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_disabled_statements) * [log-slow-filter](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_filter) * [log-slow-min-examined-row-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_min_examined_row_limit) * [log-slow-queries](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_queries) * [log-slow-query](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_query) * [log-slow-query-file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_query_file) * [log-slow-query-time](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_query_time) * [log-slow-rate-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_rate_limit) * [log-slow-slave-statements](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#log_slow_slave_statements) * [log-slow-verbosity](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_slow_verbosity) * [log-tc-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_tc_size) * [log-warnings](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_warnings) * [long-query-time](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#long_query_time) * [low-priority-updates](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#low_priority_updates) * [lower-case-table-names](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#lower_case_table_names) * [max-allowed-packet](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_allowed_packet) * [max-connections](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_connections) * [max-connect-errors](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_connect_errors) * [max-delayed-threads](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_delayed_threads) * [max-digest-length](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_digest_length") * [max-error-count](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_error_count) * [max-length-for-sort-data](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_length_for_sort_data) * [max-long-data-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_long_data_size) * [max\_open\_cursors](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_open_cursors) * [max-password-errors](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_password_errors) * [max-prepared-stmt-count](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_prepared_stmt_count) * [max-recursive-iterations](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_recursive_iterations) * [max-rowid-filter-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_rowid_filter_size) * [max-session-mem-used](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_session_mem_used) * [max-sp-recursion-depth](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_sp_recursion_depth) * [max-statement-time](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_statement_time) * [max-tmp-session-space-usage](https://mariadb.com/docs/server/security/limiting-size-of-created-disk-temporary-files-and-tables/max_tmp_session_space_usage-system-variable) * [max-tmp-tables](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_tmp_tables) * [max-tmp-total-space-usage](https://mariadb.com/docs/server/security/limiting-size-of-created-disk-temporary-files-and-tables/max_tmp_total_space_usage-system-variable) * [max-user-connections](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_user_connections) * [max-write-lock-count](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#max_write_lock_count) * [metadata-locks-cache-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#metadata_locks_cache_size) * [metadata-locks-hash-instances](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#metadata_locks_hash_instances) * [metadata-locks-instances](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#metadata_locks_instances) * [min-examined-row-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#min_examined_row_limit) * [mrr-buffer-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#mrr_buffer_size) * [multi-range-count](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#multi_range_count) * [--mysql56-temporal-format](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#mysql56_temporal_format) * [net-buffer-length](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#net_buffer_length) * [net-read-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#net_read_timeout) * [net-retry-count](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#net_retry_count) * [net-write-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#net_write_timeout) * [open-files-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#open_files_limit) * [pid-file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#pid_file) * [plugin-dir](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#plugin_dir) * [plugin-maturity](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#plugin_maturity) * [port](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#port) * [preload-buffer-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#preload_buffer_size) * [profiling-history-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#profiling_history_size) * [progress-report-time](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#progress_report_time) * [proxy-protocol-networks](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#proxy_protocol_networks) * [query-cache-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#query_cache_limit) * [query-cache-min-res-unit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#query_cache_min_res_unit) * [query-cache-strip-comments](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#query_cache_strip_comments) * [query-cache-wlock-invalidate](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#query_cache_wlock_invalidate) * [read-rnd-buffer-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#read_rnd_buffer_size) * [read-only](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#read_only) * [redirect-url](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#redirect_url) * [require-secure-transport](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#require_secure_transport) * [safe-show-database](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#safe_show_database) * [secure-auth](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#secure_auth) * [secure-file-priv](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#secure_file_priv) * [secure-timestamp](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#secure_timestamp) * [session-track-schema](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#session_track_schema) * [session-track-state-change](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#session_track_state_change) * [session-track-system-variables](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#session_track_system_variables) * [session-track-transaction-info](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#session_track_transaction_info) * [skip-automatic-sp-privileges](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#automatic_sp_privileges) * [skip-external-locking](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#skip_external_locking) * [skip-large-pages](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#large_pages) * [skip-log-error](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#log_error) * [skip-name-resolve](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#skip_name_resolve) * [skip-networking](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#skip_networking) * [skip-show-database](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#skip_show_database) * [slow-launch-time](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#slow_launch_time) * [slow-query-log](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#slow_query_log) * [slow-query-log-file](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#slow_query_log_file) * [socket](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#socket) * [sort-buffer-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#sort_buffer_size) * [sql-if-exists](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#sql_if_exists) * [sql-mode](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#sql_mode) * [ssl-ca](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables) * [ssl-capath](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables) * [ssl-cert](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables) * [ssl-cipher](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables) * [ssl-crl](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables) * [ssl-crlpath](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables) * [ssl-key](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables) * [ssl-passphrase](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables#ssl_passphrase) * [standards\_compliant\_cte](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#standards_compliant_cte) * [stored-program-cache](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#stored_program_cache) * [strict\_password\_validation](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#strict_password_validation) * [sync-frm](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#sync_frm) * [system-versioning-alter-history](https://mariadb.com/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables#system_versioning_alter_history) * [system-versioning-asof](https://mariadb.com/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables#system_versioning_asof) * [system-versioning-innodb-algorithm-simple](https://mariadb.com/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables#system_versioning_innodb_algorithm_simple) * [system-versioning-insert-history](https://mariadb.com/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables#system_versioning_insert_history) * [table-lock-wait-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#table_lock_wait_timeout) * [tcp-keepalive-interval](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#tcp_keepalive_interval) * [tcp-keepalive-probes](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#tcp_keepalive_probes) * [tcp-keepalive-time](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#tcp_keepalive_time) * [tcp-nodelay](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#tcp_nodelay) * [thread-cache-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#thread_cache_size) * [thread-concurrency](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#thread_concurrency) * [thread-handling](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#thread_handling) * [thread-pool-dedicated-listener](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [thread-pool-exact-stats](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [thread-pool-idle-timeout](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [thread-pool-max-threads](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [thread-pool-min-threads](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [thread-pool-oversubscribe](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [thread-pool-prio-kickup-timer](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [thread-pool-priority](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [thread-pool-size](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [thread-pool-stall-limit](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) * [thread-stack](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#thread_stack) * [timed-mutexes](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#timed_mutexes) * [time-format](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#time_format) * [tls-version](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables) * [tmpdir](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#tmpdir) * [transaction-isolation](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#tx_isolation) * [transaction-alloc-block-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#transaction_alloc_block_size) * [transaction-prealloc-size](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#transaction_prealloc_size) * [transaction-read-only](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#tx_read_only) * [updatable-views-with-limit](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#updatable_views_with_limit) * [userstat](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#userstat) * [version](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#version) * [wait-timeout](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#wait_timeout) ## Authentication Plugins - Options and System Variables ### Authentication Plugin - `ed25519` The options related to the [ed25519](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-plugin-ed25519) authentication plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-plugin-ed25519#options). ### Authentication Plugin - `gssapi` The system variables related to the [gssapi](https://mariadb.com/docs/server/security/authentication-with-enterprise-server/authentication-with-gssapi) authentication plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-plugin-gssapi#system-variables). The options related to the [gssapi](https://mariadb.com/docs/server/security/authentication-with-enterprise-server/authentication-with-gssapi) authentication plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-plugin-gssapi#options). ### Authentication Plugin - `named_pipe` The options related to the [named\_pipe](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#named_pipe) authentication plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-plugin-named-pipe#options). ### Authentication Plugin - `pam` The system variables related to the [pam](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-with-pluggable-authentication-modules-pam/authentication-plugin-pam) authentication plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-with-pluggable-authentication-modules-pam/authentication-plugin-pam#system-variables). The options related to the [pam](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-with-pluggable-authentication-modules-pam/authentication-plugin-pam) authentication plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-with-pluggable-authentication-modules-pam/authentication-plugin-pam#options). ### Authentication Plugin - `unix_socket` The options related to the [unix\_socket](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-plugin-unix-socket) authentication plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-plugin-unix-socket#options). ## Encryption Plugins - Options and System Variables ### Encryption Plugin - `aws_key_management` The system variables related to the [aws\_key\_management](https://mariadb.com/docs/server/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/aws-key-management-encryption-plugin) encryption plugin can be found [here](https://mariadb.com/docs/server/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/aws-key-management-encryption-plugin#system-variables). The options elated to the [aws\_key\_management](https://mariadb.com/docs/server/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/aws-key-management-encryption-plugin) encryption plugin can be found [here](https://mariadb.com/docs/server/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/aws-key-management-encryption-plugin#options). ### Encryption Plugin - `file_key_management` The system variables related to the [file\_key\_management](https://mariadb.com/docs/server/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/file-key-management-encryption-plugin) encryption plugin can be found [here](https://mariadb.com/docs/server/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/file-key-management-encryption-plugin#system-variables). The options related to the [file\_key\_management](https://mariadb.com/docs/server/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/file-key-management-encryption-plugin) encryption plugin can be found [here](https://mariadb.com/docs/server/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/file-key-management-encryption-plugin#options). ## Password Validation Plugins - Options and System Variables ### Password Validation Plugin - `simple_password_check` The system variables related to the c password validation plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/password-validation-plugins/simple-password-check-plugin). The options related to the [simple\_password\_check](https://mariadb.com/docs/server/reference/plugins/password-validation-plugins/simple-password-check-plugin) password validation plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/password-validation-plugins/simple-password-check-plugin). ### Password Validation Plugin - `cracklib_password_check` The system variables related to the [cracklib\_password\_check](https://mariadb.com/docs/server/reference/plugins/password-validation-plugins/cracklib-password-check-plugin) password validation plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/password-validation-plugins/cracklib-password-check-plugin). The options related to the [cracklib\_password\_check](https://mariadb.com/docs/server/reference/plugins/password-validation-plugins/cracklib-password-check-plugin) password validation plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/password-validation-plugins/simple-password-check-plugin#options). ## Audit Plugins - Options and System Variables ### Audit Plugin - `server_audit` Options and system variables related to the [server\_audit](https://mariadb.com/docs/server/reference/plugins/mariadb-audit-plugin/mariadb-audit-plugin-options-and-system-variables#server_audit) audit plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/mariadb-audit-plugin/mariadb-audit-plugin-options-and-system-variables). ### Audit Plugin - `SQL_ERROR_LOG` The options and system variables related to the [SQL\_ERROR\_LOG](https://mariadb.com/docs/server/server-management/server-monitoring-logs/sql-error-log-plugin) audit plugin can be found [here](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/sql-error-log-system-variables-and-options#system-variables). ### Audit Plugin - QUERY\_RESPONSE\_TIME\_AUDIT The options related to the [QUERY\_RESPONSE\_TIME\_AUDIT](https://mariadb.com/docs/server/reference/plugins/other-plugins/query-response-time-plugin#query_response_time_audit) audit plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/other-plugins/query-response-time-plugin#options). ## Daemon Plugins - Options and System Variables ### Daemon Plugin - `handlersocket` The options for the HandlerSocket plugin are all described on the [HandlerSocket Configuration Option](https://mariadb.com/docs/server/reference/sql-structure/nosql/handlersocket/handlersocket-configuration-options) page. ## Information Schema Plugins - Options and System Variables ### Information Schema Plugin - `DISKS` The options related to the [DISKS](https://mariadb.com/docs/server/reference/plugins/other-plugins/disks-plugin) information schema plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/other-plugins/disks-plugin#options). ### Information Schema Plugin - `feedback` The system variables related to the [feedback](https://mariadb.com/docs/server/reference/plugins/other-plugins/feedback-plugin) plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/other-plugins/feedback-plugin#system-variables). The options related to the [feedback](https://mariadb.com/docs/server/reference/plugins/other-plugins/feedback-plugin) plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/other-plugins/feedback-plugin#options). ### Information Schema Plugin - `LOCALES` The options related to the [LOCALES](https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/internationalization-and-localization/locales-plugin) information schema plugin can be found [here](https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/internationalization-and-localization/locales-plugin#options). ### Information Schema Plugin - `METADATA_LOCK_INFO` The options related to the [METADATA\_LOCK\_INFO](https://mariadb.com/docs/server/reference/plugins/other-plugins/metadata-lock-info-plugin) information schema plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/other-plugins/metadata-lock-info-plugin). ### Information Schema Plugin - `QUERY_CACHE_INFO` The options related to the [QUERY\_CACHE\_INFO](https://mariadb.com/docs/server/reference/plugins/other-plugins/query-cache-information-plugin) information schema plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/other-plugins/query-cache-information-plugin#options). ### Information Schema Plugin - `QUERY_RESPONSE_TIME` The system variables related to the [QUERY\_RESPONSE\_TIME](https://mariadb.com/docs/server/reference/plugins/other-plugins/query-response-time-plugin) information schema plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/other-plugins/query-response-time-plugin#system-variables). The options related to the [QUERY\_RESPONSE\_TIME](https://mariadb.com/docs/server/reference/plugins/other-plugins/query-response-time-plugin) information schema plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/other-plugins/query-response-time-plugin#options). ### Information Schema Plugin - `user_variables` The options related to the [user\_variables](https://mariadb.com/docs/server/reference/plugins/other-plugins/user-variables-plugin) information schema plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/other-plugins/user-variables-plugin#options). ### Information Schema Plugin - `WSREP_MEMBERSHIP` The options related to the [WSREP\_MEMBERSHIP](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_membership-table) information schema plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/mariadb-replication-cluster-plugins/wsrep_info-plugin#options). ### Information Schema Plugin - `WSREP_STATUS` The options related to the [WSREP\_STATUS](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_status-table) information schema plugin can be found [here](https://mariadb.com/docs/server/reference/plugins/mariadb-replication-cluster-plugins/wsrep_info-plugin#options). ## Replication Plugins - Options and System Variables ### Replication Plugin - `rpl_semi_sync_master` The system variables related to the [rpl\_semi\_sync\_master](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication#rpl-semi-sync_master) replication plugin can be found [here](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication#system-variables). The options related to the [rpl\_semi\_sync\_master](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication#rpl-semi-sync_master) replication plugin can be found [here](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication#options). ### Replication Plugin - `rpl_semi_sync_slave` The system variables related to the [rpl\_semi\_sync\_slave](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication#rpl-semi-sync_slave) replication plugin can be found [here](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication#system-variables). The options related to the [rpl\_semi\_sync\_slave](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication#rpl-semi-sync_slave) replication plugin can be found [here](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication#options). ## Default Values You can verify the default values for an option by doing: ``` mariadbd --no-defaults --help --verbose ``` *This page is licensed: GPLv2* {% @marketo/form formId="4316" %}