This topic has 4 voices, contains 6 replies, and was last updated by theos17 3436 days ago.

Soppica2 Creating Too Many MySql Queries and memory is getting full due to huge memory usage

This topic has been marked as resolved.

Hello guys, I have about 2000 products on my website. I am using shoppica2 theme, search filter extension and seo url extension. My website was really slow so I decided to change my hosting. I have ordered a VDS and I made a fresh install on my new server. The hosting provider is one of the best providers in Turkey. I have 2 GB memory and 2 CPU in VDS. It must be enough for opencart and shoppica2. PHP version is 5.3. The problem is that, website working very slow. FTP and SSH connections are super fast but website is so slow. I contacted hosting provider and they said my website creating too many mysql queries and 2gb memory is getting full. When there is not available memory I get 500 Internet Server Error. Here is the report that hosting provider sent to me: [root@vpsplesk11 ~]# free -m total used free shared buffers cached Mem: 2010 1999 11 0 3 1345 \| 8598 \| coolbebek \| localhost \| coolbebek \| Query \| 723 \| Copying to group table \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8658 \| coolbebek \| localhost \| coolbebek \| Query \| 287 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8662 \| coolbebek \| localhost \| coolbebek \| Query \| 286 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8663 \| coolbebek \| localhost \| coolbebek \| Query \| 289 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8669 \| coolbebek \| localhost \| coolbebek \| Query \| 266 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8670 \| coolbebek \| localhost \| coolbebek \| Query \| 249 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8697 \| coolbebek \| localhost \| coolbebek \| Query \| 66 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8698 \| coolbebek \| localhost \| coolbebek \| Query \| 62 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8699 \| coolbebek \| localhost \| coolbebek \| Query \| 63 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8700 \| coolbebek \| localhost \| coolbebek \| Query \| 40 \| query end \| UPDATE cache_supercategory cs SET cs.cached=cs.cached+1 WHERE cs.cache_id = ’7′ \| \| 8701 \| coolbebek \| localhost \| coolbebek \| Query \| 31 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8702 \| coolbebek \| localhost \| coolbebek \| Query \| 42 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8703 \| coolbebek \| localhost \| coolbebek \| Query \| 40 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8704 \| coolbebek \| localhost \| coolbebek \| Query \| 14 \| query end \| UPDATE cache_supercategory cs SET cs.cached=cs.cached+1 WHERE cs.cache_id = ’8′ \| \| 8705 \| coolbebek \| localhost \| coolbebek \| Query \| 40 \| query end \| UPDATE cache_supercategory cs SET cs.cached=cs.cached+1 WHERE cs.cache_id = ’7′ \| \| 8706 \| coolbebek \| localhost \| coolbebek \| Query \| 27 \| query end \| UPDATE cache_supercategory cs SET cs.cached=cs.cached+1 WHERE cs.cache_id = ’7′ \| \| 8707 \| coolbebek \| localhost \| coolbebek \| Query \| 19 \| Copying to tmp table on disk \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8708 \| coolbebek \| localhost \| coolbebek \| Query \| 23 \| Creating sort index \| SELECT c.category_id, COUNT(p2c.category_id) AS pr \|ucts_count, GROUP_CONCAT(p2c.product_id) AS ids \| 8709 \| coolbebek \| localhost \| coolbebek \| Query \| 21 \| query end \| UPDATE cache_supercategory cs SET cs.cached=cs.cached+1 WHERE cs.cache_id = ’7′ \| \| 8711 \| coolbebek \| localhost \| coolbebek \| Sleep \| 0 \| \| NULL \| \| 8712 \| coolbebek \| localhost \| coolbebek \| Query \| 9 \| query end \| UPDATE cache_supercategory cs SET cs.cached=cs.cached+1 WHERE cs.cache_id = ’7′ \| \| 8713 \| coolbebek \| localhost \| coolbebek \| Query \| 2 \| query end \| UPDATE cache_supercategory cs SET cs.cached=cs.cached+1 WHERE cs.cache_id = ’7′ \| \| 8714 \| coolbebek \| localhost \| coolbebek \| Sleep \| 9 \| \| NULL \| \| 8715 \| admin \| localhost \| NULL \| Query \| 0 \| NULL \| show processlist \| \| 8716 \| coolbebek \| localhost \| coolbebek \| Query \| 0 \| Sending data \| SELECT * FROM url_alias WHERE `query` = ‘category_id=17′ \| My Website is http://www.coolbebek.com I need help about this. I think soppica2 has a problem because default opencart theme works very well on the server. Any ideas ?	turkoloko
October 31, 2012 at 5:17 pm #14839
Does anybody have an idea about this? I need support. Because my website not working now.	turkoloko
November 1, 2012 at 12:13 am #14843
The performance of Shoppica 2 matches the default opencart performance with not more than 5% difference, so I guess you would have the same issues with the default opencart theme. I guess the problem with your hosting is not the memory, but the CPU power, which is insufficient. We tested Shoppica 2 with larger product/category databases than yours and its performance is comparable to the default theme. The major opencart performance problem is the products count in category menu and it has nothing to do with Shoppica. Try to disable the ‘Category Product Count’ option in the admin -> System -> Settings menu to see if it does make a difference. Additionally we have sent you our experimental cache extension to give it a try. Regards, ThemeBurn team	TB Support
November 1, 2012 at 9:51 am #14851
I have modified hosting and it is working good now. But when I clicked on a cagtegory, it takes more time than product page or my account page. So my only problem is category page load. I have installed your module also. Is there any way to proceed it more.	turkoloko
November 3, 2012 at 1:34 pm #14916
You`ll need to optimize your OC database… I had the same problem. You will find a few extensions on the official OC extensions website… even a free one that worked wonders for me.. Also .. disable category count … If all else fails .. change theme	stf86
November 3, 2012 at 2:59 pm #14917
Which extension did you use, can you please specify ? Thank you.	turkoloko
November 4, 2012 at 8:23 pm #14941
Hi stf86, Which extension did you use, can you please specify ? Thank you.	theos17
November 30, 2014 at 12:32 pm #35049

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.