Rand Math puts a lot of load on the database with like queries

  • Resolved EdKrasnov

    (@alshoker)


    1 month ago

    Good afternoon, dear developers!

    In the mysql-slow.log file, I found a lot of slow like queries from rank_math_robots to the database, which hangs my server https://skr.sh/sSHyZf2f2da

    The plugin creates approximately 3-4 requests per minute, for 6-8 seconds. every request. Why is this happening and what can be done or disabled?

    I have almost everything disabled already: https://skr.sh/sSHhxRCTrXx

    I use the LSCache caching plugin, 12 cores and 32 GB of RAM. There are more than 200,000 articles on the site.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter EdKrasnov

    (@alshoker)

    Slow queries with like %something% are not indexed. How do I turn them off?

    Thread Starter EdKrasnov

    (@alshoker)

    I have already deactivated the Rank Math plugin, the Analytics module has also been disabled, but tasks continue to appear in Scheduled Actions as well. How to stop all this madness???? https://skr.sh/sSJ8C6qFZ7m
    My website is hanging. Why don’t you warn me that your plugin creates such a heavy load on the site and database? (

    frankfer

    (@frankfer)

    I think i’m going to follow your thread and see if whatever answer they give you can work for me too.

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @alshoker,

    Thank you for contacting Rank Math support.

    1. For the sitemap generation to work correctly our plugin needs to check the robots meta settings for each of the posts/pages on the website to know which ones it should add to the sitemap.

    At the moment we don’t have a temporary patch or a changed query that could result in faster results. The query is done like this because we need to get the information for the sitemap generation to be accurate.

    You can try indexing the MySQL entries to speed up the queries using the following plugin: https://www.ads-software.com/plugins/index-wp-mysql-for-speed/

    Please make sure that you take a complete backup if you want to try that method.

    1. The pending actions fetch the inspection data from your GSC account. Our plugin creates an action for each post to fetch the data. Since you have disabled the Analytics module, you can get in touch with your host and ask them to run an SQL query to delete the pending actions from the actionscheduler table of your database.

    Let us know how that goes. Looking forward to helping you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.