[SAC] [OSGeo] #126: mysql binary logs filling disk

[OSGeo]

#126: mysql binary logs filling disk
----------------------+-----------------------------------------------------
Reporter:  warmerdam  |       Owner:  sac at lists.osgeo.org
    Type:  task       |      Status:  new                
Priority:  major      |   Component:  SAC                
Keywords:             |  
----------------------+-----------------------------------------------------
 On www.osgeo.org the mysql binary logs in /var/lib/mysql have grown to
 175GB, filling the disks.

 It seems these logs are described at:

   http://dev.mysql.com/doc/refman/5.0/en/binary-log.html

 I have purged some older logs by issuing the following mysql command:

   purge master logs before '2007-06-01';

 But I think we need to figure out why the logs are so huge, whether we
 even need them, and how to purge them more appropriately.  According to
 notes in the purge command docs you can set an automatic purge limit in
 your mysql.cnf file using the expire_log_days keyword.

-- 
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/126>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.