[BLFS Trac] #3230: Include configuration instructions to purge mysql binary logs

BLFS Trac trac at linuxfromscratch.org
Fri Jan 28 03:06:32 PST 2011


#3230: Include configuration instructions to purge mysql binary logs
-------------------------+--------------------------------------------------
 Reporter:  tromador     |       Owner:  blfs-book@…                   
     Type:  enhancement  |      Status:  new                           
 Priority:  normal       |   Milestone:  6.7                           
Component:  BOOK         |     Version:  SVN                           
 Severity:  normal       |    Keywords:                                
-------------------------+--------------------------------------------------
 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.

-- 
Ticket URL: <http://wiki.linuxfromscratch.org/blfs/ticket/3230>
BLFS Trac <http://wiki.linuxfromscratch.org/blfs>
Beyond Linux From Scratch



More information about the blfs-book mailing list