Adi Glibanović

RVS Database Doctor is a professional database administration tool. It gives you insight into the current state, safely cleans and optimizes, and shows exactly how much you saved – with full support for large databases.
<h4>Key features</h4>
<ul>
<li>Dashboard with health score and one-click Optimize Now.</li>
<li>Time-based job runner (default batch 1000, auto-adapts to <code>max_execution_time</code>) – works smoothly on databases with 100k+ rows.</li>
<li>Background queue (WP-Cron drain every minute, Action Scheduler when available) – you can close the tab and the job continues.</li>
<li>Before / After snapshots with SVG charts and per-table delta (no external dependencies).</li>
<li>Guided Safe Cleanup Wizard with recommended selections, CARE confirmations, before/after snapshots, and cleanup result deltas.</li>
<li>Smart Advisor v2 – health score (0-100, grade A-F), actionable tips, and EXPLAIN query-plan hints for slow queries.</li>
<li>Bulk actions for Table Sizes, Autoload Options, Index Analysis, and Cleanup tabs.</li>
<li>Manual full database backup with a user-selectable table list and manifest.json metadata. Choose PHP chunked dump (works anywhere) or native mysqldump (fast).</li>
<li>Full database restore from plugin-created backups – automatic pre-restore backup, streaming SQL import, progress tracking, and mandatory confirmation (type RESTORE).</li>
<li>Micro-backup of affected tables before destructive operations (gzip when available, retention by days and count).</li>
<li>Scheduled optimizations – hourly / daily / weekly / monthly.</li>
<li>Scheduled health digest emails – daily, weekly, or monthly summaries sent to the configured notification email.</li>
<li>MyISAM → InnoDB conversion (batched with progress bar).</li>
<li>Autoload analysis with severity levels, segmentation, search, filter, pagination, and bulk update – no longer limited to 50 options.</li>
<li>Index analysis – missing expected, composite suggestions, sys redundant / unused.</li>
<li>WooCommerce / HPOS detection and specific suggestions.</li>
<li>Cleanup: expired transients, revisions, auto-drafts, old trash, spam / trash comments, orphan postmeta / commentmeta / term_relationships, expired WC sessions, Action Scheduler old actions / logs, duplicate postmeta, stale session tokens, <code>_edit_lock</code> / <code>_edit_last</code>.</li>
<li>Actions log – every attempt is recorded (success / error / dry-run).</li>
<li>WP-CLI commands for every action including <code>backup create --all</code>, <code>backup validate <uid></code>, and <code>backup restore <uid> --confirm=RESTORE</code> (<code>wp rvs-database-doctor …</code>; <code>wp rvs-db-doctor …</code> is also supported).</li>
</ul>
<h4>Safety rules</h4>
<ul>
<li>All destructive actions require the <code>manage_options</code> capability + nonce + explicit confirmation checkbox.</li>
<li>Table names are validated against <code>information_schema</code> before any <code>ALTER / ANALYZE / OPTIMIZE / DELETE</code>.</li>
<li>Auto-backup of affected tables before destructive operations (enabled by default).</li>
<li>The plugin never deletes anything automatically; Optimize Now runs safe categories only by default.</li>
</ul>

RVS Database Doctor

Safely analyze and optimize your WordPress and WooCommerce database with backups, restore, schedules, and a built-in health advisor.

opicron

Did you ever scale or crop uploaded images in wordpress? Did you ever try various image generating plugins? Did you ever change or add various media image sizes? If yes, chances are that your content folder is full of unused and unreferenced images. These image leftovers will remain cluttering your content folder until the end of days.
Image Cleanup will index these (and many more) unreferenced images. Unreferenced images are not indexed in the wordpress database and also not used by posts, scripts or backup restore meta data. Please note that images which have valid database metadata but are not used in posts are not indexed at this time. This is beyond the scope of this plugin.
Image Cleanup will also find images without meta data and images with incorrect meta data.
<ul>
<li>Save space taken up by unreferenced/backup images!</li>
<li>Fix incorrect metadata (sizes)</li>
<li>Bulk repair/delete functionality</li>
<li>Pagination for extremely large result sets</li>
<li>Logs tabs easily visible for reviewing!</li>
<li>Detailed information in log tabs!</li>
<li>Full restore functionality!</li>
<li>Especially useful for developers!</li>
<li>Written as class to avoid any conflicts!</li>
<li>Highly configurable to avoid memory and/or timeouts on some setups</li>
</ul>
On my one month old website with 50 files (and 250 attachment size variants) this plugin found 95 unreferenced images which I could remove without any conflicts.
There has been a reported case where this plugin indexed and removed over 23.000 images on a website. See forum/review for details
<h4>Image Cleanup workflow details</h4>
<ul>
<li>Retrieves all attachment images from the database (including size variants);</li>
<li>Finds all images in the wp-content folder;</li>
<li>Subtracts the attachment (and size variants) from physical found images;</li>
</ul>
The above will result in an list of invalid images which are not referenced by the database
<ul>
<li>Posts will be searched for images and found images will be subtracted from the invalid files (if any);</li>
<li>Scripts in wp-content will be searched for images and they will be subtracted from the invalid files (if any);</li>
<li>Backup images (for restoring images after scale/crop) will be subtracted from the invalid images;</li>
<li>Found unreferenced files will be checked against the meta data to see if the database meta entry still exist;</li>
</ul>
This results in various image lists in which the images can be reviewed, repaired or removed.
<h4>After indexing</h4>
After indexing you are able to (temporary) move the images to a backup folder to check the site without the images in the wp-content folder. You could also check the logs in the ../wp-content/uploads/image-cleanup/ID/logs folder for full information about the index.
If any problems are found you can revert the move of images by restoring them to their original locations.
When no problems arrise after moving the images to another location it is possible to permanently remove the images.
<h4>Future planned additions</h4>
<ul>
<li>Index unused valid images </li>
<li>Index missing image sizes (and option to generate missing images)</li>
<li>Index missing images which are used in posts</li>
</ul>

Image Cleanup

Image Cleanup will index unreferenced images. These can be leftovers from cropping and scaling images. Stop them cluttering your content folder!

RVS Database Doctor vs Image Cleanup