wait_timeout

[iblis]

Hi.

I've noticed that, when people submit optimization requests, you reply by giving them a wait_timeout (in my.cnf) setting of 10000 and more.
Since this is in seconds (in one posts it was 10800, thus 3 hours), I was wondering why you continue to recommend such a high value.

Would this not be very intensive on the server?
Is there something I'm missing?

[eva2000]

from my experience and working with other vBs too short a wait_timeout value results in sometimes errors reported by mysql server - sometimes only reported in mysql error log

and depends on the power/hardware of the server

I could recommend lower with folks on dual xeons etc but all my.cnf values I recommend are pretty conservative as I don't want to crash or kill a client's server with my very first piece of advice LOL

[Robbban]

hehe, OK :-) But we suddenly got extremly high loads on our server and we are trying to find out why... Don't know if we are under attack or something, or if altavista have noticed that we got over 40.000 pictures, previously allowed to be hotlinked. No more hotlinking is allowed but the serverload is still high :-( Change the name of attachment.php and made changes to the style so it would match the new name. Going to check my logs if attachment.php is called with 404 lots of times...

[Robbban]

Wops, replied to the wrong post :(