Akismet flooding my wp_postmeta table

Hi there!

In the WP Akismet plugin, we actually schedule an automated cleanup of the equivalent comment_meta records 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.

• This reply was modified 4 years, 6 months ago by Stephane Daury (stephdau).
• This reply was modified 4 years, 6 months ago by Stephane Daury (stephdau).

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.

Sure thing. ??