mysqld Configuration Files and Groups
Default options are generally read from the following files in the given order:
DEFAULT_SYSCONFDIRspecified during the compilation
my.cnfin the path, specified in the environment variable
- the file specified in
For an exact list for your system execute
mysqld --help --verbose. The full file list will be near the beginning of the output.
This page lists the different
mysqld startup options you can use.
mysqld reads the following my.cnf sections:
[client-server] -- (MariaDB 5.3 and higher)
[galera] -- (MariaDB 10.1 and higher or MariaDB galera builds)
X.X in the examples above refer to the base (major.minor) version of the
server. For example in MariaDB 5.5.32 the base version is 5.5.
mysqld --help --verbose will show which sections are read in the top part of its output.
For a full list of mysqld options and their
current values (based on your local
mysqld --print-defaults mysqld --help --verbose
The following options determine how mysqld handles option files. They must be given as the first argument:
|Print the program argument list and exit.|
|Don't read default options from any option file.|
|Only read default options from the given file #.|
|Read this file after the global files are read.|
The full sets of options are described here.
Minimal my.cnf file
Here is a minimal my.cnf file you can install in ~/.my.cnf to test MariaDB 5.3. (For 5.2, you need to copy the section [client-server] to [client] and [mysqld]).
[client-server] # Uncomment these if you want to use a nonstandard connection to MariaDB #socket=/tmp/mysql.sock #port=3306 # This will be passed to all MariaDB clients [client] #password=my_password # The MariaDB server [mysqld] # Directory where you want to put your data data=/usr/local/mysql/var # Directory for the errmsg.sys file in the language you want to use language=/usr/local/share/mysql/english # Create a file where the InnoDB/XtraDB engine stores it's data loose-innodb_data_file_path = ibdata1:1000M loose-innodb_file_per_table # This is the prefix name to be used for all log, error and replication files log-basename=mysqld # Enable logging by default to help find problems general-log log-slow-queries
The following my.cnf example files are included with MariaDB. Examine them to see more complete examples of some of the many ways to configure MariaDB.
The above example files can usually be found in one of the following directories: