Clean up WordPress database with WP-Sweep plugin.
After a long time of publishing new articles, changing themes and adding and removing plugins, your WordPress database can be contaminated with unused, “orphaned” data. and duplicate data. Not all plugins and themes completely remove it and its data from your site when you remove them.
Explore more:
- Top 3 best plugins to clean up WordPress Database
- Delete unused records in WordPress database
Lester Chan ‘s new plugin , WP-Sweep , has been designed to help you get rid of all of the above. Chan is a pretty well known plugin developer who created his first plugins back in 2003, shortly after WordPress was forked from b2 . Currently, he has more than 24 plugins listed in the WordPress plugins directory .
What makes WP-Sweep different is that it prioritizes using WordPress ‘ delete function as much as possible, instead of directly deleting MySQL queries . This method is in stark contrast to plugins with the same functionality, such as WP-Optimize .
What can the WP-Sweep plugin clean up?
WP-Sweep uses WordPress ‘ delete function , such as wp_delete_post_revision() , delete_post_meta() , wp_delete_comment() , etc. to clean up the database. It can perform cleanup for all of the following:
- Revisions
- Auto drafts
- Deleted comments
- Unapproved comments
- Spammed comments
- Deleted comments
- Orphaned post meta
- Orphaned comment meta
- Orphaned user meta
- Orphan term relationships
- Unused terms
- Duplicated post meta
- Duplicated comment meta
- Duplicated user meta
- Transient options
Optimize WordPress Database with WP-Sweep . plugin
Once installed and activated, you can find the Sweep option in the Tools section of the WordPress Dashboard . It will give you a complete overview of the items that can be cleaned up for database optimization.
Options include cleaning up posts, comments, users, terms, and options. You just need to click on the ” Sweep ” button corresponding to the item you want to clean. The drawback of this plugin is the lack of a ” Sweep All ” button to clean all items at once. Hopefully it will be added soon in upcoming versions.
Note : Please perform a database backup before starting to clean up to ensure data safety. However, the actual use shows that this plugin almost does not cause any unfortunate problems for the database of WP Basic , so you can use it with peace of mind.
Which plugin are you using to optimize the database for your WordPress blog/website? Feel free to share it with us in the comment box below.
If you liked this article, please subscribe to my blog to regularly update the best and latest articles via email. Thanks very much. 🙂
