Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I'm using database peek http://wordpress.org/plugins/database-peek/ to show my database structure and have noticed that wp_postmeta has 95073 rows in it.

I noticed that a large part of them have empty values in it. Most of these are caused by a plugin that has custom fields with no meta data in it so it seems to be storing these with no value. It seems to me that they are not needed.

Is it possible or more importantly, smart to get rid of these? I've optimized the database and thought that it may fix the problem but it does not which makes me think that maybe it could be dangerous for me to delete them.

If it is ok to do, how could I do it? Would a sql command be the best way to do it and if so, what would the command be?

Thanks!

share|improve this question
1  
I answered a similar question not too long ago: wordpress.stackexchange.com/a/113637/21376 –  s_ha_dum Sep 25 '13 at 20:33

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.