TomPuja Posted November 14, 2013 Share Posted November 14, 2013 Hi, frequently observe the following error (see below) when trying to reach my web-shop with a browser. Link to database cannot be established: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Issued a ticket to hosting company and received the following: The drops in the MySQL connection are actually not due to server wide issues with MySQL, but are due to your queries hitting limits on our server which cause your queries to be killed. These limits are dynamic and based on load, slow_query time and a variety of other factors. Our system has fairly generous limits so the first thing I would suggest is if you can optimize anything going on in that database and see if you can stay under the limits. Can anyone help me with this as it happens way to often and I don't want to loose sales because of this error? Thank you in advance! Link to comment Share on other sites More sharing options...
tuk66 Posted November 14, 2013 Share Posted November 14, 2013 Maybe the MySQL database server does't respond from time to time on your host. Link to comment Share on other sites More sharing options...
TomPuja Posted November 14, 2013 Author Share Posted November 14, 2013 Well, according to a support team at hosting company - this is not caused by server or it's problems... Queries are killed because of exceeded limits... So I wonder what I can do about it, or how I could combine queries... Link to comment Share on other sites More sharing options...
tuk66 Posted November 14, 2013 Share Posted November 14, 2013 Queries are killed because of exceeded limits... That is caused by the server. Why limits are exceeded there and on other hostings don't? You probably would think about other hosting. Link to comment Share on other sites More sharing options...
TomPuja Posted November 14, 2013 Author Share Posted November 14, 2013 I believe that hosting is good enough here. Moreover it's recommended by Presta - A2 hosting. The mentioned problem started to appear when I moved my newly developed shop to the real domain... During the building process I haven't experienced such thing... Link to comment Share on other sites More sharing options...
TomPuja Posted November 14, 2013 Author Share Posted November 14, 2013 I have played a bit with Apache mod security at the backoffice of Presta... and now it seems to work properly... Link to comment Share on other sites More sharing options...
JeffV Posted February 16, 2014 Share Posted February 16, 2014 What did you do to fix this, exactly? I'm getting the same error. Link to comment Share on other sites More sharing options...
TomPuja Posted February 16, 2014 Author Share Posted February 16, 2014 I am not sure if it really helped. Therefore, I would rather recommend to optimize tables in your DB (see here http://www.happyat.net/billing/knowledgebase.php?action=displayarticle&id=9) it helps a bit as a reason I started to get these kind of errors was that queries were too slow. Eventually, I upgraded my hosting package from Shared WEB to Managed VPS and these errors disappeared. However, I just managed to solve the symptoms, but not the reason. My shop sometimes gets very slow and it works (even slowly) just because there is no query governor which kills too slow queries. I hope it helped. Cheers! Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now