Help. I can no longer back my site up because Akismet is flooding my wp_postmeta table with data. Over 700,000 entries total already. The metakey is _bbp_akismet_as_submitted — looks like its related to BBpress. Is it safe to delete all _bbp_akismet_as_submitted entries from my table to clean it out? How do I prevent this from happening in the future?
In the WP Akismet plugin, we actually schedule an automated cleanup of the equivalent
comment_metarecords after a while, because they are large, and not useful once some time has passed.
The ones you see are indeed for bbPress’ Akismet handling. I’d say it’s ok to delete old ones, but since we do not develop the bbPress integration, I’m asking their dev community in WordPress’ Slack instance, here.
In the WP AK plugin, we have a scheduled function Akismet::delete_old_comments_meta() to delete old akismet_as_submitted
meta records, because they are pretty large, and not useful at all after a while.
What would you think about implementing the same thing in the bbPress AK code?
More immediately, can I tell that user that it’s fine to delete older entries?
And if so, what amount of time would you suggest he keeps them for (15 days in the WP plugin, but filterable)?
You can follow that Slack thread to get it straight from the horse’s mouth, but I’ll update this forum thread with their answer as well, for the long term record.
Follow-up: you can feel free to delete all of those that are two weeks or older.
We’ll be submitting a ticket/patch with code that will replicate for bbPress what is being done with the equivalent data in WP comments, too.
bbPress ticket and patch, but it looks like their team will take that over, and get even fancier with it. 🙂
Hi @stephdau thanks so much for the reply and assistance on this. I hope BBPress can get something implemented quickly because this table is getting so massive.
- The topic ‘Akismet flooding my wp_postmeta table’ is closed to new replies.