Get Paid to Participate - up to $1 per post!     Twitter     Facebook     Google+
Hosting Discussion

forgot password?

View Poll Results: What is your MySQL wait_timeout value?
28,800 1 16.67%
60-300 4 66.67%
301-600 1 16.67%
601-28799 0 0%
Voters: 6. You may not vote on this poll


  Post #1 (permalink)   03-18-2016, 03:57 PM
Account Disabled
Join Date: May 2012
Posts: 969

Status: Collabora is offline
Poll: For a shared hosting environment what is the optimal value for the MySQL wait_timeout variable?

Explain. What is your reasoning?

Last edited by Collabora : 03-18-2016 at 04:00 PM.

  Post #2 (permalink)   03-20-2016, 10:43 AM
HD Addict
Join Date: Dec 2011
Posts: 142

Status: storminternet is offline
MySQL wait_timeout value is nothing but the amount of time that MySQL will wait before killing an idle connection.
Default value around 28800 seconds is too high so it should be around 90-300 seconds in my view.
UK-Professional Web Hosting
Web Hosting Solutions | Cloud Hosting | Dedicated Servers
Lifetime Hosting
ISPA Award Winner:2013-Best SME Hosting | 2014-Best Dedicated Hosting

  Post #3 (permalink)   06-06-2016, 09:01 PM
HD Newbie
Join Date: Jan 2010
Posts: 16

Status: Copahost is offline
Having a long value will keep many connections in open state, and may cause a huge slowdown in your mysql server.

  Post #4 (permalink)   07-26-2016, 04:46 PM
HD Newbie
Join Date: Jul 2016
Posts: 44

Status: WiredBladeCom is offline
60-300 to not slow down the server.

  Post #5 (permalink)   07-31-2016, 05:45 PM
HD Addict
Join Date: Nov 2008
Location: Central Indiana, USA
Posts: 222
Send a message via AIM to MikeDVB Send a message via MSN to MikeDVB Send a message via Skype™ to MikeDVB

Status: MikeDVB is offline
As it's the amount of time that it will stay in an idle state - a lower number is generally fine.

Realistically anything less than 30 minutes should be fine unless it's an extremely busy server.
Michael Denney - MDDHosting LLC - Professional Hosting Solutions
Cloud Shared Plans Check them out!
Shared, Premium, Reseller, and VPS

  Post #6 (permalink)   09-06-2016, 10:43 AM
HD Addict
Join Date: Aug 2015
Location: Omaha, Nebraska
Posts: 167

Status: bigredseo is offline
We used to keep these numbers at the 300 seconds. The more important numbers were the processing times and the connection timeouts being at 10 seconds. Users are impatient, so keeping those numbers low prevent scripts from running out of control. Same thing with php timeouts.

But the wait_timeout set too low will result in a "connection has gone away" and will cause more frustration.

Definitely changing the default from the 6 or 8 hours that it comes with to a maximum of 1 hour would be a minimal task, but as @MikeDVB said, even at 30 minutes, you should be fine.
Conor Treacy
Big Red SEO - Omaha, NE <- That's Me! ;)

  Post #7 (permalink)   09-10-2016, 03:23 AM
HD Master
Join Date: Sep 2014
Location: India
Posts: 345
Send a message via Skype™ to 24x7server

Status: 24x7server is offline
90-300 seconds is fair enough.

On Shared hosting, there are either personal, small or medium business sites. They are not kind of huge sites who needs big data to fetch from mysql server. Setting up huge connection time will keep server busy and can caused serious problem.

Also, these days clients are impatient (agree with bigredseo), they are not going to wait for minuts to see the result.

So looking at all things on shared hosting upto 300seconds time out is fair enough.
Server Management, Server Security, Server Monitoring.
Network Monitoring Team !! Skype: techs24x7

  Post #8 (permalink)   09-10-2016, 04:00 AM
HD Addict
Join Date: Jul 2016
Posts: 110

Status: greenwebpage is offline
60-300 i think is the best value.

Thread Tools

New Post New Post   Old Post Old Post
Posting Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Sponsored By: