• Resolved hungvuviet

    (@hungvuviet)


    Recently, there are 2 queries suddenly ate up most of our Database CPU:

     SELECT * FROM wp_rank_math_redirections_cache WHERE BINARY from_url = ? LIMI…

    And

    SELECT * FROM wp_rank_math_redirections_cache WHERE object_id = ? AND object_type = ? LIMIT ?, …

    For example:

    select * from wp_rank_math_redirections_cache where BINARY from_url = ‘apple-touch-icon-120×120-precomposed.png’ limit 0, 1

    select * from wp_rank_math_redirections_cache where object_id = 13696 and object_type = ‘post’ limit 0, 1

    I am planning to add index for the table. But I don’t know if update the plugin can solve it. I’m using version 1.0.42.3

    And should we clear that cache table? There are a lot of junk from_url, like: echo wthcrq$ ... or $(nslookup .... Those look like from hackers

    • This topic was modified 7 months ago by hungvuviet.
    • This topic was modified 7 months ago by hungvuviet.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @hungvuviet,
    ?
    Thank you for contacting Rank Math support.
    ?
    You are using a 4 year old version of our plugin. Please update the plugin to the latest version, and the issue should be resolved after that.?https://rankmath.com/changelog/free/
    ?
    Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.

    Thread Starter hungvuviet

    (@hungvuviet)

    I’m using WordPress 5.4.15. Could you please let me know what is newest version that still support WordPress 5.4.15? Thanks!

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @hungvuviet,
    ?
    The latest version compatible with that version of WordPress is 1.0.201.1 which was released about 7 months ago.
    ?
    Having said that, we highly recommend looking for the possibility of updating WordPress on your website as we cannot provide support for such older versions because they might contain legacy code.
    ?
    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘RankMath query eats up CPU’ is closed to new replies.