Title: Big database size Last modified: March 13, 2023 --- # Big database size * Resolved [saksoba](https://wordpress.org/support/users/saksoba/) * (@saksoba) * [3 years, 2 months ago](https://wordpress.org/support/topic/big-database-size/) * Based on WP Optimize, WP-SES database is almost 35GB. * [https://www.linkpicture.com/q/WP-SES.png](https://www.linkpicture.com/q/WP-SES.png) How do I purge? I already set to clear the logs within 30 days and now set to 7 days, but the database size remain. Is there a quick fix for this? Thanks. Viewing 6 replies - 1 through 6 (of 6 total) * Plugin Author [Delicious Brains](https://wordpress.org/support/users/deliciousbrains/) * (@deliciousbrains) * [3 years, 2 months ago](https://wordpress.org/support/topic/big-database-size/#post-16553243) * If you’re sending a large number of emails per day, and previously had the log retention set to a higher level such as 2 years, then it could take quite a while for WP Offload SES to work its way through that backlog of items to remove. * It may also be a case that it’s unable to remove anything because it is hitting a problem. * If you’re not seeing anything being removed, please ensure you have debug logging turned on and look for errors that might indicate problems with removing items from the log. * -IJ * [sangemaru](https://wordpress.org/support/users/sangemaru/) * (@sangemaru) * [2 years, 9 months ago](https://wordpress.org/support/topic/big-database-size/#post-17008759) * We are also facing this issue. The plugin is generating gigabytes of logs per week (or per day if we broadcast a lot of emails) and we would love to disable this logging entirely, because it puts enormous load on the database, and we already have other logging systems. * We have set log retention to 7 days but it doesn’t delete anything, just keeps logging more. * We are constantly emptying the _oses_emails table. - This reply was modified 2 years, 9 months ago by [sangemaru](https://wordpress.org/support/users/sangemaru/). * Plugin Support [Delicious Brains Support](https://wordpress.org/support/users/dbisupport/) * (@dbisupport) * [2 years, 9 months ago](https://wordpress.org/support/topic/big-database-size/#post-17016010) * Hi [@sangemaru](https://wordpress.org/support/users/sangemaru/) , * Could you confirm for us that records in the _oses_emails table are not getting deleted even if they’re more than 7 days old? * In the latest version there’s also now an option for 1 day, have you tried changing to that to see if it helps? * I would also recommend following my colleague’s advise of enabling debugging on your site to see if there are any issues clearing that table. * [Élisson Costa](https://wordpress.org/support/users/nossileee/) * (@nossileee) * [2 years, 5 months ago](https://wordpress.org/support/topic/big-database-size/#post-17285709) * Hello! I’m trying to trouble here too. * I started using Amazon SES a few weeks ago with its plugin, and it’s increasing the database too much, I went to investigate and saw that it’s all about the “ oses_emails” table. * I put logs for 1 day, and it still doesn’t change. * I did this on 2 sites, and Cron is activated correctly on the Server, everything works fine… It’s just this cleaning of the plugin logs that doesn’t seem to work. * Is there no way to disable this registration? * Or an easy log clear button? * Plugin Support [Delicious Brains Support](https://wordpress.org/support/users/dbisupport/) * (@dbisupport) * [2 years, 5 months ago](https://wordpress.org/support/topic/big-database-size/#post-17287538) * Hi [@nossileee](https://wordpress.org/support/users/nossileee/), * Can you also enable debugging to see if there are any issues clearing the oses_emails table? * [https://wordpress.org/documentation/article/debugging-in-wordpress/#example-wp-config-php-for-debugging](https://wordpress.org/documentation/article/debugging-in-wordpress/#example-wp-config-php-for-debugging) * To force the delete logs cron event to process, you may edit the “deliciousbrains_wp_offload_ses_log_cleanup” cron event using something like [WP Crontrol](https://wordpress.org/plugins/wp-crontrol/) to set it to run “Now”. * [Élisson Costa](https://wordpress.org/support/users/nossileee/) * (@nossileee) * [2 years, 5 months ago](https://wordpress.org/support/topic/big-database-size/#post-17287794) * Hello! * I see that it worked now. * One site, I changed it to clear the logs 1x a day, but nothing happened (maybe because it takes 1 day for this to happen). * On the other site, I changed it to 1 day too (as it was 30 days), and I didn’t clean anything manually… * This morning I came to consult, and saw that it had already been cleaned. (as I would clean the manual too). * For me it seems to work yes, what happens is that it takes many hours to clean or run it. * But everything seems right now. * Thank you very much. Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Big database size’ is closed to new replies. * ![](https://ps.w.org/wp-ses/assets/icon-256x256.jpg?rev=2070048) * [WP Offload SES Lite](https://wordpress.org/plugins/wp-ses/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-ses/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-ses/) * [Active Topics](https://wordpress.org/support/plugin/wp-ses/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-ses/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-ses/reviews/) * 6 replies * 5 participants * Last reply from: [Élisson Costa](https://wordpress.org/support/users/nossileee/) * Last activity: [2 years, 5 months ago](https://wordpress.org/support/topic/big-database-size/#post-17287794) * Status: resolved