Birmingham mumbai

[
 333 
]
The other configuration files aren't relevant for the content of this book, and 
their current values are more than sufficient for what we need. When it comes to 
performance tuning, you may consider creating a new configuration file ending with 
the 
.cnf
 extension, with specific tuning values as provided by the documentation of 
a software package you want to run that interfaces with a database, or requirements 
given to you by a developer.
For additional information on how these configuration files are read, you can refer 
to the 
/etc/mysql/mariadb.cnf
 file, which includes some helpful content at the top 
of the file that details the order in which these configuration files are read, as well as 
their purpose. Here's an excerpt of these comments from that 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. 
As we can see, when MariaDB 
starts up, it first reads the 
/etc/mysql/mariadb.cnf
 
file, followed 
by .cnf
 files stored within the 
/etc/mysql/conf.d
 directory, then the 
.cnf
 files stored within the 
/etc/mysql/mariadb.conf.d
 directory, followed by any 
user-specific settings stored within a 
.my.cnf
 file that may be present in the user's 
home
 directory.
With Ubuntu's implementation, when the 
/etc/mysql/mariadb.cnf
 file is read 
during startup, the process will immediately scan the contents of 
/etc/mysql/conf.d
 
and 
/etc/mysql/mariadb.conf.d
, because the 
/etc/mysql/mariadb.cnf
 file contains 
the following lines:
!includedir /etc/mysql/conf.d/ 
!includedir /etc/mysql/mariadb.conf.d/ 
As you can see, the order that the configuration files are checked is set to the 
mariadb.cnf
 file first, followed by the 
/etc/mysql/conf.d
 and 
/etc/mysql/mariadb.
conf.d
 directories.
This may be a bit confusing at first, because the default configuration for MariaDB 
in Ubuntu Server essentially consists of files that redirect to other files. But the main 
takeaway is that any configuration changes you make that are not exclusive to 
MariaDB (basically, configuration compatible with MySQL itself) should be placed in 
a configuration file that ends with the 
.cnf
 extension, and then stored in the  
/etc/mysql/conf.d
 directory. 

---

Managing Databases