1

My options table is 3.2 GB! I ran a query to delete transients (only 172 were there), and I repaired and optimized the table, but it barely made a change. How can I go about finding out what's making this table so huge?

I scanned the site with Wordfence and it came up clean. The site runs super slow, so I assume this table has something to do with that, but I don't know what to look for beyond the transients.

Thanks!

8
  • Do you have huge number of rows too? I've e.g. seen a plugin store large sitemaps xml in the options table.
    – birgire
    Commented Apr 26, 2017 at 21:13
  • @birgire, there are 5,193,111 rows. Crazy.
    – LBF
    Commented Apr 26, 2017 at 21:18
  • I guess I would try to briefly scan it (manually or with sql) to find out what kind of options are exploding in numbers.. Then figure out if it's core, theme or plugin related.
    – birgire
    Commented Apr 26, 2017 at 21:23
  • Just tried the plugin "Delete Expired Transients" to see if I missed anything, and it found 2.5 million "obsolete woocommerce sessions from 2.4 and earlier" so I am deleting those now.
    – LBF
    Commented Apr 26, 2017 at 21:24
  • 1
    Remember to backup before testing/deleting anything from your db!
    – birgire
    Commented Apr 26, 2017 at 21:25

3 Answers 3

2

Check out this thread wp_options is GB in size My wp_options table dropped from 670GB to 13.5MB after running the optimization commands they outlined

1

As per the poster, the problem was woocommerce not discarding sessions from the options table after they have expired.

0

There may be different reasons your DB being too heavy. Have you being tried with cleaning your DB with wpoptimize plugin? This might help you!

1
  • I try that, with my 8Mio. entries in the transient database table, but the plugin only deleted about 20 transient entries
    – rubo77
    Commented Nov 23, 2022 at 5:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.