This week me and my readers are having difficulty to access my blog, it took aged to load the page and it showing some error message, saying "error: [MySQL server has gone away]".
This error mean either the database has been shutdown or the connection to database has been terminated. After some investigation, I found that the database are still alive, so the conclusion is the connection between wordpress to mysql are having some problem.
So, I started to find the root cause behind this, I went through the Mysql variables and saw the "wait_timeout" are set to 100 sec. It just too short to cater some large queries and when the cpu is heavily loaded, connection to Mysql will reach it bottleneck and fails. Some of you may wonder what is "wait_timeout" variable?
wait-timeout is the number of seconds the server waits for activity on a non-interactive connection before closing it. This timeout applies only to TCP/IP and Unix socket file connections, not to connections made via named pipes, or shared memory.I reported this issue immediately to the web hosting provider and within 24 hours, they alter the "wait_timeout" variables to 500 sec. Problem solved.
Source:http://dev.mysql.com
on November 14, 2008 at 9:06 PM
change blog...
on November 14, 2008 at 9:09 PM
= . = ... what do u mean?
on November 14, 2008 at 10:20 PM
means your blog too many plugin until 100 sec not enough to load.
on November 14, 2008 at 10:58 PM
=.= maybe...
but their database should be ready to handle my request, if you are their dba, then I won't face this problem.
:)
on November 18, 2008 at 12:37 PM
then... wan employ me bo??
on November 20, 2008 at 8:07 PM
if they know what u can do, i think they will.. :)
Post a Comment