Huge Bounce table in database

When is it ok to delete bounces? The bounce table has over 150,000 entries dating back to 2011.

The phpList database is significantly larger than the one for the site itself (1052.46MB). What can I do to reduce it? There are only about 2000 messages sent in total.

@coopersita Yes, you should delete bounces once phplist has processed them. You can do that on the View Bounces page.

Thanks. Should this be happening automatically? Am I missing some setting or rule somewhere?

@coopersita No bounce deletion does not happen automatically. I have a Housekeeping plugin that lets you delete bounces older than a certain period, so you might want to install that. But for it to be automatic you would need to create a cron job to run periodically.

See https://resources.phplist.com/plugin/housekeeping

1 Like