November 11, 2013
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
)