WordPress.org

1. headlessspider
   Member
   Posted 2 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 2 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 2 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 2 years ago #
   

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

Topic Closed

This topic has been closed to new replies.