Get the default configuration file my.cnf for MariaDB, optimized for Debian GNU/Linux 9 (stretch). This example configuration ensures optimal compatibility and performance for MariaDB, making it easy to set up and adjust to meet your needs.
Find and download the configuration file here: /etc/mysql/my.cnf.
For more configurations and setup guides, visit our related files section to further customize your system.
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
Download the raw file with wget or curl
wget -O my.cnf.example https://exampleconfig.com/static/raw/mariadb/debian9/etc/mysql/my.cnf
curl https://exampleconfig.com/static/raw/mariadb/debian9/etc/mysql/my.cnf > my.cnf.example
Other config files you might find useful