A reference list of command-line options available for the `mariadbd` server binary, covering configuration, replication, and service installation.
This page lists all of the options for mariadbd (called mysqld before ), 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.
In many cases, the entry here is a summary, and links to the full description.
By convention, server 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 for which files and groups mariadbd reads for it's default options.
--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.
--defaults-extra-fileCommand line: --defaults-extra-file=name
Description: Read this extra option file after all other option files are read.
See .
--defaults-fileCommand line: --defaults-file=name
Description: Only read options from the given option file.
See .
--defaults-group-suffixCommand line: --defaults-group-suffix=name
Description: In addition to the default option groups, also read option groups with the given suffix.
See .
--no-defaultsCommand line: --no-defaults
Description: Don't read options from any option file.
See .
--print-defaultsCommand line: --print-defaults
Description: Read options from option files, print all option values, and then exit the program.
See .
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, --ansiDescription: Use ANSI SQL syntax instead of MariaDB syntax. This mode will also set .
--newDescription: 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-limitsDescription: Enable old-style user limits (before MySQL 5.0.3, user resources were counted per each user+host vs. per account).
--safe-modeDescription: Disable some potential unsafe optimizations. For 5.2, is disabled, is set to DEFAULT (automatically recover crashed MyISAM files) and the is disabled. For tables, disable bulk insert optimization to enable one to use to recover tables even if tables are deleted (good for testing recovery).
--skip-newDescription: Disables .
Options that are also system variables are listed after:
--character-set-client-handshakeCommand 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-setCommand 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 as a server option. Use instead.
--languageDescription: 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 . See for a list of supported locales and their associated languages.
This option is deprecated. Use the and system variables instead.
See for more information.
Options that are also system variables are listed after:
--consoleDescription: Windows-only option that keeps the console window open and for writing log messages to stderr and stdout. If specified together with , the last option will take precedence.
--installDescription: Windows-only option that installs the mariadbd process as a Windows service.
The Windows service created with this option . If you want a service that is started on demand, then use the 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".
--install-manualDescription: 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 , use the 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".
--removeDescription: Windows-only option that removes the Windows service created by the or 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 for more information.
--slow-start-timeoutDescription: 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.
--standaloneDescription: Windows-only option that has no effect. Kept for compatibility reasons.
The following options and system variables are related to using MariaDB on Windows:
The following options are related to and the . Options that are also system variables are listed after:
--abort-slave-event-countCommand line: --abort-slave-event-count=#
Description: Option used by mysql-test for debugging and testing of replication.
--binlog-do-dbCommand line: --binlog-do-db=name
Description: This option allows you to configure a to write statements and transactions affecting databases that match a specified name into its . Since the filtered statements or transactions will not be present in the , its replicas will not be able to replicate them.
This option will not work with cross-database updates with . See the section for more information.
--binlog-ignore-dbCommand line: --binlog-ignore-db=name
Description: This option allows you to configure a to not write statements and transactions affecting databases that match a specified name into its . Since the filtered statements or transactions will not be present in the , its replicas will not be able to replicate them.
This option will not work with cross-database updates with . See the section for more information.
--binlog-row-event-max-sizeCommand line: --binlog-row-event-max-size=#
Description: The maximum size of a row-based 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 from .
Default value 8192
--disconnect-slave-event-countCommand line: --disconnect-slave-event-count=#
Description: Option used by mysql-test for debugging and testing of replication.
--flashbackCommand line: --flashback
Description: Setup the server to use flashback. This enables the and sets binlog_format=ROW.
--init-rpl-roleCommand line: --init-rpl-role=name
Description: Set the replication role. From , , , , and , changes the condition for to truncate the to instead use this option, when set to SLAVE. This allows for both and to be set for a primary that is restarted, and no transactions will be lost, so long as --init-rpl-role is not set to SLAVE. In earlier versions, for servers configured with both and , if a primary is just re-started (i.e. retaining its role as primary), it can truncate its binlog to drop transactions which its replica(s) have already received and executed. If this happens, when the replica reconnects, its can be ahead of the recovered primary’s , resulting in an error state where the replica’s state is ahead of the primary’s.
--log-basenameCommand 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 as it ensures that your log file names are not dependent on your host name. Sets names for the , , , and . Note that if you explicity set log file names with any of these other options; , , , , (), , and , 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-creatorsCommand line: --log-bin-trust-routine-creators
Description: Deprecated, use .
--master-hostCommand 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-fileCommand 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 position on the primary) and most other options are written. The keeps this position updated as it downloads events.
See
--master-passwordCommand 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-portCommand 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-countCommand 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 .
Default Value: 86400 through 10.5, 100000 as of 10.6
--master-sslCommand line: --master-ssl
Description: Enable the replica to .
--master-ssl-caCommand line: --master-ssl-ca[=name]
Description: Master TLS CA file. Only applies if you have enabled .
--master-ssl-capathCommand line: --master-ssl-capath[=name]
Description: Master TLS CA path. Only applies if you have enabled .
--master-ssl-certCommand line: --master-ssl-cert[=name]
Description: Master TLS certificate file name. Only applies if you have enabled .
--master-ssl-cipherCommand line: --master-ssl-cipher[=name]
Description: Master TLS cipher. Only applies if you have enabled .
--master-ssl-keyCommand line: --master-ssl-key[=name]
Description: Master TLS keyfile name. Only applies if you have enabled .
--master-userCommand 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-eventsCommand line: --max-binlog-dump-events=#
Description: Option used by mysql-test for debugging and testing of replication.
--replicate-same-server-idCommand 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 is used. Added as a in .
--sporadic-binlog-dump-failCommand line: --sporadic-binlog-dump-fail
Description: Option used by mysql-test for debugging and testing of replication.
--sysdate-is-nowCommand line: --sysdate-is-now
Description: Non-default option to alias to to make it safe for . Since 5.0, SYSDATE() has returned a `dynamic' value different for different invocations, even within the same statement.
The options and system variables related to and are described on .
The options and system variables related to are described .
Options that are also system variables are listed after:
--record-bufferCommand line: --record-buffer=#
Description: Old alias for .
Removed:
--table-cacheCommand line: --table-open-cache=#
Description: Removed; use instead.
Removed:
--skip-bdbCommand line: ----skip-bdb
Description: Deprecated option; Exists only for compatibility with very old my.cnf files.
Removed:
--external-lockingCommand line: --external-locking
Description: Use system (external) locking (disabled by default). With this option enabled you can run to test (not repair) tables while the server is running. Disable with . From , , , , and all later version, this effects InnoDB and can be used to prevent multiple instances running on the same data.
The options related to the storage engine are described below. Options that are also system variables are listed after:
--log-isamCommand line: --log-isam[=file_name]
Description: Enable the , which logs all MyISAM changes to file. If no filename is provided, the default, myisam.log is used.
Some options and system variables related to the storage engine can be found . Direct links to many of them can be found below.
The options related to the storage engine are described below. Options that are also system variables are listed after:
--innodbCommand 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 ). 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
--innodb-cmpCommand line: --innodb-cmp
Description:
Default: ON
--innodb-cmp-resetCommand line: --innodb-cmp-reset
Description:
Default: ON
--innodb-cmpmemCommand line: --innodb-cmpmem
Description:
Default: ON
--innodb-cmpmem-resetCommand line: --innodb-cmpmem-reset
Description:
Default: ON
--innodb-file-io-threadsCommand line: --innodb-file-io-threads
Description:
Default: 4
Removed:
--innodb-index-statsCommand line: --innodb-index-stats
Description:
Default: ON
Removed:
--innodb-lock-waitsCommand line: --innodb-lock-waits
Description:
Default: ON
--innodb-locksCommand line: --innodb-locks
Description:
Default: ON
--innodb-rsegCommand line: --innodb-rseg
Description:
Default: ON
Removed:
--innodb-status-fileCommand line: --innodb-status-file
Description:
Default: FALSE
--innodb-sys-indexesCommand line: --innodb-sys-indexes
Description:
Default: ON
--innodb-sys-statsCommand line: --innodb-sys-stats
Description:
Default: ON
Removed:
--innodb-sys-tablesCommand line: --innodb-sys-tables
Description:
Default: ON
--innodb-table-statsCommand line: --innodb-table-stats
Description:
Default: ON
Removed:
--innodb-trxCommand line: --innodb-trx
Description:
Default: ON
Some options and system variables related to the storage engine can be found . Direct links to many of them can be found below.
Options related to the storage engine are listed below:
Some options and system variables related to the storage engine can be found . Direct links to many of them can be found below.
The options and system variables related to the storage engine can be found .
The options and system variables related to the storage engine can be found .
The options related to the storage engine are described below.
Some options and system variables related to the storage engine can be found . Direct links to many of them can be found below.
The options and system variables related to the storage engine can be found .
The options and system variables related to the storage engine can be found .
The options and system variables related to the storage engine can be found .
The options and system variables related to storage engine (beginning with mhnsw) can be found .
The options related to the are described below. Options that are also system variables are listed after:
--performance-schema-consumer-events-stages-currentCommand line: --performance-schema-consumer-events-stages-current
Description: Enable the consumer.
Default: OFF
--performance-schema-consumer-events-stages-historyCommand line: --performance-schema-consumer-events-stages-history
Description: Enable the consumer.
Default: OFF
--performance-schema-consumer-events-stages-history-longCommand line: --performance-schema-consumer-events-stages-history-long
Description: Enable the consumer.
Default: OFF
--performance-schema-consumer-events-statements-currentCommand line: --performance-schema-consumer-events-statements-current
Description: Enable the consumer. Use --skip-performance-schema-consumer-events-statements-current to disable.
Default: ON
--performance-schema-consumer-events-statements-historyCommand line: --performance-schema-consumer-events-statements-history
Description: Enable the consumer.
Default: OFF
--performance-schema-consumer-events-statements-history-longCommand line: --performance-schema-consumer-events-statements-history-long
Description: Enable the consumer.
Default: OFF
--performance-schema-consumer-events-waits-currentCommand line: --performance-schema-consumer-events-waits-current
Description: Enable the consumer.
Default: OFF
--performance-schema-consumer-events-waits-historyCommand line: --performance-schema-consumer-events-waits-history
Description: Enable the consumer.
Default: OFF
--performance-schema-consumer-events-waits-history-longCommand line: --performance-schema-consumer-events-waits-history-long
Description: Enable the consumer.
Default: OFF
--performance-schema-consumer-global-instrumentationCommand 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-digestCommand 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-instrumentationCommand line: --performance-schema-consumer-thread-instrumentation
Description: Enable the statements-thread-instrumentation. Use --skip-performance-schema-thread-instrumentation to disable.
Default: ON
Some options and system variables related to the can be found . Direct links to many of them can be found below.
The options related to are described below. Options that are also system variables are listed after:
--wsrep-new-clusterCommand 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.
Some options and system variables related to can be found . Direct links to many of them can be found below.
--debug-assert-if-crashed-tableDescription: Do an assert in handler::print_error() if we get a crashed table.
--debug-binlog-fsync-sleepDescription: --debug-binlog-fsync-sleep=#If not set to zero, sets the number of micro-seconds to sleep after running fsync() on the to flush transactions to disk. This can thus be used to artificially increase the perceived cost of such an fsync().
--debug-crc-breakDescription: --debug-crc-break=#Call my_debug_put_break_here() if crc matches this number (for debug).
--debug-flushDescription: Default debug log with flush after write.
--debug-no-syncDescription: debug-no-sync[=#]Disables system sync calls. Only for running tests or debugging!
--debug-sync-timeoutDescription: debug-sync-timeout[=#]Enable the debug sync facility and optionally specify a default wait timeout in seconds. A zero value keeps the facility disabled.
--gdbDescription: Set up signals usable for debugging.
--silent-startupDescription: Don't print Notes to the during startup.
--sync-sysDescription: Enable/disable system sync calls. Syncs should only be turned off (--disable-sync-sys) when running tests or debugging! Replaced by from .
Removed:
--thread-alarmDescription: Enable/disable system thread alarm calls. Should only be turned off (--disable-thread-alarm) when running tests or debugging!
Options that are also system variables are listed after:
--allow-suspicious-udfsCommand line: --allow-suspicious-udfs
Description: Allows use of 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 , available as a as well.
--bootstrapCommand line: --bootstrap
Description: Used by mariadb installation scripts, such as to execute SQL scripts before any privilege or system tables exist. Do no use while an existing MariaDB instance is running.
--chrootCommand line: --chroot=name
Description: Chroot mariadbd daemon during startup.
--des-key-fileCommand line: --des-key-file=name
Description: Load keys for and des_encrypt from given file.
--exit-infoCommand line: --exit-info[=#]
Description: Used for debugging. Use at your own risk.
--getopt-prefix-matchingCommand 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:
--helpCommand line: --help
Description: Displays help with many commandline options described, and exits. From , includes deprecation information.
--log-ddl-recoveryCommand line: --log-ddl-recovery=name
Description: Path to file used for recovery of DDL statements after a crash.
Default Value: ddl-recover.log
Introduced:
--log-short-formatCommand line: --log-short-format
Description: Don't log extra information to update and logs.
--log-slow-fileCommand line: --log-slow-file=name
Description: Log to given log file. Defaults logging to hostname-slow.log
--log-slow-timeCommand line: --log-slow-time=#
Description: Log all queries that have taken more than seconds to execute to the slow query log, if active. The argument will be treated as a decimal value with microsecond precision.
--log-tcCommand line: --log-tc=name
Description: Defines the path to the memory-mapped file-based transaction coordinator log, which is only used if the is disabled. If you have two or more XA-capable storage engines enabled, then a transaction coordinator log must be available. See for more information. Also see the system variable and the option.
Default Value: tc.log
--master-connect-retryCommand 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.
--memlockCommand line: --memlock
Description: Lock mariadbd in memory.
--ndb-use-copying-alter-tableCommand 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-threadCommand line: --one-thread
Description: (Deprecated): Only use one thread (for debugging under Linux). Use instead.
Removed:
--plugin-loadCommand line: --plugin-load=name
Description: This option can be used to configure the server to load specific . This option uses the following format:
Plugins can be specified in the format name=library, where name is the plugin name and library
--plugin-load-addCommand line: --plugin-load-add=name
Description: This option can be used to configure the server to load specific . This option uses the following format:
Plugins can be specified in the format name=library, where name is the plugin name and library
--port-open-timeoutCommand line: --port-open-timeout=#
Description: Maximum time in seconds to wait for the port to become free. (Default: No wait).
--safe-user-createCommand line: --safe-user-create
Description: Don't allow new user creation by the user who has no write privileges to the table.
--safemalloc-mem-limitCommand line: --safemalloc-mem-limit=#
Description: Simulate memory shortage when compiled with the --with-debug=full option.
--show-slave-auth-infoCommand line: --show-slave-auth-info
Description: Show user and password in (SHOW SLAVE HOSTS) on this primary. Also added as a in .
--skip-grant-tablesCommand 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 , or to resume using the grant tables. From , available as a as well.
Because the also depends on the grant tables for its functionality, it is automatically disabled when running with --skip-grant-tables.
--skip-host-cacheCommand line: --skip-host-cache
Description: Don't cache host names.
--skip-partitionCommand line: --skip-partition, --disable-partition
Description: Disables user-defined . Previously partitioned tables cannot be accessed or modifed. Tables can still be seen with or by viewing the . Tables can be dropped with , but this only removes .frm files, not the associated .par files, which will need to be removed manually.
--skip-slave-startCommand line: --skip-slave-start
Description: If set, replica is not autostarted. From , server will display in the log if this option is set.
--skip-sslCommand line: --skip-ssl
Description: Disable .
--skip-symlinkCommand line: --skip-symlink
Description: Don't allow symlinking of tables. Deprecated and removed in . Use with the skip instead.
Removed:
--skip-thread-priorityCommand line: --skip-thread-priority
Description: Don't give threads different priorities. Deprecated and removed in .
Removed:
--sql-bin-update-sameCommand line: --sql-bin-update-same=#
Description: The update log was deprecated in version 5.0 and replaced by the , so this option did nothing since then. Deprecated and removed in .
Removed:
--sslCommand line: --ssl
Description: Enable (automatically enabled with other flags). Disable with '--skip-ssl'.
--stack-traceCommand line: --stack-trace, --skip-stack-trace
Description: Print a stack trace on failure. Enabled by default, disable with -skip-stack-trace.
--symbolic-linksCommand line: --symbolic-links
Description: Enables symbolic link support. When set, the system variable shows as YES. Silently ignored in Windows. Use --skip-symbolic-links to disable.
--tc-heuristic-recoverCommand line: --tc-heuristic-recover=name
Description: If is needed, this option defines the decision to use in the heuristic recovery process. Manual heuristic recovery may be needed if the 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 server option and the system variable.
--temp-poolCommand 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 , use --skip-temp-pool to disable. Defaults to 0 from , as benchmarking shows it causes a heavy mutex contention.
--test-expect-abortCommand 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-optionsCommand line: --test-ignore-wrong-options
Description: Ignore wrong enums values in command line arguments. Useful only for test scripts.
--userCommand line: --user=name
Description: Run mariadbd daemon as user.
--verboseCommand line: -v, --verbose
Description: Used with option for detailed help.
ed25519The options related to the authentication plugin can be found .
gssapiThe system variables related to the authentication plugin can be found .
The options related to the authentication plugin can be found .
named_pipeThe options related to the authentication plugin can be found .
pamThe system variables related to the authentication plugin can be found .
The options related to the authentication plugin can be found .
unix_socketThe options related to the authentication plugin can be found .
aws_key_managementThe system variables related to the encryption plugin can be found .
The options elated to the encryption plugin can be found .
file_key_managementThe system variables related to the encryption plugin can be found .
The options related to the encryption plugin can be found .
simple_password_checkThe system variables related to the c password validation plugin can be found .
The options related to the password validation plugin can be found .
cracklib_password_checkThe system variables related to the password validation plugin can be found .
The options related to the password validation plugin can be found .
server_auditOptions and system variables related to the audit plugin can be found .
SQL_ERROR_LOGThe options and system variables related to the audit plugin can be found .
The options related to the audit plugin can be found .
handlersocketThe options for the HandlerSocket plugin are all described on the page.
DISKSThe options related to the information schema plugin can be found .
feedbackThe system variables related to the plugin can be found .
The options related to the plugin can be found .
LOCALESThe options related to the information schema plugin can be found .
METADATA_LOCK_INFOThe options related to the information schema plugin can be found .
QUERY_CACHE_INFOThe options related to the information schema plugin can be found .
QUERY_RESPONSE_TIMEThe system variables related to the information schema plugin can be found .
The options related to the information schema plugin can be found .
user_variablesThe options related to the information schema plugin can be found .
WSREP_MEMBERSHIPThe options related to the information schema plugin can be found .
WSREP_STATUSThe options related to the information schema plugin can be found .
rpl_semi_sync_masterThe system variables related to the replication plugin can be found .
The options related to the replication plugin can be found .
rpl_semi_sync_slaveThe system variables related to the replication plugin can be found .
The options related to the replication plugin can be found .
You can verify the default values for an option by doing:
This page is licensed: GPLv2
This option can not be set dynamically. Available as a system variable from .
When setting it on the command-line or in a server option group in an option file, 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 for more information.
This option can not be set dynamically. Available as a system variable from .
When setting it on the command-line or in a server option group in an option file, 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 for more information.
Default value: MASTER
Valid values: Empty, MASTER or SLAVE
Range - 32 bit: 0 to 4294967295
Range - 64 bit: 0 to 18446744073709551615
FORCEFORCE_PLUS_PERMANENTskip-innodb
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 option multiple times, or when specifying both the --plugin-load option and the --plugin-load-add option together. The --plugin-load option resets the plugin load list, and this can cause unexpected problems if you are not aware. The --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 for more information.
See Plugin Overview: Installing a Plugin with Plugin Load Options for more information.
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 option and the --plugin-load-add option together. The --plugin-load option resets the plugin load list, and this can cause unexpected problems if you are not aware. The --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 for more information.
See Plugin Overview: Installing a Plugin with Plugin Load Options for more information.
mariadbd --no-defaults --help --verbose