Last version = database overload

#286461
  • Resolved Dnikola
    Rank Math free

    Hello

    after updating to last version there is one query which kill my database

    We have more than million posts and this query need 10 sec to run

    http://prntscr.com/1yhhgbp

    it stuck and make more than 10000 request and DB server just stuck.

    I need to restart and to return to previous version of plugin..

Viewing 6 replies - 1 through 6 (of 6 total)
  • Hello,

    Thanks for contacting us and sorry for any inconvenience that might have been caused due to that.

    The query that you have mentioned is for Yoast’s FAQ block. It doesn’t seem related to Rank Math. Can you please confirm if you have enabled Yoast on your site?

    Looking forward to helping you.

    Hello,

    no i didn’t enabled yoast and I don’t have any code related to yoast.

    Before Rank math – 2 year ago approximately i used yoast.

    Thanks Nikola

    and it is 1000% related to your plugin.

    I just searched for a code

    http://prntscr.com/1yiku87

    -1 on more than million posts and 1000 visitors at any time.

    Really?

    Hello,

    We use that query to look for Yoast’s FAQ block and convert them to Rank Math’s FAQ block but it only happens when you import the data from Yoast. If you haven’t started the import then there must be some other plugin doing this. You can use this troubleshooting guide to check: https://rankmath.com/kb/check-plugin-conflicts/

    Let us know how that goes. Looking forward to your update.

    Thanks.

    I will investigate that but, I am peaty sure that is not triggered by 3rd party.

    You provide a bloated code and wait for someone to resolve problems which you didn’t make to work.

    I have one more problem

    http://prntscr.com/1yiojqh

    I have opened ticket 1y ago
    https://support.rankmath.com/ticket/w3-total-cache-flushing-cache/

    and this problem still persist, i need to comment this line of code each time I update plugin.

    Great 🙂

    Hello,

    The field ip is no longer available in the latest iteration of the plugin inside the 404 tables that our plugin generates.

    If your database still has this field this is likely what’s causing this issue on your installation.

    Regarding the ticket you mentioned there have been some improvements ever since on both fronts and calling the function to clear the cache sometimes it’s necessary to make sure that some actions can be performed correctly.

    Most caching plugins already perform those actions for example when you activate or deactivate a plugin.

    Don’t hesitate to get in touch if you have any other questions.

    Hello,

    Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

    If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

    Thank you.

Viewing 6 replies - 1 through 6 (of 6 total)

The ticket ‘Last version = database overload’ is closed to new replies.