Remove spam ghost entries using PhpMyAdmin (clears comment metadata)

Run this query on phpmyadmin regularly:

DELETE FROM wp_commentmeta WHERE meta_key

LIKE "%akismet%"

to get rid of excessive commentmetadata

ALSO THIS:

DELETE FROM wp_commentmeta WHERE comment_id

NOT IN (

SELECT comment_id

FROM wp_comments

)