Similar to houses and cars, databases need to be maintained if they are to run smoothly. In this chapter, we'll cover the following maintenance-related topics:
Depending on how we configure it, MariaDB will keep very detailed or very sparse logs. The location of these logs is configured in our
my.ini on Windows) MariaDB configuration file. On Linux, the default location is
/var/log/mysql/ and on Windows, the default location is in the MariaDB data directory.
There are several different kinds of logs, each kind serving a different purpose.
The MariaDB binary log is a series of ...