Support » How-To and Troubleshooting » [Resolved] wp_postmeta table size
10 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.
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.
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?
Regarding the UTW thing, see these two list posts from wp-hackers:
Apparently some manual cleanup had to happen.
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.
It seems i was hit by that bug. Need to figure out how to delete those hundreds if not thousands of extra UTW lines.
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:
Glad to hear you got it sorted out.
Mark this one as “Resolved” up top?
I missed that. Thanks HandySolo 🙂