wp_posts

  • Resolved q120000

    (@q120000)


    11 years, 3 months ago

    I’ve used WP DBManager for some time on several sites and it works great! After optimizing, Overhead would always go to zero on all of my sites. But on a site that I have imported from Yahoo hosting onto where I host all of my sites, after optimizing the Overhead never goes below 4.0 MB for this one site. The overhead can grow above 4.0 MB and after optimizing it again will only go down to 4.0 MB.

    It’s not really a big site as far as databases go; having a total of 53 tables, 29,200 records, 6.2 MiB data usage, 2.7 MiB of index usage, and the 4.0 MiB Overhead. Most of the records are from a counter stat plugin.

    After optimizing, all of tables overhead go to zero except wp_posts. Here are the stats for wp_posts: records 398, data usage 2.5 MiB, index usage 64.0 KiB, and overhead of 4.0 MiB.

    Why won’t the wp_posts table go to zero?

    running WordPress 4.1.1
    WP-DBManager Version 2.75

    https://ww.wp.xz.cn/plugins/wp-dbmanager/

Viewing 1 replies (of 1 total)
  • Plugin Author Lester Chan

    (@gamerz)

    11 years, 3 months ago

    I have no idea, note that the overhead only works for MyISAM as far as I know.

    I have a a few sites on InnoDB and the overhead will always be there because InnoDB is different.

    You probably have to Google for it.

Viewing 1 replies (of 1 total)

The topic ‘wp_posts’ is closed to new replies.