Mailing List Archive

Is the database logging?
Jason,

could you check whether the wikipedia mysql database server is logging
all requests? That could be a reason for the slowdown. It would be a
huge fast growing file called *.log somewhere in mysql's directory.

Axel
Re: Is the database logging? [ In reply to ]
It is logging slow requests... 320 Meg since April 19.

Jason

Axel Boldt wrote:

> Jason,
>
> could you check whether the wikipedia mysql database server is logging
> all requests? That could be a reason for the slowdown. It would be a
> huge fast growing file called *.log somewhere in mysql's directory.
>
> Axel
> _______________________________________________
> Wikitech-l mailing list
> Wikitech-l@ross.bomis.com
> http://ross.bomis.com/mailman/listinfo/wikitech-l

--
"Jason C. Richey" <jasonr@bomis.com>
Re: Is the database logging? [ In reply to ]
> It is logging slow requests... 320 Meg since April 19.

Assuming an average log message length of 100 bytes, this amounts to
between two and three logs per second, so this could conceivably be
the bottle neck. Could you chop off the last 10 megs or so, make them
available on www.wikipedia.com/tarballs, and switch off the logging?

Axel