Large Database File Generated

#122609
  • Resolved Ravi Chandra Verma

    3 years, 4 months ago

    Rank Math free

    Hi,
    On my Website Rankmath has made large database file like wp5n_rank_math_analytics_gsc & wp_rank_math_sc_analytics.
    So can i delete these two tables & turn off Analytics in Rankmath->Dashboard->Analytics.
    Cause i am also getting lots of memory usage there i found rankmath created more 500mb database something on each of these above mentioned.
    Also deleting them wont cause any issue on SEO Site cause there are analytics only… Correct me if i am wrong
    Please Help..

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

    3 years, 4 months ago

    Hello,

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

    I suggest that you shouldn’t directly delete that table in the database as it sometimes causes an error.

    I can only suggest this:

    When the Analytics module is working, it will store data to your website so that you can keep track of the insights. Rank Math will automatically delete that once the data expires.

    If you still want to delete it, you should go to the WordPress Dashboard > Rank Math > General Settings > Analytics and there you have to click on the “Delete Data” button.
    analytics

    Like you said, deleting them won’t be causing any issue on your end since they are just analytics data.

    After that, you may disable the analytics module in the dashboard to completely remove the storing of data from Google.

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

    Ravi Chandra Verma

    3 years, 4 months ago

    Rank Math free

    I have Deleted one database file name “wp5n_rank_math_sc_analytics” doing that memory usage on my hosting goes to half https://drive.google.com/file/d/19ISoa_itI_5Rr0DldAqFZFDKh5j8bzak/view?usp=sharing

    Can you please is it also safe to delete wp5n_rank_math_analytics_gsc wont affect & anything on my site. I have turned off Analytics in Rankmath->Dashboard->Analytics.

    Michael Davis

    3 years, 4 months ago

    Rank Math pro

    Hi,

    Did you try deleting the data from Rank math > General Settings > Analytics as shown in the previous reply?

    You can try deleting the table to see if it makes any difference. If there are any arising issues on the same, you can recreate the tables in Rank math > Status & Tools > Database Tools > Recreate missing tables

    Hope this helps.

    Ravi Chandra Verma

    3 years, 4 months ago

    Rank Math free

    Hi,
    I have removed two table from database where were using soo much cpu & memory usage & Now removing now its fine.
    Upon looking on wp_options database table. I found rank_math_analytics_all_services is on autoload “yes” so can it make it autoload to “no”. as this seems to me related to analytics. So doing so wont effect on SEO.

    Uzair

    3 years, 4 months ago

    Hello,

    You can try setting it to no, but after you deleted earlier the standard way to disable Analytics is to turn it to Off from RankMath > Dashboard> Analytics and it should disable everything related to it.

    I hope this helps resolves your issue.

    RankBot

    3 years, 3 months ago

    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 5 replies - 1 through 5 (of 5 total)

The ticket ‘Large Database File Generated’ is closed to new replies.