Opened 11 years ago

Closed 10 years ago

Last modified 8 years ago

#3230 closed enhancement (fixed)

Include configuration instructions to purge mysql binary logs

Reported by: tromador Owned by: blfs-book@…
Priority: normal Milestone:
Component: BOOK Version: SVN
Severity: normal Keywords:
Cc:

Description

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.

Change History (3)

comment:1 by bdubbs@…, 10 years ago

Milestone: 6.7current

comment:2 by bdubbs@…, 10 years ago

Resolution: fixed
Status: newclosed

Added a sed to the configuration:

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

Fixed at revision 9897.

comment:3 by bdubbs@…, 8 years ago

Milestone: current

Milestone current deleted

Note: See TracTickets for help on using tickets.