The Ultimate Guide to High Availability with MariaDB

mysqld startup options

You are viewing an old version of this article. View the current version here.

Here follows a list of the different mysqld startup options you can use.

Note: This article is not yet complete.

mysqld reads the following my.cnf sections: [mysqld] [server] [mysqld-5.1].
In addition MariaDB also reads the sections: [mariadb] [mariadb-5.1].
The 5.1 stands for the main version, the above is for MariaDB 5.1.

For a full list of options, do:

mysqld --help --verbose

Global options:

The following options to handle option files may be given as the first argument:

--print-defaultsPrint the program argument list and exit.
--no-defaultsDon't read default options from any option file.
--defaults-file=#Only read default options from the given file #.
--defaults-extra-file=#Read this file after the global files are read.

The following options is to make MariaDB be more complaint with other MariaDB versions:

--newUse new functionality that will exist in next version of MariaDB. This function exist to make it easier to prepare for an upgrade. For version 5.1 this functions enables the LIST and RANGE partitions functions for ndbcluster.
--oldUse compatible behavior with previous main version for some functionality. For MariaDB 5.1 this means that we are using the old, MySQL 5.1 compatible, way to calculate checksums for records. If you are using --old, CHECKSUM TABLE will always do a full table scan.
--safe_modeDisable some potential unsafe optimization. For 5.2 these are: INSERT DELAYED is disabled, myisam_recover_options is set to DEFAULT (automatically recover crashed MyISAM files). For Aria table, disable bulk insert optimization to enable one to use maria_read_log to recover tables even if tables are deleted (good for testing recovery).
--skip-newSkip some new potentially unsafe functions. For 5.2 these are: INSERT DELAYED is disabled, Query cache size is reset.

More information to appear shortly...

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.