Configuring the parameters

After installation, the basic things you need to configure are covered in this section. The rest all can be left as default or tuned later according to the load.

How to do it...

Let's get into the details.

data directory

Data managed by the MySQL server is stored under a directory known as the data directory. Each sub-directory of the data directory is a database directory and corresponds to a database managed by the server. By default, the

data directory has three sub directories:

• mysql: MySQL system database
• performance_schema: Provides information used to inspect the internal execution of the server at runtime
• sys: Provides a set of objects to help interpret performance schema information more easily

Apart from these, the data directory contains the log files, InnoDB tablespace and InnoDB log files, SSL and RSA key files, pid of mysqld, and mysqld-auto.cnf, which stores persisted global system variable settings.

To set the data directory change/add the value of datadir...