1

My Magento Site , using a Theme, is taking a Full Minute to load up !!

The Host Provider has advise its due to SLO"W QUERIES. I'm using a 4GB RAM Server, so dont think it's the problem.

Optimising the Tables has not resolved the problem.

Does anyone know if the the "Full Page Cache" Extensions will resolve the problem ?

Or is the Theme Template faulty ?

I really like the Theme since it's best suited to the business model & want to continue using it.

How can i resolve the issue of SLOW QUERIES ?

Pls help.

1

To be able to see which queries are slow, you can edit the following file lib/Varien/Db/Adapter/Pdo/Mysql.php

And change the following variable to true:

protected $_debug               = true;

The slow queries will be logged under the var/debug/pdo_mysql.log file.

You can change the query durations to be logged by changing the following variable:

protected $_logQueryTime        = 0.05;
  • Thanks - but how can I resolve the issue of slow queries ? Deploy FPC Magento Extension or change the theme template ? – Mave Feb 11 '16 at 15:39
  • It depends on the queries you'll get in the logs. Your question is way too broad to be able to help you. You need to find where the issue comes from first. – Raphael at Digital Pianism Feb 11 '16 at 15:55
  • Can I send you the slow query log to have a look at ? – Mave Feb 11 '16 at 16:02
  • Post it in your question – Raphael at Digital Pianism Feb 11 '16 at 16:06
  • Here you go. sangyug-ke.com/mysql-slow.log.txt – Mave Feb 11 '16 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.