wp_options table size bloat after installing Rankmath

Hello,

Sorry for the trouble.

Is this issue still happening for you with the latest version of Rank Math? We released a new update on the 10th of October where we completely replaced the Search Console module with the new Analytics module, and for example the wp_rank_math_sc_analytics table is not used anymore.

Can you tell us with what kind of data does the wp_options table get filled? We may need to take a closer look at the issues, is it okay if we install a PhpMyAdmin plugin on your site to check the database?

Thank you. Looking forward to your response.

Hi Bella,

I have logged in to your site and installed the phpMyAdmin plugin from the official repository, then I took a look at the DB with it.

Right now your options table is about 1.9 GB, which is quite a lot but not excessive. But 41 GB is definitely too much, I’m not sure what happened there.

From the 1.9 GB, Rank Math’s rows (17 rows in total) takes up about 30 kb, so basically nothing. You can find the rows created by Rank Math with the following query:
SELECT * FROM appmpt_options WHERE option_name LIKE 'rank_math_%'

Then I checked which rows are taking most of the space, using this query:
SELECT * FROM appmpt_options WHERE 1 ORDER BY LENGTH(option_value) DESC LIMIT 10

It looks like the largest values seem to be related to the iThemes Security plugin (top 3 rows are itsec_online_files_hashes, itsec_file_change_latest, itsec-storage). But even these are about 2 MB each, so I’m not sure what makes up the 1.9 GB. Perhaps it’s a lot of these 1-2 MB rows (you have a total of 1210 rows in the table right now).

Since I don’t see any issue related to Rank Math on your site right now, I’m afraid I won’t be able to help here.
If there’s a specific issue we can see and reproduce, please let us know the steps we need to take, and we will continue our investigation.

I have deactivated the phpMyAdmin plugin on your site. You can safely delete that plugin.

Hope that helps. If you have any question, please feel free to ask. Thank you.

Hi,

Was the Analytics/Search Console module active when the issue was happening? If we can take a closer look at the issue and possibly try some changes in the code, we might be able to fix it.

Yes, you can safely delete the wp_rank_math_sc_analytics table if you are using Rank Math version 1.0.49 or later.

I’ll list here the tables used by Rank Math:

wp_rank_math_404_logs
wp_rank_math_analytics_adsense
wp_rank_math_analytics_dates
wp_rank_math_analytics_ga
wp_rank_math_analytics_gsc
wp_rank_math_analytics_keyword_manager
wp_rank_math_analytics_object_links
wp_rank_math_analytics_objects
wp_rank_math_internal_links
wp_rank_math_internal_meta
wp_rank_math_links
wp_rank_math_redirections
wp_rank_math_redirections_cache

Depending on what modules are active, some of the tables might not be in use. Also, your setup may have a different prefix instead of wp_.

Hope that helps.

Hi Bella,

You need to re-authenticate Rank Math to read and display your Analytics & Search Console Data after you update to 1.0.49 or later, because we changed the Search Console module, along with the permissions it requires from Google.

Please share the login details and let us know when the “database flooding” is happening again, and we will log in to your site to investigate it.

Thank you. Looking forward to helping you.