Sweeping Settings

The SweepPress Settings panel has several subpanels with many useful settings you can use to control the plugin. There are 5 subpanels on the Settings page to start from.

Some of the settings are only available in the Pro version, so the Lite version has fewer subpanels on the Settings panel and fewer settings. This article shows all the Pro-related settings. Some of the settings here will enable additional features like: Sweeper Monitor, Query File Log, WP-CLI and REST API support.

Expand

This settings subpanel has only two options for enabling or disabling WP-CLI and REST API modules. If you need to sweep via WP-CLI or REST API, you should enable one or both options here. If not, leave them disabled.

Sweepers

This is the most important subpanel, because options are used for direct control over some of the sweeper’s behavior.

Database Optimization

This group of settings controls the Optimize Database sweeper. You can set the limits for the optimization detection, and by default, this sweeper will only show tables with 40% fragmentation or more, and only if these tables are 6 MB in size or more. Fragmentation for small tables is hard to control, so it is not useful to do it at all, but it should be done for larger tables.

And the plugin has 3 different methods actually to run the optimization, and you can pick the method you want to use here. It is best to enable the OPTIMIZE method, but if that doesn’t work well enough, try the other two methods. The other two methods can be a better solution depending on the server type (MySQL, MariaDB…) and server setup.

Number of days to skip

Many sweepers use these options, and they are essentially telling the sweeper to skip the most recent data from removal. For example, if you take into account the Auto Draft sweeper and have number of days to skip set to 7, the sweeper will only remove auto drafts that are older than 7 days.

Monitor

This panel will enable the use of the Sweeper Monitor feature. You have Daily and Weekly monitor, both having same settings, and you can use one or both monitors to get notifications when the sweeping threshold is reached, reminding you to sweep your database and recover some space.

Database

These settings affect the Database panel for SweepPress. Be careful with these options because they will enable DROP (as in remove table from the database) and TRUNCATE (empty table, as in remove data from it) options for use on the Database panel. Do not use this unless you understand what these options can do!

Advanced

From this panel, you can enable the use of Log File for Sweeper Queries, and you hide the notice about the Backup displayed on various SweepPress panels as a reminder that all removals are final. Unless you have the backup, you can’t change your mind after the removal is done.