[SAC] Re: ! wiki.osgeo.org HTTP DOWN

On Sun, Mar 09, 2008 at 08:12:01AM -0400, dmorissette@mail.dmsolutions.ca wrote:

HTTP DOWN for wiki.osgeo.org at Sun Mar 9 08:12:01 EDT 2008

Notice from the Wiki main page:

"(Can't contact the database server: Too many connections (localhost))"

Who's our MySQL guru ?

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

On Sun, Mar 09, 2008 at 01:16:54PM +0100, Martin Spott wrote:

Notice from the Wiki main page:

"(Can't contact the database server: Too many connections (localhost))"

In fact this is a disk-full error ....

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

On Sun, Mar 09, 2008 at 01:43:20PM +0100, Martin Spott wrote:

In fact this is a disk-full error ....

/me continues to chat with myself .... :slight_smile:

Does anyone have an idea what all these mysql-bin.xxxxxx files are for
in /var/lib/mysql/ ? I've never seen that before with (one of my rare)
MySQL installations,

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

On Sun, Mar 09, 2008 at 01:51:31PM +0100, Martin Spott wrote:

Does anyone have an idea what all these mysql-bin.xxxxxx files are for
in /var/lib/mysql/ ? I've never seen that before with (one of my rare)
MySQL installations,

Looks like we don't need them for properly running the Wiki- or Trac-
database (I've moved all these files into a subdir /var/lib/mysql/.a/)

So what do you think about installing a CRON job which is going to
purge all these files on a regular basis after they got approx. 3 days
old ? Apparently MySQL tracks these files in 'mysql-bin.index', so we
might be required to restart MySQL afterwards.

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