Split: Database size

#152372
  • Resolved Nicod

    3 years, 2 months ago

    Rank Math free

    Hi,
    I have also a problem with the database-size. I’m very happy with the Rank Math plugin. It hugely improved the seo-aspects of my site. However, when I look into Myphpadmin I see a huge amount of data is generated. The table rank_math_sc_analytics is 147,3 Mib with 928044 records, which is more than half of my database size.
    And the table rank_math_analytics_gsc is 29,6 Mib with 94.387 rows, which is not that much of a problem, but the data usage by rank_math_sc_analytics is a problem. What can I do to resolve this?
    I’ve removed the connection between RM and Google Search Console (removed the GSC Verification id)
    I am using version 1.0.57.1

Viewing 5 replies - 1 through 5 (of 5 total)
  • Reinelle

    3 years, 2 months ago

    Hello,

    Thank you for contacting Rank Math and bringing your concern to our attention. I’m sorry for the delay and for any inconvenience this issue may have caused you.

    The new Analytics module in Rank Math, which replaced the Search Console module, no longer uses the rank_math_sc_analytics table in the database. So, you can safely empty or drop (delete) the table if you are using Rank Math’s latest version.

    Note that we always recommend when working with databases, you have to be extra careful. I would recommend you create a backup before proceeding.

    I hope that helps. Thank you, and please don’t hesitate to contact us if you need further assistance.

    Nicod

    3 years, 2 months ago

    Rank Math free

    Hi Reinelle,

    Thanks for the answer. I did a database export before removing it, just to be safe 🙂

    And another table rank_math_analytics_gsc takes up 30 MB and consists of 94387 tables. Can I safely remove or clean that one from my database?

    with kind regards,
    Nico

    Reinelle

    3 years, 2 months ago

    Hello,

    Thank you for the follow-up.

    Yes, you can empty that table since you have mentioned that you already disconnected your site from your Google account. Please also disable the Analytics module in Rank Math > Dashboard:
    Analytics Disable Module

    I hope that helps. Thank you, and please don’t hesitate to contact us if you need further assistance.

    Nicod

    3 years, 2 months ago

    Rank Math free

    Thanks for the great support!

    with kind regards,
    Nico

    Reinelle

    3 years, 2 months ago

    Hello,

    You are very welcome. We are super happy that we have addressed your concerns. 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 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.

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

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