WordPress.org

Forums

Optimize Database after Deleting Revisions
[resolved] Post Meta Orphan Question (4 posts)

  1. Shawn33
    Member
    Posted 1 year ago #

    Hi, I was previously using "Revision Control" but just switched to this instead.

    I don't know much about how WP databases work, so I apologize if this is a dumb question...

    I saw that someone in the support forum for that plugin said it was only deleting data from the wp_posts table and leaving everything in the wp_postmeta table.

    I noticed my wp_postmeta table has over 2,700 rows and I only around 40 posts, so I figured I had the same problem and decided to try this plugin instead.

    When I ran this plugin I expected it would get rid of most of those rows but it only deleted around 9 or so.

    Does that mean all those other rows are necessary, or is this plugin just not catching the useless ones for some reason?

    Thanks,

    Shawn

    http://wordpress.org/extend/plugins/rvg-optimize-database/

  2. cageehv
    Member
    Plugin Author

    Posted 1 year ago #

    Hey Shawn,

    Deleting 'Post Meta Orphans' means:
    All rows in the wp_postmeta table which don't have a corresponding row in the wp_posts table will be deleted.

    So, it looks like all these 2700 rows are related to one of these +/- 40 posts. Is that correct?

    Peace,
    Rolf

  3. Shawn33
    Member
    Posted 1 year ago #

    Hey Rolf, thanks for the reply and the insight. It does look like all the wp_postmeta rows have a post id that corresponds to a post id also found in wp_posts. So I guess everything looks good then.

    I think what confused me is that I only have 40 posts but the wp_posts table actually has over 400 rows. I didn't realize all my media uploads are also contained there as well.

    Thanks again for the help,

    Shawn

  4. cageehv
    Member
    Plugin Author

    Posted 1 year ago #

    Hey Shawn,

    Glad I could help!

    Peace,
    Rolf

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic