MySQL Server generates several logs that can help you monitor the activities of
the server. However, once these logs are enabled, they can grow
in size and start taking up too much disk space. This is why it’s
important to have an automated way of archiving and preserving
MySQL log files for a certain duration, as well as deleting the
old ones. In this blog post, we describe some best practices for
setting up and managing MySQL error logs, general logs and slow
query logs for your MySQL deployments.
Setting Up MySQL Server Logging
Let’s look at how to setup the following 3 types of logs:
Error Log
Logs all the problems encountered during starting, running, or
stopping mysqld. This log can be enabled by having the following
option in /etc/my.cnf file:
[Read more]