Jump to content

Major Database Hits HELP ME!


Recommended Posts

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 by kashyyyk (see edit history)
Link to comment
Share on other sites

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

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
×
×
  • Create New...