Chapter 8. Maintaining MariaDB
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:
- MariaDB log files
- Optimizing and tuning MariaDB
- Backing up, importing, and restoring data
- Repairing MariaDB
MariaDB log files
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.cnf (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 binary log
The MariaDB binary log is a series of ...
Get Getting Started with MariaDB - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
