Include configuration instructions to purge mysql binary logs

[tromador]

As it stands the install of mysql from Chapter 21 will create endless binary logs, faithfully, one a day until either the end of time, or until the disk is full, whichever comes sooner!

They can get get quite large and definately very numerous.

Might it be worthwhile looking at managing this a bit. The requirement for logs for replication and so on is probably beyond the scope of BLFS, so I suggest it would be appropriate to simply place a limit on the number of binary logs produced, such that mysql isn't quietly filling disk in the background.

I suggest adding a --expire_logs_day= switch into the startup script and then a mysqladmin flush_logs as a cron job to keep this under control.

[bdubbs@…]

Added a sed to the configuration:

sed -i 's/^{log-bin/#log-bin/' /etc/my.cnf}

Fixed at revision 9897.

[bdubbs@…]

Milestone current deleted