I started digging into the database side of my site because I started seeing comments not being flagged as spam. In addition, when attempting to either delete spam or even mark pending comments as spam (10 at a time) I was getting timeouts after 30 seconds. Pending comments were indicating that they were waiting for a spam determination.
The shotgun approach of disabling all plugins let me do some cleaning after I saw a mention from someone of a plugin that was firing on every deletion event, but I still have ~67,000 (garbage) entries in postmeta and based on the meta_keys it looks like it's Jetpack that's putting them there, since those keys are found in the Jetpack plugins.
Based on a query for the _feedback_author key, there are about 6700 rows with that key, with values such as this:
meta_id post_id meta_key _meta_value
76248 8139 _feedback_author yymovcom87
I'll note that I have under 50 actual posts/pages on the site and under 500 actual comments, so the post_id of 8139 strikes me as odd.
Is this a case of something getting out of whack and just leaving junk behind that has to be manually cleaned up? Any suggestions on how to clean those out without actually nuking data that should be kept?
I also have a ton of entries in the posts table, with post_type of 'feedback' and a post_status of 'spam'.
Am I just missing something obvious?