WordPress.org

Ready to get started?Download WordPress

Forums

How to clean a bloated wp_options table (2 posts)

  1. Ryan Cowles
    Member
    Posted 1 year ago #

    Hello,
    I have recently noticed that my wp_options table seems to be a bit large. It contains 1161 rows, and is about 2.1mb in size.

    I have installed Clean Options. It looks like development stopped on the plugin back in 2010, but it still did the job.

    I now have a long list of potentially orphaned entries. Is there an easy way to go about sorting these, and figuring out which to remove and which to keep? Also, could this be responsible for causing performance issues with the website?

    Thank you for reading, any ideas are welcomed!

  2. Ryan Cowles
    Member
    Posted 1 year ago #

    Update: The Clean Options plugin returned some transients in the list, which lead me to find out that there are several hundred transient files in the wp_options table. There are a whole bunch that look like:

    _site_transient_browser_5728a0f1503de54634b3716638...
    _site_transient_timeout_browser_03df11ec4fda7630a5...
    _transient_feed_83dcaee0f69f63186d51bf9a4...
    _transient_plugin_slugs
    _transient_timeout_feed_83dcaee0f69f63186d51bf9a4b...

    and so on. Like I said, there are several hundred rows that take look like this. Is it safe to just dump them?

    Thanks

Topic Closed

This topic has been closed to new replies.

About this Topic