The WP Offload SES plugin is used to send site emails using the cheapest AWS SES service.
WP Offload SES Lite Plugin for WordPress
Below are the custom database tables that the WP Offload SES plugin uses;
wp_oses_attachments
wp_oses_clicks
wp_oses_email_attachments
wp_oses_emails
wp_oses_failures
wp_oses_jobs
The database table to check;
wp_oses_emails
From the WP Offload SES plugin settings, check that you are not storing 30+ days or email logging in your site’s database.
The ideal setting for log storage would be between 7 & 14 days. Otherwise, it can result in that database table being 20~30+ GB in size.
Settings > Offload SES > General
By using WP-Optimize, you can check the database table sizes in wp-admin;
WP-Optimize > Database > Tables
Advance Database Cleaner is another plugin that will allow you to empty out the WP Offload SES email database table from wp-admin.
Alternatively, the database table can be emptied by going into phpMyAdmin, which should be available from the control panel for your site hosting saving you the site’s database size by 20~30 GB.
The WP Offload SES plugin is a solid way to use the AWS SES service for sending out email broadcasts or for transactional site email.
Useful Links
- https://deliciousbrains.com/wp-offload-ses/doc/settings/#delete-logs
- https://deliciousbrains.com/wp-offload-ses/doc/uninstall-wp-offload-ses/
- https://docs.aws.amazon.com/ses/latest/dg/security-monitoring-overview.html
Do you know that the MainWP Maintenance extension allows you to clean the databases of your Child Sites? With just a few clicks, you can quickly delete all post revisions, auto drafts, trash posts, and spam comments, and remove all unwanted content from multiple databases at once.