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);
DELETE FROM wp_commentmeta WHERE meta_key LIKE '%akismet%';
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.