MySQL wait_timeout config?

[James]

Can anyone give me a reason NOT to lower the MySQL wait_timeout to something more reasonable like 30sec? I don't understand why by default it is set so high and before running blindly into it and just lowering it, I was curious if any of you DBA's/sysadmins/gurus can tell me why I shouldn't?

TIA

 

[jan12345]

Can anyone give me a reason NOT to lower the MySQL wait_timeout to something more reasonable like 30sec? I don't understand why by default it is set so high and before running blindly into it and just lowering it, I was curious if any of you DBA's/sysadmins/gurus can tell me why I shouldn't?

TIA

I can't see why not, give it a go and see. Trail and Error is the best advice i can give you!

 

[James]

I can't see why not, give it a go and see. Trail and Error is the best advice i can give you!

Thanks took it from the standard 8 hours to 30 minutes in stead. We have some pretty long running queries so I don't want one of those to bork the process. This was my thinking, if you have a script and you run query A which returns a set of results. You then run query B which takes 1 minute to run. The script then iterates through query B and uses the results from query A in the iteration. If you set the time_out to to 30 seconds, query resource A would have timed out and caused the script to error out. This is my justification to not setting it too low as planned. I am setting it now to 30 min and will monitor the situation and over the next few weeks will optimise it to a suitable level I think.