Just like houses and cars, databases need to be maintained if they are to run smoothly. In this chapter we'll cover a variety of maintenance-related topics. We'll start with an exploration of the various MariaDB log files, which tell us what MariaDB is doing. Then we'll move on to a discussion about optimizing MariaDB. We'll then discuss what is probably the most important part of maintaining our database: backups. Lastly, we'll cover the utilities MariaDB includes to repair tables.
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 ...