Very slow website, issue with com_virtuemart_cat_manus caching

[julash]

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

[Jörgen]

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

[julash]

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.

[Jörgen]

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

[Rsn]

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.

[PRO]

also, logging 404 with the joomla redirect plugin can slow down a site because of spam/bots

[julash]

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.

[GJC Web Design]

Is the checkbox "Enable VirtueMart 404 error handling" activated in the Shop Settings?

?

this is well known to cause run away usage in some cases

[Rsn]

this is well known to cause run away usage in some cases

Sorry, I didn't understand what you meant by that.

[GJC Web Design]

https://forum.virtuemart.net/index.php?topic=141449.msg498250#msg498250
https://forum.virtuemart.net/index.php?topic=141342.msg497756#msg497756

[jflash]

Is 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.

[julash]

Updating to 3.4.3 solved our problem. No high cpu usage now, website running smoothly.