Akismet bloating SQL database

  • Resolved joetaxpayer

    (@joetaxpayer)


    11 years, 9 months ago

    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

    (@joetaxpayer)

    11 years, 9 months ago

    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.