Home Forums WoodMart support forum WOODMART_Widget_Layered_Nav Unoptimized

WOODMART_Widget_Layered_Nav Unoptimized

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #709627

    adf_david
    Participant

    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.

    #709647

    adf_david
    Participant

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

    #709662

    Artem Temos
    Keymaster
    Xtemos team

    Hello,

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

    Kind Regards

    #709791

    adf_david
    Participant

    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.
    #709924

    Artem Temos
    Keymaster
    Xtemos team

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

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

The topic ‘WOODMART_Widget_Layered_Nav Unoptimized’ is closed to new replies.