Prestashop Running Slow

[aztecmedia]

Hi,

 

One of our clients has a website built using PrestaShop version 1.4.2.5

 

Over the last month or so the website has been running extremely slow to the point that none of the users can access it.

 

It's a relatively high traffic site and receives around 3,000 visits per day.

 

We've got cache turned on and force compile off. PrestaShop statistics were also disabled as they were causing an issue,

 

We've identified some excessive MySQL queries on the web server that we could do with advice on; screenshot attached.

 

There are loads of these queries happening every second in MySQL which is using up all the CPU resources on the D/B server, are these queries normal? The web server itself is showing no signs of excessive activity.

 

Thank you,

 

Oliver

[El Patron]

This is difficult because 1.4 does not have debug profiler.  If no changes to shop but starts to get slow it's typically change at hosting level.  The queries look like new instances of visit, i.e. each new page load will load the ps_configuration values.  I have seen where ps_configuration had a 'lot' of values added that caused to to bog down.  go to the bottom of that table and see if anything recently was added.