admin管理员组

文章数量:1326474

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!

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!

  • database
  • options
Share Improve this question asked Apr 26, 2017 at 21:09 LBFLBF 5393 gold badges11 silver badges28 bronze badges 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
 |  Show 3 more comments

3 Answers 3

Reset to default 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

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

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!

本文标签： databaseMy options table is huge What can I do

版权声明：本文标题：database - My options table is huge. What can I do? 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1742209224a2433393.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。