O'Reilly logo

Getting Started with MariaDB - Second Edition by Daniel Bartholomew

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required