Akismet is one of the best anti spam plugin for WordPress. I’m using it since very long time, almost 5 years. I’m not sure why but there is a annoying bug in this plugin. It feels all SPAM comment’s data into WP_CommentMeta Table.
Every month I usually login to myPHPAdmin to delete all Akismet data from table because plugin is not flushing those old data automatically. Take a look at below images.
As mentioned here Purge Old Meta Data after 15 days.. But I guess it’s not working.
Akismet setting tab. Does that means Akismet Removes CommentMeta too?? I guess no 🙁
Another must read:
Take a look at this big saving after removing all Akismet meta data.
And again ~437 records within a day 🙁
Now the question is how to remove all Akismet’s CommentMeta data? Here is a simple SQL for the same.
Please perform DB Backup before applying below query.
Step1: Open MyPhpAdmin.
Step2: Checkout all Akismet data using select query.
select * from wp_commentmeta where meta_key like "%akismet_%"
Step3: If you are fine with this data execute delete query.
delete from wp_commentmeta where meta_key like "%akismet_%"