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.
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).