wp_options table bloated

  • osowande

    (@osowande)


    15 years, 3 months ago

    Hello,

    I had my hosting account suspended due to slow running queries on MySQL.

    I’m no MySQL expert, but I think we’ve pinned down what the problem is, my wp_options table is 20MB large, which I understand is huge, that is the table where the slow running queries are running on.

    As I no longer have access to my blog, all I have is the native cpanel tools to work on the database.

    Does anyone know how I can resolve this, is it safe to empty this table?

    Thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)
  • MichaelH

    (@michaelh)

    15 years, 3 months ago

    Does anyone know how I can resolve this, is it safe to empty this table?

    Not knowing plugins and widgets installed makes that hard to answer, but the table really can’t be emptied as it does contain needed values such as home and siteurl.

    One approach:
    1. In wp-config.php, change the $table_prefix to a new value. Remember the old value.
    2. Visit yourdomain.com/wp-admin/install.php and let WordPress install a new blog for you.
    3. Look at the new ????_options table to see what values are really needed (at that point you could export that options table, change the table name reference to the old options table and import the rows as the new table)
    4. Change the wp-config.php $table_prefix back to the original value.

    alwyn-botha

    (@alwyn-botha)

    15 years, 3 months ago

    Good info from MichaelH

    Here are some additional insights from another moderator Otto, and others.

    http://wordpress.org/support/topic/173256?replies=14

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wp_options table bloated’ is closed to new replies.