Title: Akismet bloating SQL database
Last modified: August 20, 2016

---

# Akismet bloating SQL database

 *  Resolved [joetaxpayer](https://wordpress.org/support/users/joetaxpayer/)
 * (@joetaxpayer)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/akismet-bloating-sql-database/)
 * My SQL database is getting large. I looked and saw there are 150 pages (at 30
   lines per page) of commentmeta data, which reference akismet history, as in “
   admin changed the comment status to delete”
 * Is there a plugin or other simple tool to clean this up? I tried removing Akismet
   for a while to try to delete the extra data, but it stayed. The advise I’ve seen
   so far suggests things beyond my ability. I can delete manually, but that would
   take quite a while.
    Curious why this is accumulating.

Viewing 1 replies (of 1 total)

 *  Thread Starter [joetaxpayer](https://wordpress.org/support/users/joetaxpayer/)
 * (@joetaxpayer)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/akismet-bloating-sql-database/#post-2887843)
 * Wow. Someone emailed a link to this info;
    Check this two SQL clean up script
   if you have Akismet plugin installed in your WordPress. The first one will clean
   up wp_commentmeta entries which have no relation to wp_comments. While the second
   one will clean up Akismet related metadata in wp_commentmeta table.
 * DELETEFROM wp_commentmeta WHERE comment_id NOTIN(SELECT comment_id FROM wp_comments);
 * DELETEFROM wp_commentmeta WHERE meta_key LIKE’%akismet%’;
 * I was able to run these and the bloat is gone.

Viewing 1 replies (of 1 total)

The topic ‘Akismet bloating SQL database’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 1 participant
 * Last reply from: [joetaxpayer](https://wordpress.org/support/users/joetaxpayer/)
 * Last activity: [13 years, 10 months ago](https://wordpress.org/support/topic/akismet-bloating-sql-database/#post-2887843)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics