[SAC] [OSGeo] #215: MySQL Binary Logs Fill Disk on OSGeo2

#215: MySQL Binary Logs Fill Disk on OSGeo2
----------------------+-----------------------------------------------------
Reporter: warmerdam | Owner: sac@lists.osgeo.org
    Type: task | Status: new
Priority: major | Component: SAC
Keywords: mysql |
----------------------+-----------------------------------------------------
This directory appears to be full of binary logs on osgeo2, similar to the
issues on osgeo1 mentioned in #176.

{{{
[root@osgeo2 etc]# du /var/lib/mysql/.a
177892908 /var/lib/mysql/.a
}}}

--
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/215&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

On Sun, Mar 09, 2008 at 02:00:27PM -0000, OSGeo wrote:

I don't see you in IRC. Would you like me to take care of cleaning up the
mysql logs problem? I'm just worried about us colliding on this issue.

For clarification: I've been moving all the mysql-bin. files into a
(hand-made) subdir .a to see, if MySQL will resume running afterwards.
In other words: To see if MySQL really still needs these files or if it
can live without. I simply didn't know better than just trying it out.

If you came to the conclusion that MySQL does _not_ need these old
files (at least this is my conclusion) then simply remove the whole .a/
subdir and you'll be fine for a while.
I have to leave urgently (having a concert this evening: Brahms
Requiem), therefore I don't have the time to show up on IRC,

  Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------

Martin Spott wrote:

On Sun, Mar 09, 2008 at 02:00:27PM -0000, OSGeo wrote:

I don't see you in IRC. Would you like me to take care of cleaning up the
mysql logs problem? I'm just worried about us colliding on this issue.

For clarification: I've been moving all the mysql-bin. files into a
(hand-made) subdir .a to see, if MySQL will resume running afterwards.
In other words: To see if MySQL really still needs these files or if it
can live without. I simply didn't know better than just trying it out.

If you came to the conclusion that MySQL does _not_ need these old
files (at least this is my conclusion) then simply remove the whole .a/
subdir and you'll be fine for a while.
I have to leave urgently (having a concert this evening: Brahms
Requiem), therefore I don't have the time to show up on IRC,

Martin,

Thanks for your work on this. I have cleaned out the logs, and disabled
binary logging on osgeo2 (as we had previously for osgeo1). Details in

   http://trac.osgeo.org/osgeo/ticket/215

for those interested.

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | President OSGeo, http://osgeo.org