Yes.
First, I want to understand the connection between slow queries and the increasing RAM Usage. I have allotted 4GB RAM to MYSQL so why consume more?
And, What can I do here to fix the issue?
This query looks really suspicious I don’t know much internals about WP query, but this query does not make much sense.
your site might be hacked?
If query is taking this much time it must be using ram + cpu.
No, It’s not hacked. We have 2 lakh order entries on our website. It takes around 20-40 seconds at max to search for an order.
The query is for searching an order.
I did try with Redis Disabled but nothing changed.
If your site is that much serious then hire someone with knowledge of sys-admin who can properly help you diagnose. This problem is not related to CyberPanel, if your site is resource heavy then no panel can do anything.
Because the amount of money you will save by not hiring will go into loss of orders.
1 Like