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

1 Answer 1

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;
17
  • Thanks - but how can I resolve the issue of slow queries ? Deploy FPC Magento Extension or change the theme template ?
    – Mave
    Feb 11, 2016 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. Feb 11, 2016 at 15:55
  • Can I send you the slow query log to have a look at ?
    – Mave
    Feb 11, 2016 at 16:02
  • Post it in your question Feb 11, 2016 at 16:06
  • Here you go. sangyug-ke.com/mysql-slow.log.txt
    – Mave
    Feb 11, 2016 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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