jaroden Posted November 3, 2014 Share Posted November 3, 2014 allo prestashop friends, we have upgraded our website http://chlpaci.sk from 1.4.7 to 1.6.09. Immediately after upgrade site started to show high disk operation - example 7.10.2014 -223181744 of disk operation. I received this number from my hosting provider. Despite this fact hosting provider decided to block our site from every country but Slovakia and Czech (we are located in Slovakia) because as they said it causes instability of their hosting. They said that our site reports second biggest disk operation from all their hosted eshops, which I can not imagine because we are just small shop 700 hundred products or so. their advice is to go thru page code and find some bag that causes this activities. Blocking is causing that our index pages were lowered to minimum and we received 403 error in webmastertool. Currently we are helpless and we dont know how to proceed. we were thinking of changing the provider but it might not solved our issue Could anybody help us? any advice on how we could trace the error or find out the problem would be beneficial. Thanks in advance Jaro Link to comment Share on other sites More sharing options...
El Patron Posted November 3, 2014 Share Posted November 3, 2014 to narrow down 'where/what' is doing sql calls... config/defines.inc.php change this to true: define('_PS_DEBUG_PROFILING_', false); visit various pages and capture for later analysis info at bottom of footer... note: set back to false after collecting data. then you can get a feel for what area a high sql hit rate is Link to comment Share on other sites More sharing options...
jaroden Posted November 3, 2014 Author Share Posted November 3, 2014 to narrow down 'where/what' is doing sql calls... config/defines.inc.php change this to true: define('_PS_DEBUG_PROFILING_', false); visit various pages and capture for later analysis info at bottom of footer... note: set back to false after collecting data. then you can get a feel for what area a high sql hit rate is Hallo El Patron, thank you for your prompt reply. I have done everything you said collected the statistics but unfortunately I dont have a skills to read it and which is worst is that I dont know how to send you attachement in this forum :-( do you have an regular email? pls send it to me in PM. Thanks in advance Link to comment Share on other sites More sharing options...
El Patron Posted November 3, 2014 Share Posted November 3, 2014 I suggest posting in job offers section, include link to this topic... there some 'very good' sharp shooters that work for very reasonable price....make sure if they are also active community members... I can't do everything myself so I also rely on those resources... Link to comment Share on other sites More sharing options...
Recommended Posts