Jump to content
Rob(AU)

MySQL server has gone away

Recommended Posts

I am having issues with my site being very slow, for both the front and back end. Having researched and looked at previous posts on the topic has not helped, but the threads I could find were from a while ago.

The error I'm getting in the Exceptions Log is: 
     SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
      In /wire/core/WireDatabasePDO.php line 499

Tech support for my hosting investigated and could not see any MySQL issues. At the same time, the dev copy of the site on my localhost is also going slow.

Another site on my localhost is working as normal, so that seems to eliminate the hosting as a problem.

I am hoping someone can shed some light on what might be causing this.

Thanks

Share this post


Link to post
Share on other sites

When I was getting this it turned out to be a PHP memory limit issue. What is it currently set at?

Share this post


Link to post
Share on other sites

Hi Adrian,

currently it is set at:  memory_limit 768M

Is that going to be enough? The site has less than 200 pages.

Thanks

Share this post


Link to post
Share on other sites

I had this issue and ultimately I did nail it down to issues with the webhost.

They would cluster their clients MySQL databases based on the first letter of the URL. Domains I had beginning with 'S' or 'T' would constantly get this message, where others on 'Z' or 'Y' were unaffected...

In a nutshell, do double check that it isn't your host. The error essentially means that ProcessWire cannot connect to the DB/that it's timed out. 

Share this post


Link to post
Share on other sites
5 hours ago, Rob(AU) said:

currently it is set at:  memory_limit 768M

Is that going to be enough?

Yeah, that should be plenty. There can be lots of reasons for the SQL error - that is just one of them. You may need to dig further to discover the cause, but next I would check mysql's set max_allowed_packet setting.

Also, be sure to Google the that error as there are lots of suggestions on what to check.

Share this post


Link to post
Share on other sites

 

I am hoping someone can shed some light on what might be causing this. 

Perhaps some module, such as ProfilerPro or Flowti can help for track down some bottleneck?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...