FQ, do you have mysql log activated ?

[Benj]

Hi FQ, I was wandering if you have mysql.log recording everything happening with mysql.
I had the chance to look at the log of a dedicated server, and noticed how big the mysql log can get recording the querries and such.

Considering that FQ has lots of clients, your mysql logs must be mega huge ?
I'm just curious how you deal with it ?

Thanks,
Benj

[Terra]

Yes, they can grow to tremendous sizes, but this is easily handled by rotating out the logs and compressing them down...

These types of logs are highly compressible as their is a limited command syntax that is repeated over and over again making for easy tokenization...

I would recommend 'gzip -9' as this will increase the compression window size, though it does take more resources/time to crunch...

--
Terra
sysAdmin
FutureQuest