Fix huge SQL tables

  • Resolved org site

    (@artpresso)


    3 years, 4 months ago

    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 to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Support vupdraft

    (@vupdraft)

    3 years, 4 months ago

    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.