Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf /.my.cnf

This page lists the different mysqld startup options you can use.

mysqld reads the following my.cnf sections: [mysqld] [server] [mysqld-5.1].

In addition MariaDB 5.1 also reads the sections: [mariadb] [mariadb-5.1].

The 5.1 stands for the main version, the above is for MariaDB 5.1.

MariaDB 5.3 also reads the sections [client-server] [mariadb-5.3]

For a full list of mysqld options and their current values (based on your local my.cnf), do:

mysqld --help --verbose

Global Options

The following options determine how mysqld handles option files. They may be given as the first argument:

OptionDescription
--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.

MariaDB Options

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/mysql/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.

  • my-small.cnf
  • my-medium.cnf
  • my-large.cnf
  • my-huge.cnf

The above example files can usually be found in one of the following directories:

  • source-file-path/support-files
  • mysql-install-path/share/mysql (e.g. /usr/local/mysql/share/mysql)

Comments

Comments loading...