O'Reilly logo

Getting Started with MariaDB 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 6. MariaDB Maintenance

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.

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

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