Title: Fix huge SQL tables
Last modified: December 26, 2022

---

# Fix huge SQL tables

 *  Resolved [org site](https://wordpress.org/support/users/artpresso/)
 * (@artpresso)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/fix-huge-sql-tables/)
 * Hi, I need some assistance with submitting a query in SQL to clean out the scheduled
   actions that are not happening in my woocommerce database and eating up all my
   storage.
 * The tech at sitground already helped me identify that the woocommerce database
   is over 1g.
 * I had facebook for woocommerce installed as a plugin and I just deleted it to
   hopefully help, but i was hoping to get some guidance from a developer to help
   guide me through this because I know optimizing a data base can be sensitive 
   and I do not want to distroy my site.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ffix-huge-sql-tables%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Support [vupdraft](https://wordpress.org/support/users/vupdraft/)
 * (@vupdraft)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/fix-huge-sql-tables/#post-16326128)
 * I would suggest starting by running all the DB optimisations in the plugin.
 * By the sounds of it you need to optimise the action scheduler claim in your DB
 * With the Premium plugin, you can optimise individual tables but with the free
   version you can only optimise the entire DB. There are also some power tweaks
   in the Premium version that you may want to consider at a later date.
 * We also tend to find that tables such as the postmeta table can become unnecessarily
   large (optimising your DB would help with this)

Viewing 1 replies (of 1 total)

The topic ‘Fix huge SQL tables’ is closed to new replies.

 * ![](https://ps.w.org/wp-optimize/assets/icon-256x256.png?rev=1552899)
 * [WP-Optimize – Cache, Compress images, Minify & Clean database to boost page speed & performance](https://wordpress.org/plugins/wp-optimize/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-optimize/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-optimize/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-optimize/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-optimize/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-optimize/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [vupdraft](https://wordpress.org/support/users/vupdraft/)
 * Last activity: [3 years, 5 months ago](https://wordpress.org/support/topic/fix-huge-sql-tables/#post-16326128)
 * Status: resolved