WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] how do i clean up wp_commentmeta? (4 posts)

  1. headlessspider
    Member
    Posted 3 years ago #

    i was looking at my database tables and i noticed that the wp_commentmeta is taking approximately 5,000 Kb of space. this is strange because the wp_comments table itself is only 80.48kb in size. there is bound to some garbage in the wp_commentmeta table.

    is it safe to just purge it?

    thanks for reading.

  2. dannoll
    Member
    Posted 3 years ago #

    I was experiencing something similar. It might be related to an Akismet bug. See this thread:
    http://wordpress.org/support/topic/akismet-update-caused-huge-database-size-growth?replies=36

    I upgraded to the latest version of Akismet, then I executed the SQL query (in the link above) that clears orphaned records. If this doesn't help, I have no idea.

  3. headlessspider
    Member
    Posted 3 years ago #

    thanks dannoll. i looked at the askimet code (admin.php) installed on my server and it has the needed lines already so i don't think its related to askimet. i'll likely take a peek at the contents of the table to see what's in there.

    thanks for showing me the link.

  4. headlessspider
    Member
    Posted 3 years ago #

    i found the answer in this thread. thanks again n2fisher. :)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.