Database Reference
In-Depth Information
Configuring MariaDB
MariaDB is installed with a generic configuration suitable for light, casual use. This
is perfect for giving MariaDB a try but hardly suitable for a production database
application, or even a moderately busy website database. There are thousands of
ways to tweak the settings to get MariaDB to perform the way we need it to. Many
topics have been written on this subject. In this chapter, we'll just cover the basics
that are enough to comfortably edit the MariaDB config files and get to know our
way around; think of it as a highlights tour.
Filesystem layout for MariaDB
A MariaDB installation is not a single file or even a single directory, so the first
stop on our tour is a high-level overview of the filesystem layout. We'll start with
Windows, and then move on to Linux.
Filesystem layout for Windows
On Windows, MariaDB is installed under a directory named with the
following pattern:
C:\Program Files\MariaDB <major>.<minor>\
The following is the location for MariaDB 10.0:
C:\Program Files\MariaDB 10.0\
The only alteration of this location, unless we change it during the installation, is
when the 32-bit version of MariaDB is installed on a 64-bit version of Windows. In
that case, the default MariaDB directory is at the following location:
C:\Program Files x86\MariaDB <major>.<minor>\
