WOODMART_Widget_Layered_Nav Unoptimized

We utilize this widget to help filter down attributes however it seems to creating heavy, uncacheable queries. It is causing the PHP max_execution_time to be hit which creates a high CPU usage and then ultimately crashing the whole server.

I believe I solved my issue. It was related to this but not the root cause.

Hello,

We are glad that you sorted it out. Could you please write some details on what this issue was caused by?

Kind Regards

[adf_david]

After painstakingly trying to debug it seems that there was traffic, probably from a bot scrapper, constantly scanning the filter queries “?filter_” and since it hits the DB, it would doing upwards of thousands of scans so it caused heavy RAM usage, high CPU, and caused the DB to eventually crash. I put in place on our Cloudflare setup to block the scrappers and that stopped the issue. The screenshot I attached shows the traffic seconds after putting the block in place.

Edit: Forgot to mention but since this was scanning those queries so much it was difficult to get the debug log to catch anything since by the time I would restart services, the server would almost immediately crash again. I put in some heavy limitations now to hopefully prevent this in the future.

• This reply was modified 4 months, 1 week ago by adf_david.

Attachments:

You must be logged in to view attached files.

Thank you for sharing the details. This information will be helpful to us and other customers in preventing similar issues in the future.

[Author]

Posts