@chadi – If there are entries from NextGEN Gallery still in the table then you could try re-activating NextGEN Gallery and go under Gallery > Other Options > Miscellaneous and clear the image cache … otherwise, I really cannot say what might be in the table or what might have written it there.
– Cais.
Thread Starter
Chad
(@chadi)
@photocrati
I don’t see that option anywhere. I’ve reactivated it. This is what I see
View post on imgur.com
What about these woocommerce tools?
View post on imgur.com
@chadi – Have you tried only having NextGEN Gallery active?
– Cais.
Thread Starter
Chad
(@chadi)
No, site is live and don’t want to interrupt it incoming orders (pretty much 24/7).
Thread Starter
Chad
(@chadi)
@photocrati
Would deleting entirely these inactive plugins clear that 1.1GB wp_options table significantly?
The 27 non-active plugins are
Akismet
Gizmo Store Locator
Go Daddy Quick Setup
Hello Dolly
Hyyan Admin Color Schema
Jetpack
LayerSlider
Maintenance (I installed this one actually)
NextGen
oAuth Twitter Feed
Previous/Next Post in Taxonomy
Regenerate Thumbnails
Revolution Slider
Taxonmy Metadata
UX Featured Item Post
WooCommerce Authorize.net CIM Gateway
WooCommerce Authorize.net Reporting
WooCommerce checkout Field Editor
WooCommerce Fedex shipping
WooCommerce PDF Invoices
WooCommerce Print Invoice
WooCommerce Sequential Order Numbers
WooCommerce Twilio SMS
WooCommerce USPS
Woo Sidebars
YITH WooCommerce Ajax Product Filter
YITH WooCommerce Wishlist
@chadi – Inactive plugins would not be (or they should not be!!) generating any entries into the database but that does not mean to say they did not generate them when they were active previously.
Did you try re-activating NextGEN Gallery and clearing the image cache? Did that have any affect on the table?
– Cais.
Thread Starter
Chad
(@chadi)
Hi @photocrati
I mentioned this a few days ago actually. “I don’t see that option anywhere. I’ve reactivated it. This is what I see” Clear image cache was nowhere to be found.
Thread Starter
Chad
(@chadi)
I just updated Nextgen to latest version and ran “clear all caches”. Only option I found. Didn’t affect the table though.
Thread Starter
Chad
(@chadi)
So I’m browsing that table in godaddy’s incredibly outdated phpmyadmin version. I do see a lot of these entries, not sure what they are.
http://i.imgur.com/7oKckoG.png
Thread Starter
Chad
(@chadi)
Found the solution! Thanks for your help in the process as well.
https://wordpress.org/support/topic/a-lot-of-wc-sessions?replies=18
Resolved!! Just finished running an update from 2.0.5 to 2.0.7, and there is now a new feature in Woocommerce > System Status > Tools, “Clear all sessions”(not listed on the dev log). Now instead of 2,000+ sessions, I only have what’s actually being used! I can only assume that little button was your idea, Mike — thanks for that, if you’re reading. Now I can sleep at night.
@chadi – Thanks for the update. Well done sorting this out yourself!!
– Cais.