Title: Deleting wp_commentmeta
Last modified: August 20, 2016

---

# Deleting wp_commentmeta

 *  [Dave](https://wordpress.org/support/users/tlwh/)
 * (@tlwh)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/deleting-wp_commentmeta/)
 * I’m trying to reduce the size of my Database.
 * Aside from the usual post revisions, optimize and repair, I’ve come across several
   [posts ](http://wordpress.org/support/topic/akismet-update-caused-huge-database-size-growth?replies=39)
   about wp_commentmeta and akismet
 * I have 10mb of data in wp_commentmeta.
 * Can anyone confirm that deleting the content here is only deleting Akismet data?
   And nothing else.
 * > DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM 
   > wp_comments);
   > (no saving)
 * **
 * > DELETE FROM wp_commentmeta WHERE meta_key LIKE ‘%akismet%’;
   > (10mb saving)
 * I did this on a trial DB and the size of wp_commentmeta certainly went down to
   215kb. A substantial saving of 10MB.
 * However upon looking at the WP dashboard Akismet still has a record of
 * > Akismet has protected your site from 119,403 spam comments already.
 * Is this just a simple text file recording the number, or is there still data 
   somewhere? I was under the impression the two sql queries would make this 00.
 * I don’t need akismet at the moment as I’m using another very successful anti 
   spam tool, so I don’t mind the records being wiped.
 * No problem if it’s just a record, just looking for confirmation?
 * Likewise confirmation that deleting wp_commentmeta is not doing damage anywhere
   else?
 * All seems fine, just looking to confirm.

The topic ‘Deleting wp_commentmeta’ is closed to new replies.

## Tags

 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [wp_commentmeta](https://wordpress.org/support/topic-tag/wp_commentmeta/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [Dave](https://wordpress.org/support/users/tlwh/)
 * Last activity: [14 years, 6 months ago](https://wordpress.org/support/topic/deleting-wp_commentmeta/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics