|
#1
|
||||
|
||||
|
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.
|
|
#2
|
||||
|
||||
|
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
|
|
#3
|
||||
|
||||
|
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.... :-)
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|