kashyyyk Posted July 28, 2014 Share Posted July 28, 2014 (edited) My site was going slow and I got an error connecting to my database, I contacted my host and here is their response- The reason for the problem is that your database "EDITED" has been penalized by the MySQL server due to the great overload it is causing and for example it made 52,394 for the past 10 minutes and 266,077 queries for the past 1 hours while the next on the line has 992 for 10 minutes and 13 222 for 1 hour.I would highly recommend you to enable the Debug Profiler or the debugging for your Prestashop to be able to locate what is generating that many queries and try to optimize them to prevent mysql overload and this will speed up your website. I enabled debug and I'm getting no errors. In my cpanel I found my database stats- 2,591,155 hits just today alone! Now July 1st I got 942671 in the whole day. I've done no changes, and I thought it was running fairly good. I did add Memcached to see if that will help and it hasn't. How do I found out what the culprit is? My site is www.phryz.com I'm using 1.5.6.2 Edited July 28, 2014 by kashyyyk (see edit history) Link to comment Share on other sites More sharing options...
kashyyyk Posted July 31, 2014 Author Share Posted July 31, 2014 Any help, I turned off most blocks and all stats, it's about half but I still need help. Link to comment Share on other sites More sharing options...
kashyyyk Posted July 31, 2014 Author Share Posted July 31, 2014 (edited) I found this query stats in my phpmyadmin, can anyone help determain what is going on? Questions since startup: 130,890,507 Paste didn't work here is a screen shot- Edited July 31, 2014 by kashyyyk (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted July 31, 2014 Share Posted July 31, 2014 hosting made good advice, enable Debug Profiler and visit your major pages. config/defines.inc.php set to true define('_PS_DEBUG_PROFILING_', false); note: once enabled all visitors will activate this, so use and then turn off or put shop in maint mode. Link to comment Share on other sites More sharing options...
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