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.
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.