Huge wp_commentmeta

  • Hi everybody.

    I’m an administrator of a server where we host a number of sites, including WP blogs. We’re just moving servers and I’ve noticed one of the tables – wp_commentmeta – of a relatively small blog is 4GB large.
    How could this be? He doesn’t seem to have many comments either.
    Is there anything I could do to trim the wp_commentmeta of excessive info?

    Thanks!
    Bazyli

Viewing 1 replies (of 1 total)

  • The Akismet plugin creates a ton of entries in wp_commentmeta. Try getting rid of all the spam comments from the admin panel. The meta entries attached to those comments will most probably be deleted automatically. If you want to do this using SQL then you will first have to run a query to delete all spam comments and then run a query to delete all the orphan entries in wp_commentmeta.

    Hope this helps.

Viewing 1 replies (of 1 total)
  • The topic ‘Huge wp_commentmeta’ is closed to new replies.