WP-Sweep allows you to clean up unused, orphaned and duplicated data in your WordPress. It also optimizes your database tables.

WP-Sweep

This plugin cleans up:
<ul>
<li>Revisions</li>
<li>Auto drafts</li>
<li>Deleted comments</li>
<li>Unapproved comments</li>
<li>Spammed comments</li>
<li>Deleted comments</li>
<li>Orphaned post meta</li>
<li>Orphaned comment meta</li>
<li>Orphaned user meta</li>
<li>Orphaned term meta</li>
<li>Orphan term relationships</li>
<li>Unused terms</li>
<li>Duplicated post meta</li>
<li>Duplicated comment meta</li>
<li>Duplicated user meta</li>
<li>Duplicated term meta</li>
<li>Transient options</li>
<li>Optimizes database tables</li>
<li>oEmbed caches in post meta</li>
</ul>
This plugin uses proper WordPress delete functions as much as possible instead of running direct delete MySQL queries.
Following delete functions are used:
<ul>
<li>wp_delete_post_revision()</li>
<li>wp_delete_post()</li>
<li>wp_delete_comment()</li>
<li>delete_post_meta()</li>
<li>delete_comment_meta()</li>
<li>delete_user_meta()</li>
<li>delete_term_meta()</li>
<li>wp_remove_object_terms()</li>
<li>wp_delete_term()</li>
<li>delete_transient()</li>
<li>delete_site_transient()</li>
</ul>
WP-Sweep WP REST API Endpoints 
* <code>GET /wp-json/sweep/v1/count/&lt;Name&gt;</code>. Get the number of items that we will be sweeping. 
* <code>GET /wp-json/sweep/v1/details/&lt;Name&gt;</code>. Get the details of the items that we will be sweeping. 
* <code>DELETE /wp-json/sweep/v1/sweep/&lt;Name&gt;</code>. Runs sweep for that particular item.
WP-Sweep WP-CLI Commands 
* <code>wp sweep --all</code>. Runs sweep for all items. 
* <code>wp sweep &lt;Name&gt;</code>. Runs sweep for that particular item. 
* <code>wp sweep &lt;Name1&gt; &lt;Name2&gt;</code>. Run sweep for the selected items.
WP-Sweep Available Items: 
* revisions 
* auto_drafts 
* deleted_posts 
* unapproved_comments 
* spam_comments 
* deleted_comments 
* transient_options 
* orphan_postmeta 
* orphan_commentmeta 
* orphan_usermeta 
* orphan_termmeta 
* orphan_term_relationships 
* unused_terms 
* duplicated_postmeta 
* duplicated_commentmeta 
* duplicated_usermeta 
* duplicated_termmeta 
* optimize_database 
* oembed_postmeta
WP-Sweep is not compatible with the following plugins: 
* <a href="https://wordpress.org/plugins/custom-fonts/" rel="ugc">Custom Fonts</a> 
* <a href="https://elementor.com/features/popup-builder/" rel="nofollow ugc">Elementor Popup Builder</a> 
* <a href="https://wordpress.org/plugins/mailpress/" rel="ugc">MailPress</a> 
* <a href="https://wordpress.org/support/plugin/ml-slider/" rel="ugc">Meta Slider</a> 
* <a href="https://wordpress.org/plugins/polylang/" rel="ugc">Polylang</a> 
* <a href="https://revolution.themepunch.com/" rel="nofollow ugc">Slider Revolution</a> 
* <a href="https://codecanyon.net/item/viba-portfolio-wordpress-plugin/9561599" rel="nofollow ugc">Viba Portfolio</a> 
* <a href="https://wpml.org/" rel="nofollow ugc">WPML</a>
<h3>Build Status</h3>
<a href="https://codeclimate.com/github/lesterchan/wp-sweep" rel="nofollow ugc"></a> 
<a href="https://codeclimate.com/github/lesterchan/wp-sweep" rel="nofollow ugc"></a>
<h3>Development</h3>
<ul>
<li><a href="https://github.com/lesterchan/wp-sweep" title="https://github.com/lesterchan/wp-sweep" rel="nofollow ugc">https://github.com/lesterchan/wp-sweep</a></li>
</ul>
<h3>Credits</h3>
<ul>
<li>Plugin icon by <a href="http://www.freepik.com" rel="nofollow ugc">Freepik</a> from <a href="http://www.flaticon.com" rel="nofollow ugc">Flaticon</a></li>
</ul>
<h3>Donations</h3>
I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks, I will really appreciate it. If not feel free to use it without any obligations.

Alternative Plugins for

Discover the Lists with WP-Sweep

Dev

Basics

Maintenance, Speed & Optimization

Maintenance, Speed & Optimization

Maintenance

Essential Plugins

ijunkyisp

Webmaster tools

Starter

WP Optimize&Secure