Database Table Size - Support

Resolved Dilip Kumar
3 years, 8 months ago

Rank Math pro

Hi,
Rankmath is one of the best plugins that I have used for SEO. But there is this one issue that I am facing.
My entire database is about 127MB in size out of which there are 2 tables that are about 80MB
wp_rank_math_analytics_gsc – 44.7MB
wp_rank_math_sc_analytics – 44.1MB

What do I do to reduce the size of the database?

Regards
Dilip

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

Jeremy
3 years, 8 months ago

Hello,

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

You can clear your database and fetch a fresh data from Google by heading to WordPress Dashboard > Rank Math > General Settings > Analytics and there you have to click on the Delete Data button and Update the data manually.

If you want to use less database space, you could set up Rank Math to cache less Analytics data by changing the following number of days to something less than 90:

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

Dilip Kumar
3 years, 8 months ago

Rank Math pro

Hi Jeremy,
Strangely RankMath seems to be doing a lot in the database.
I now see another table wp_actionscheduler_logs which is slowly swelling. It was around 400MB when I last checked and I emptied it. Now it is once again building up and is at 18MB. How do I stop this from happening. What are these scheduled actions that RankMath is running?

Danial
3 years, 8 months ago

Rank Math business

Hello,

The Scheduled Action acts as a cron for Rank Math. You can see it from WordPress > Tools > Scheduled Actions

Are you using an older version of Rank Math? Just to note, the new Analytics module in Rank Math, which replaced the Search Console module, no longer uses the wp_rank_math_sc_analytics table in the database.

I hope this resolves your issue.

Dilip Kumar
3 years, 8 months ago

Rank Math pro

Hi Danial,

The version I am using is Version 1.0.56.1

I did not quite understand what to do. The wp_actionscheduler_logs is once again swollen to a 60MB table. What do I do with it? How do I manage it?

Also, do you mean that it is now safe to delete the wp_rank_math_sc_analytics table?

Jeremy
3 years, 8 months ago

Hello,

Thank you for keeping in touch with us.

Before doing anything, let us check this one first over your admin settings with our developers. Please edit the first post on this ticket and include your WordPress admin, FTP, and your database admin logins in the designated Sensitive Data section.

It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

https://wordpress.org/plugins/temporary-login-without-password/

You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

https://wordpress.org/plugins/wp-security-audit-log/

We really look forward to helping you.

Dilip Kumar
3 years, 8 months ago

Rank Math pro

Hello,

I have updated the sensitive data as requested. Can you please check further?

Thank you.

Jeremy
3 years, 8 months ago

Hello,

Can you also provide your PHPMyAdmin login so that we can assess this issue with our developers?

Thank you and we are looking forward to helping you.

RankBot
3 years, 7 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 7 replies - 1 through 7 (of 7 total)

The ticket ‘Database Table Size’ is closed to new replies.