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