MySQL too many connections

[hardwire]

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.

[Tom]

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]

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.... :-)