最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

database - My options table is huge. What can I do?

programmeradmin2浏览0评论

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!

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!

发布评论

评论列表(0)

  1. 暂无评论