VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: julash on February 19, 2019, 19:49:39 PM

Title: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: julash on February 19, 2019, 19:49:39 PM
Hello,

Our website keeps getting slow after updating to VM 3.4.2. Website getting very slow with high CPU/RAM usage and resource usage keeps getting high unless I clean "com_virtuemart_cat_manus" cache. I have attached one of the process log from WHM where manufacturer cache keeps loading until SIGTERM kills the process.

At this moment our website is on Joomla 3.9.3 and VM 3.4.2. Website has many manufacturers.

Please help me making sense of the problem and fix it.


Thanks
Julash
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: Jörgen on February 19, 2019, 20:52:44 PM
Turn off Joomla cache and plugin for a starter.

See if it helps. There is also some recent threads about high cpu usage, because of sql queries, maybe someone else will point You at them.

Jörgen @ Kreativ Fotografi
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: julash on February 20, 2019, 07:05:23 AM
Thanks for your reply. After cleaning "com_virtuemart_cat_manus" cache several time website now stable, no unusual process.

Our website is large and to keep website fast we need caching.
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: Jörgen on February 20, 2019, 07:15:03 AM
Caching is often an issue with shopping carts, Virtuemart no exception,but if we are lucky, there may be others here with that can offer some advice about VM and cache usage.

have a nice day

Jörgen @ Kreativ Fotografi
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: Rsn on February 20, 2019, 13:25:36 PM
Hello.
Is the checkbox "Enable VirtueMart 404 error handling" activated in the Shop Settings?

When I had this checkbox activated, there was also a very high load on the server.
We also have a large site and manufacturers.
Now I turned off this checkbox.

At the same time, I also noticed that after clearing the cache of Virtuemart, the server load decreases.
Perhaps there is some problem with cache.
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: PRO on February 21, 2019, 00:08:03 AM
also, logging 404 with the joomla redirect plugin can slow down a site because of spam/bots
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: julash on February 21, 2019, 16:07:17 PM
Our problem with "com_virtuemart_cat_manus" cache. I just killed some of its processes from WHM, this problem eating ram and cpu.

I am not sure if it will help, yesterday because of "com_virtuemart_cat_manus" cache there were many ongoing processes and ram/cpu was 100% in usage. So to stop I was clearing cache, resaving VM configuration, reoptimizing database from VM Tools.

At that time when saving VM configuration I saw a warning about "com_virtuemart_cat_manus" cache folder could not be deleted or something like that. After that the crazy cpu/ram usage become normal. Since then I did not touch VM configuration. Though now there still process that keeping busy server but not too much. I am killing long ongoing process every few hours.

This is really becoming a serious issue. Looking forward to solve this soon.

I will try updating to VM 3.4.3.
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: GJC Web Design on February 22, 2019, 00:34:17 AM
QuoteIs the checkbox "Enable VirtueMart 404 error handling" activated in the Shop Settings?
????

this is well known to cause run away usage in some cases
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: Rsn on February 22, 2019, 05:35:15 AM
Quote from: GJC Web Design on February 22, 2019, 00:34:17 AM
this is well known to cause run away usage in some cases

Sorry, I didn't understand what you meant by that.
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: GJC Web Design on February 22, 2019, 09:23:25 AM
https://forum.virtuemart.net/index.php?topic=141449.msg498250#msg498250
https://forum.virtuemart.net/index.php?topic=141342.msg497756#msg497756
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: jflash on February 27, 2019, 11:35:00 AM
Quote from: GJC Web Design on February 22, 2019, 00:34:17 AM
QuoteIs the checkbox "Enable VirtueMart 404 error handling" activated in the Shop Settings?
????

this is well known to cause run away usage in some cases
I confirm that. I had error 500 if this setting was activated. Server was constantly down... If category not found, method handle404 called, but there something goes loop and process never ends <- something like that says my programmer.
Title: Re: Very slow website, issue with com_virtuemart_cat_manus caching
Post by: julash on February 28, 2019, 19:18:25 PM
Updating to 3.4.3 solved our problem. No high cpu usage now, website running smoothly.