hardwire
11-03-2006, 03:15 PM
About every 2 weeks the MySQL stops serving up connections to my web pages and they all hang. Support restarts the MySQL service and everything is fine. SInce I cannot see the database errologs I looked at the settings for wait_timeout and it is set to 28800secs (8hrs). seems high to keep inactive connections before closing them. anyone know how to reduce that setting? It also has max_connect_errors= 10 before locking out the host.
Hmm, the seetings didn't look right, here is what I've changed:
max_connect_errors=50
wait_timeout=30
delayed_insert_timeout=30
connect_timeout=30
It should be fine now, I think. If it is not, you can contact the support team, we'll fix it :)
hardwire
01-08-2007, 07:33 PM
Thanks, that did seem to help. Since my year is coming up and siteground seems to have more support for the Linux server environments, I figured I'd switch from the windows NT (.NET) servers. Beside it will force me to learn a new scripting language.... :-)