Timeline for My site is taking a Full minute to load due to slow queries?
Current License: CC BY-SA 3.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 11, 2016 at 19:45 | comment | added | Raphael at Digital Pianism | Ask a new answer as its a différent subject | |
| Feb 11, 2016 at 19:18 | comment | added | Mave | The slow site in qtn is sub domain sangyug-ke.com/market. I dont know why the slow query log file is showing db that does not belong to sub domain site ? | |
| Feb 11, 2016 at 19:12 | comment | added | Mave | The log file shows database sangyugk_aw2, which apparently does not belong to domain site that is slow on load-up. So I asked this qtn to Siteground Support. His response : Quote: "I have found that the sangyugk_aw2 named database is used by your application used by sangyug-ke.com domain name . i have found that in the following file: Code: /home/sangyugk/public_html/config/config.php" | |
| Feb 11, 2016 at 19:06 | comment | added | Raphael at Digital Pianism | I dont know if it's related to the theme, it's related to a module that's all I know. If the module comes with the theme then yes it's theme related but right now I don't know | |
| Feb 11, 2016 at 18:45 | comment | added | Mave | Are you saying something wrong with the theme template ? I should to another one ? | |
| Feb 11, 2016 at 18:28 | comment | added | Raphael at Digital Pianism | Well we can't help you more, it's a community module so it does not belong to magento stackexchange I suggest you contact the developer | |
| Feb 11, 2016 at 17:19 | comment | added | Mave | Great. What's next step ? | |
| Feb 11, 2016 at 16:56 | comment | added | Raphael at Digital Pianism |
Well you found the issue. You have a module that deals with tables called starting with isc_.
|
|
| Feb 11, 2016 at 16:51 | comment | added | Mave | The link above was just generated. Its the top 10 slow queries of all 194 | |
| Feb 11, 2016 at 16:50 | comment | added | Mave | sangyug-ke.com/market/slow_queries.txt | |
| Feb 11, 2016 at 16:37 | comment | added | Mave | Pls bear with me. I' m working on it. | |
| Feb 11, 2016 at 16:23 | comment | added | Raphael at Digital Pianism |
Well there's a lot of queries in there, empty the log file and try changing the $_logQueryTime to 5.
|
|
| Feb 11, 2016 at 16:18 | comment | added | Mave | Here you go. sangyug-ke.com/mysql-slow.log.txt | |
| Feb 11, 2016 at 16:06 | comment | added | Raphael at Digital Pianism | Post it in your question | |
| Feb 11, 2016 at 16:02 | comment | added | Mave | Can I send you the slow query log to have a look at ? | |
| Feb 11, 2016 at 15:55 | comment | added | Raphael at Digital Pianism | 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:39 | comment | added | Mave | Thanks - but how can I resolve the issue of slow queries ? Deploy FPC Magento Extension or change the theme template ? | |
| Feb 11, 2016 at 14:56 | history | answered | Raphael at Digital Pianism | CC BY-SA 3.0 |