Blog Post

SweepPress 1.2 (Lite and Pro)

The second update for SweepPress is here, for both Lite and Pro editions. The first updated added Akismet Meta records sweeper, and this second release refines existing features and expands with additional useful information.

Both Pro and Lite versions got exactly the same changes this time around, but soon, the Pro version will start getting more exclusive features. Check out the end of this post for more information.

One of the questions I had in the past 2 weeks is related to improving information related to the size of removed data in comparison to the overall data. It is a very useful metric to have and avoid making sweeps too often. So, if the sweeper affects one or two or more tables, we take the total size for data of affected tables and compare it to the estimated size to be removed, and get the estimated percentage now displayed for each sweeper in the bottom right corner.

Updated Sweep panel

The help information displayed for each sweeper has been updated, and expanded in a few cases, with the list of affected database tables displayed more prominently and easier to find. The calculation for the Optimize Tables sweeper has been completely rewritten, and now takes into account the size of data and index for each table, and also attempts to get more accurate results (MySQL is very unreliable for getting precise statistics for tables when using InnoDB engine, and statistics is never real-time). Finally, a new option is added for control of the Optimize Tables sweeper with a new limiter for the minimal size of the database to be taken into account and counted as fragmented (because small tables with a lot of activity, will always have overhead, that’s how MySQL InnoDB is working).

And, plans for the next features exclusive for the Pro version have been made and two major new features are coming in the next month or so, split into two releases, so stay tuned for that (the first release comes in about 2 weeks, and the second one 2 weeks after that).

To see the list of all the changes in this version, please check out the changelog. If you find any issues with the new version, please, report them in the support forums.

Please wait...
SweepPress Pro
Powerful database cleanup for WordPress

Remove various old, unused or obsolete data from the database, optimize the database for best performance. Schedule cleanup tasks to run automatically.

About the author

Milan Petrovic
Milan Petrovic

Programmer since the age of 12 and WordPress developer since 2008 as freelancer and author of more than 200 plugins and more than 20 themes.

The Newsletter

Leave a Comment

Grammarly - Number 1 Writing App
GeneratePress - The perfect lightweight theme for your next project