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.

Freemius

Lars Koudal

cleverplugins

Delete Duplicate Posts helps you declutter your WordPress site by removing duplicate posts along with their metadata. Whether you choose to run the cleanup process manually or set it to operate automatically on a schedule, our plugin ensures a thorough cleanup, improving your website’s loading speed and overall performance.
Try it out on your Free Test Site: <a href="https://app.instawp.io/launch?t=ddp-492-demo-template&d=v2" rel="nofollow ugc">Launch Demo</a>
<h3>Why Choose Delete Duplicate Posts?</h3>
<ul>
<li>Comprehensive Cleanup: Not just posts or pages, but also any Custom Post Type you have enabled, along with all related metadata.</li>
<li>Space Efficiency: By eliminating unnecessary duplicates, it frees up space, facilitating better website performance.</li>
<li>Scalability: Designed for websites of all sizes, it efficiently manages and optimizes large-scale websites without causing timeouts.</li>
</ul>
<h3>Features</h3>
<ul>
<li>Selective Deletion: Choose specific posts for deletion or use the select all option.</li>
<li>Deletion Modes: Supports both manual and automatic deletion processes.</li>
<li>Version Preference: Options to keep either the oldest or the newest version of a post.</li>
<li>Deletion Notifications: Receive status emails upon the deletion of posts.</li>
<li>Activity Log: An integrated log records all plugin activities for your review.</li>
</ul>
<h3>Experience its Efficiency</h3>
Our plugin’s unique approach to handling large datasets ensures that your website remains operational and improves progressively. By removing a few posts at a time, the plugin prevents site timeouts and enhances your website’s performance seamlessly.
For a cleaner, smoother, and more efficient WordPress site, Delete Duplicate Posts is the solution you need.
<a href="https://cleverplugins.com/delete-duplicate-posts/" rel="nofollow ugc">Learn more about the plugin and its features.</a>
Eliminate duplicate posts, pages, and custom post types effortlessly with Delete Duplicate Posts, enhancing your website’s performance. Our WordPress plugin offers both manual and automatic cleanup options, ensuring a streamlined and efficient management of content duplicates.
<h4>How can I report security bugs?</h4>
You can report security bugs through the Patchstack Vulnerability Disclosure Program. The Patchstack team help validate, triage and handle any security vulnerabilities. <a href="https://patchstack.com/database/vdp/delete-duplicate-posts" rel="nofollow ugc">Report a security vulnerability.</a>

Delete Duplicate Posts

My site had a LARGE number of custom posts (150K+) that we had imported. During the import, duplicates were created to the tune of almost 40K posts. I set up the plugin to run in automated mode knocking off 100 posts every 30 mins. It took a LONG time - weeks - but it did the job without bringing down the server or corrupting the db. All while still permitting front and back-end access. 

I played around with the config settings to get to the sweet spot for the number of posts to delete at one time and the correct repeat cycle. It paid off. 

Well done folks. 

Worked Well For Me

Excellent plugin, thanks. Only the user interface would need to be improved for long duplicate queues. Like not being able to click multiple times in a row on the submission buttons. Do you want help?


Great plugin, even on high number of duplicates


easy to delete duplicate post, without manual indexing 


easy to delete duplicate post


Works like a charm to remove duplicates from woocommerce after import.


Super!


There are too many ads and begging that can't be turned off. The interface is overloaded with this junk.


Неплохой плагин. Был.

Get rid of duplicate posts and pages (any post type) on your blog with manual or automatic modes.

RVS Database Doctor vs Delete Duplicate Posts