Database size

#521
  • Resolved JM
    Rank Math free

    After installing RankMath, I saw a nearly 50% increase in my site’s database size. It came to around an increase of 17mb just from this plugin. And that’s beyond what I saw with Yoast, and it’s after I uninstalled Yoast and deleted all of its tables and meta data in the wp_postmeta table.

    Can you explain why that’s the case and what can be done to better optimize RankMath to minimize this issue? I’m particularly frustrated by this as we’ve spent weeks cutting down on plugins and cleaning up the database to decrease its size, and now this single plugin put it nearly back to where we started. It doesn’t make much sense for this to be happening when the plugin it’s replacing (which was well-known for its bloat) had nowhere near this impact on database size.

    Any explanation or help would be appreciated. Thanks.

Viewing 12 replies - 1 through 12 (of 12 total)
  • JM
    Rank Math free

    On further inspection, the problem seems to be with rank_math_sc_analytics. That’s where all the database bloat seems to be coming from.

    Can this be safely deleted without damaging general SEO improvements on the site? (I’m assuming it has to do with your analysis tool, which I’ve already disabled in the plugin settings.) Or are there other settings in the plugin that are causing this which I can disable?

    Thanks for your help.

    JM
    Rank Math free

    Problem solved.

    For anyone else concerned about their WP database size, the issue was a result of RankMath’s search console cache. Deleting the cache in the RM settings and disconnecting RM from Google’s search console integration would seem to be the solution if you don’t absolutely need to see your SC data in your dashboard. It’s inconvenient if you like the integration, but not worth the bloat it’ll cause for some sites, including mine unfortunately.

    It would be great if a notice or warning could be added to the Search Console box on the dashboard warning users of larger sites about the potential for it to significantly affect their database size before activating this perhaps.

    Hello Jenn,

    Sorry about the trouble this must have caused and we are glad you managed to fix it.

    We will see about tackling this problem in a future update.

    If you need help with anything else, please do not hesitate to let us know.

    Did you fix the problem? I just started using the plugin.

    • This reply was modified 3 years, 11 months ago by KWS Adams. Reason: edit

    Facing the same problem here. My table rank_math_sc_analytics contains more than 76 Mio entries.

    Alberto
    Rank Math business

    Hello,

    Thank you for contacting Rank Math and sorry for any inconvenience that might have been caused due to that.

    It is due to Rank Math caching Search Console data. You shouldn’t be worried about it since it is not too much disk space and Rank Math automatically removes old data from there.

    Anyway, if you still want to delete it, you should go to the WordPress Dashboard > Rank Math plugin Dashboard > General Settings > Search Console and there you have to click on the “Delete Cache” button. After that, on that same page, you have to remove the authorization to access the Search Console data.

    After that, Rank Math won’t bring you your Search Console data, so it won’t be saved on the database.

    You can do it as I show you in the following screencast: https://i.rankmath.com/uGfSDs

    If you prefer to keep that tool on (since it is really useful) but you want to use less database space, you could set up Rank Math to cache less Search Console data by changing the following number of days to something less than 90:
    rank math cache limit

    Looking forward to helping you. Thank you.

    ​​​​​​​

    John
    Rank Math free

    Hi All,

    Cache limiting doesn’t work. In our setup Rankmatch stored 229 days of cache while in the limit it was 90 days. Also, the rank_math_sc_analytics table size now is 130mbs and deleting cache from wp-admin doesn’t do anything.

    Todd
    Rank Math free

    Hello John,

    That means the cron jobs aren’t getting triggered for the flush to happen.

    You can manually remove that data from WordPress Dashboard > Rank Math > General Settings > Search Console

    or

    WordPress Dashboard > Rank Math > Status & Tools > Database

    Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.

    John
    Rank Math free

    Hi Todd,

    You were right about the cron. Followed your advice and it. worked like a charm.

    Thank you!

    Alberto
    Rank Math business

    Hello John,

    We are super happy that this resolved your issue. If you have any other questions in the future, know that we are here to help you.

    If you don’t mind me asking, could you please leave us a review (if you haven’t already) on https://wordpress.org/support/plugin/seo-by-rank-math/reviews/#new-post about your overall experience with Rank Math? We appreciate your time and patience.

    If you do have another question in the future, please feel free to create a new forum topic, and it will be our pleasure to assist you again.

    Thank you.

    CF
    Rank Math free

    So today I’ve learn that unfortunately Rank Math is not the right SEO plugin for large sites with big archives…

    – The search console insights are bloating the DB (one of the main option I’m interested with)

    – You cannot bulk update all your past posts to see their SEO scores and analyzed datas (the other option I really want)

    Anything else that doesn’t work properly for larges sites ?? (10yrs+ of archive)

    Im coming to realize that RM, Yoast or AIOSEO are not appropriate for large sites and you can come up with lighter solutions with small individual plugins (or snippets) that will take care of your meta tags, sitemaps and schemas!

    Hello,

    Thank you for contacting Rank Math today.

    -you can always clear the search console cache under Rank math > General settings > search console.
    -Some tests are run on page when opened and thus the bulk update option is not possible.

    You can always use the SEO plugin to improve your recent and upcoming posts without having to modify the posts in your past.

    Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.

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

The ticket ‘Database size’ is closed to new replies.