Database Reference
In-Depth Information
Groups
Groups are sections in the configuration file. Each MariaDB program or utility can
have its own configuration information in it. Even individual series of MariaDB
have their own group (these are useful if we are testing a development version
and want to enable a new feature without affecting older servers that use the same
configuration file).
A group begins with the name of the group, enclosed in brackets (
[]
) on a line by
itself. The group continues to the end of the file or to the beginning of the next group.
Here is an example:
[mysqld]
# Configuration options for the mysqld program go here
In addition to
[mysqld]
, other common groups include:
[mysql]
# configuration options for the mysql command-line client
[client-server]
# configuration options for both clients and the server
[mysqladmin]
# configuration options for the mysqladmin program
[mysqlcheck]
# configuration options for the mysqlcheck utility
[mariadb-10.0]
# configuration options just for MariaDB 10.0 series servers
There are many other possible groups, but I think we get the picture. We just use the
ones we want and can ignore the others.
Options which do not require values
Configuration options either take a value or not. Those that do not need a value
appear on a line by themselves with no equals sign (
=
). They are used for options that
are either on or off so there is no need for arguments. If it exists in the configuration
file (and isn't commented out) the feature is on. If it doesn't exist (or it is commented
out) the feature is set to whatever the default is (
ON
or
OFF
). An example would be:
no-auto-rehash
To turn
OFF
a feature that is
ON
by default, just add
=OFF
to it as follows:
no-auto-rehash=OFF
We can also be more explicit about turning a feature on by appending
=ON
to an
option. It's not necessary though.
