WordPress.org

Forums

The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

[resolved] wp_postmeta table size (9 posts)

  1. titanas
    Member
    Posted 9 years ago #

    The wp_postmeta curretnly using 14.2MB in the DB. Size wise this is the biggest table. I'm wondering if there is anything i can to so reduce the size of it.

    Information found on http://codex.wordpress.org/Database_Description doesn't help. Neither optimizing the DB via phpmyadmin.

    tia

  2. Les Bessant
    keeper of the Tiggers
    Posted 9 years ago #

    Do you have any plugins that write data in there? There was a release of Ultimate Tag Warrior that had a bug that caused it to flood that table.

  3. titanas
    Member
    Posted 9 years ago #

    I'm always using the latest Ultimate Tag Warrior when it's out. Currently i'm running on 3.14 .

    Other than that, i'm using Google Sitemaps, Simple Recent Comments, Feedburner Feed Replacement, Head META Description, Code Markup and Akismet.

    How do i know which one might causing the issue, if any issue?

    Do you agree that 14.2MB for a table is way too much?

    tia

  4. Chris_K
    Member
    Posted 9 years ago #

    Regarding the UTW thing, see these two list posts from wp-hackers:

    http://comox.textdrive.com/pipermail/wp-hackers/2006-August/007762.html
    http://comox.textdrive.com/pipermail/wp-hackers/2006-August/007763.html

    Apparently some manual cleanup had to happen.

  5. titanas
    Member
    Posted 9 years ago #

    That might makes sense since i was running the same UTW version. I've now updated to 3.1415. I'll check my table. Thank you.

  6. titanas
    Member
    Posted 9 years ago #

    It seems i was hit by that bug. Need to figure out how to delete those hundreds if not thousands of extra UTW lines.

  7. titanas
    Member
    Posted 9 years ago #

    The solution is:

    - Backup your site and your database
    - Update to the latest UTW version, currently 3.1415
    - Manage > Tag > Tidy Tags

    more info can be found here:
    http://www.neato.co.nz/archives/2006/08/10/ultimate-tag-warrior-3141/

  8. Chris_K
    Member
    Posted 9 years ago #

    Glad to hear you got it sorted out.

    Mark this one as "Resolved" up top?

  9. titanas
    Member
    Posted 9 years ago #

    I missed that. Thanks HandySolo :)

Topic Closed

This topic has been closed to new replies.

About this Topic