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

Reply


Old
  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.
 
 


Old
  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
 
 


Old
  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.
 
 
 


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

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


Old
  Post #5 (permalink)   07-31-2016, 05:45 PM
HD Addict
 
Join Date: Nov 2008
Location: Central Indiana, USA
Posts: 187
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
HA Shared Plans Check them out! Old plans still available.
Shared, Premium, Reseller, and VPS
http://www.mddhosting.com/
 
 
 


Old
  Post #6 (permalink)   09-06-2016, 10:43 AM
HD Addict
 
Join Date: Aug 2015
Posts: 127

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
ConorTreacy.com <- That's Me! ;)
 
 


Old
  Post #7 (permalink)   09-10-2016, 03:23 AM
HD Addict
 
Join Date: Sep 2014
Location: India
Posts: 169
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.
__________________
www.24x7servermanagement.com
Server Management, Server Security, Server Monitoring.
Network Monitoring Team !! Skype: techs24x7
 
 


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

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

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: