wp_options table is too large in database

  • Resolved jambor

    (@jambor)


    4 years, 10 months ago

    Hello.
    My wp_options is about 1.7 gb!
    I have 3000 woocomerce pages and about 300 pages.
    I used every plugin available and I found many transient rows in the table and I deleted them all. but no change.
    Can anyone help me where the problem is?
    and is there any way to see the size of the rows or to see what rows are large?
    thank you all.

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    My bet is that your table is full of expired and unremoved transients.

    Install the “wp optimize” plugin and use it to remove the transients, then optimize the table.

    Simply deleting rows will not reduce the table size, just the number of rows. MySQL just marks deleted rows as deleted and doesn’t physically remove them. You need to optimize the table to do that.

    Thread Starter jambor

    (@jambor)

    Thanks for your reply sir. As I told I have used all the plugins. even some transients were not detected by plugins and I’ve manually removed them.
    I optimized the table after the delete process. but still no change.
    Could you please help me what can I do?
    thanks a lot

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    use PHPMYADMIN to look for “%transient%” rows in the table. While there, eyeball the last few hundred rows. Anything stand out?

    Thread Starter jambor

    (@jambor)

    I have located and deleted the transients files.
    its related to yith plugins and wp-rocket
    but I deleted them all and no change in the size.
    I really don’t know what to do.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    You’re going to have to manually look through that table and see if you can see what’s filling it up.

    Thread Starter jambor

    (@jambor)

    I found the problem,.
    it was related to wp rocket which has created 1.7gb unused files in wp_options with the name rocket_preload_batch
    Thanks

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Wow! Certainly worth talking to them about.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘wp_options table is too large in database’ is closed to new replies.