Question about tables with a big overhead

  • Resolved Lori Boone

    (@pleazo)


    2 years ago

    Hello,

    I have a few tables here with a big overhead (total overhead 49MB, 132 Tables, Total size of database: 363.70 MB).

    My questions are:
    1. The tables that do not have any plugins associated to them (ie: _1XN_postmeta). How can I reduce the overhead on these and optimize them?
    2. The tables that do have any plugins associated to them, how can I reduce the overhead on these and optimize them?

    • This topic was modified 2 years ago by Lori Boone.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support vupdraft

    (@vupdraft)

    1. You can do this by going to Database>>Optimizations >> Optimize database tables. This will optimise all tables in the DB regardless if wether they have a plugin associated with them
    2. In the Premium version, you can goto Database>> Tables and you can click “Optimize” to optimize the individual table (it will tell you what plugin it is associated with ). In the free version there is no way to optimise individual tables and you would need to optimise the entire DB as per point 1.

    Thread Starter Lori Boone

    (@pleazo)

    Hello @vupdraft

    But after I optimize them, the overhead is still there?

    Plugin Support vupdraft

    (@vupdraft)

    Hi,

    In which case the tables just have a lot of content in them (this is often the case with tables such as the post meta and the options tables). You will probably find that optimising them reduces the overhead but does not get rid of it completely.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Question about tables with a big overhead’ is closed to new replies.