Huge wp_options table

  • Resolved snecz

    (@snecz)


    1 year, 10 months ago

    Hi, I have to websites with Rank Math that database is still increasing. The problem is with wp-option table. Could the problem be Rank Math?
    I have used this command in SQL:
    SELECT option_name, length(option_value) AS option_value_length FROM wp_options WHERE autoload='yes' ORDER BY option_value_length DESC LIMIT 10;
    and got this:
    rewrite_rules
    sd_data
    rank-math-options-titles
    wp_user_roles
    cron
    rank-math-options-general
    rank-math-options-sitemap

Viewing 1 replies (of 1 total)
  • Plugin Support Rank Math Support

    (@rankmathteam)

    1 year, 9 months ago

    Hello @snecz,

    Thank you for contacting support.

    Our plugin makes use of the wp_options table to save its settings but it’s hard to imagine that the settings from our plugin would increase the size of the database by a lot as we don’t have that many options to save in that database table.

    If you look closely at the data returned from that SQL query there are also other options mentioned there and some even with more data than our plugin.

    Rather than performing a selection based on a comparison of data inside the table, you should check the actual size of the options and you should see that our options are within a reasonable size.

    For example, on a clean installation, the rewrite_rules option will be roughly double the highest option from Rank Math.

    Hope this helps clarify your doubts.

    Don’t hesitate to get in touch if you have any other questions.

Viewing 1 replies (of 1 total)
  • The topic ‘Huge wp_options table’ is closed to new replies.