0

My WordPress has only 23 posts but the wp_posts data is over 70MiB. Is it the average size? The Posts I have were created with WPBakery Visual Composer and has 10 revisions. However, I deleted all the revisions with Revision Control but the wp_posts data size has no change.

--- update info on Apr 22, 2016 @ 12:12pm --
I found the wp_posts data it has over "60000+" rows of data.

-- update info on Apr 27th 2016 @ 5:02pm --
I removed and optimized all the revisions by Advanced Database Cleaner. I also changed "define('WP_POST_REVISIONS', 10 );" to "define('WP_POST_REVISIONS', false );" in wp-config.php, but the revision still coming back. Is there a way to stop them?

-- update info on Apr 28th 2016 @ 3:04pm --
After hours of research and plugin check, I found the revisions are created by FeedWordPress. After deactivate the plugin I dont see the new revision again.

  • Visual Composer is likely the problem. There is a very real expense to the convenience of that convenience. – jdm2112 Apr 22 '16 at 16:19
2

No, that isn't normal for 23 posts.

Note that "posts" is pretty wide concept in modern WordPress. Many things are posts without being obvious as such, for example parts of navigation menus.

While 60k entries does sound excessive for a small site, there is no telling without examining actual data to determine which post types it belongs to and if those entries are valid for some purpose or merely broken leftovers.

  • I found it also contained 1000+ events. The data size went down to 1.4MiB after I deleted all the revisions with "Advanced Database Cleaner". – CocoSkin Apr 22 '16 at 17:14
  • after deleting all the revision on live site the memory usage is back to normal now. :) – CocoSkin Apr 25 '16 at 15:54
  • I updated the question. They keep coming even I set the define(WP_POST_REVISIONS', false); in wp-config.php – CocoSkin Apr 27 '16 at 21:09
0

I don't think Visual Composer is the problem. Have you installed a logging plugin?

Open phpMyAdmin and simply delete them. They are likely a post type you dont use.

You can use the following query

DELETE FROM wp_posts WHERE wp_posts.post_type='suspected_posttype'

Make sure you don't remove the posta that are used by your site. Check what post types you use.

Also 'attachment', 'post', 'page', 'revision', ' nav_menu_item' so on are WordPress default - don't remove them.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.