Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance vs Optimal State – Advanced Optimization, Performance & Security Suite

Advanced Database Cleaner is a complete WordPress optimization plugin that helps you clean up database clutter and optimize database performance by removing unused data such as old revisions, auto drafts, spam comments, expired transients, unused post meta, duplicated post meta, unused user meta, etc. It is designed to help you improve website speed by reducing database bloat and ensuring a lean, efficient WordPress installation. It also provides detailed previews, powerful filters, and automation tools to safely control what gets cleaned. With the ✨Premium version✨, you can unlock even more advanced features, such as detecting and cleaning orphaned options, orphaned tables, orphaned post meta, orphaned user meta, orphaned transients, and orphaned cron jobs. It also gives you clear insights into how your database evolves over time through built-in analytics, lets you monitor plugin and theme activity to better understand when new data is created or when leftovers appear, and much more. Why use Advanced Database Cleaner❓ 👉 Get a clear overview: see how many tables, options, transients, cron jobs, metadata… records you have, and identify which are unused or orphaned. 👉 Save time: configure what to clean, how far back to keep data, and how often to run automations. The plugin will then handle recurring cleanups for you. 👉 Save space and improve performance: removing unnecessary data reduces database size, makes backups faster, and can improve query performance, especially on busy or older sites. ✅ Main Features Delete old revisions of posts and pages Delete old auto-drafts Delete trashed posts Delete pending comments Delete spam comments Delete trashed comments Delete pingbacks Delete trackbacks Delete unused post meta Delete unused comment meta Delete unused user meta Delete unused term meta Delete unused relationships Delete expired transients Delete duplicated post meta Delete duplicated user meta Delete duplicated comment meta Delete duplicated term meta Delete oEmbed caches Display the database size that will be freed before cleaning for each item type, and the total size to be freed Display and preview items to clean before performing a database cleanup to ensure safety Sorting capability in cleanup preview tables (by name, date, size, site id, etc.) View options value content in original or formatted mode for serialized or JSON structures (and other items types as well). Keep last X days of data: clean only data older than the number of days you specify ✅ Automation Schedule database cleanup to run automatically Create scheduled cleanup tasks and specify which items each task should clean Schedule database optimization and/or repair to run automatically Execute scheduled tasks based on several frequencies: once, hourly, twice a day, daily, weekly, or monthly Specify the “keep last X days” rule for each item type in a scheduled task Pause/Resume scheduled tasks whenever needed Create as many scheduled cleanup tasks as needed and specify what each task should clean ✅ Tables Display the list of database tables with information such as number of rows, table size, engine, etc. Sort tables by any column such as table name or table size Display table contents along with their column structure, indexes, status, and more Detect and filter tables with invalid prefixes (tables that do not belong to the current WordPress installation), this can be enabled or disabled from the settings page Optimize database tables (the plugin notifies you when tables require optimization) Repair corrupted or damaged database tables (the plugin notifies you when tables are corrupted) Convert tables to InnoDB for better performance Empty rows of database tables Clean and delete database tables ✅ Options Display the options list with information such as option name, option value, option size, and autoload status Sort options by any column such as option name or option size View option value content in original or formatted mode for serialized or JSON structures. Notify you if autoloaded options are large and help reduce autoload size for better performance Detect large options that may slow down your website Set option autoload to yes/no Clean and delete options ✅ Cron Jobs Display the list of active cron jobs (scheduled tasks) with information such as arguments, action, next run, schedule, etc. Sort cron jobs by any column such as action name or next run time Detect cron jobs with no valid actions Clean and delete scheduled tasks ✅ Post Meta Display the post meta list with information such as meta key, value, size, associated post ID, etc. Sort post meta by any column such as meta key, meta size, or post ID View post meta value content in original or formatted mode for serialized or JSON structures. Detect unused post meta (meta not associated with any existing posts) Detect duplicated post meta (same meta key/value for the same post ID) Clean and delete post meta ✅ Post types Display post types with information such as name, post count, visibility (public or non-public), etc. Sort post types by columns such as name, post count, visibility, etc. View posts corresponding to each post type, along with their details Detect unused or orphaned post types Clean orphaned post types ✅ User Meta Display the user meta list with information such as meta key, value, size, associated user ID, etc. Sort user meta by any column such as meta key, meta size, or user ID View user meta value content in original or formatted mode for serialized or JSON structures. Detect unused user meta (meta not associated with any existing users) Detect duplicated user meta (same meta key/value for the same user ID) Clean and delete user meta ✅ Transients Display the list of transients with information such as name, value, size, and expiration time Sort transients by any column such as transient name, size, or expiration time View transient value content in original or formatted mode for serialized or JSON structures. Clean expired transients Detect large transients that may slow down your website Clean and delete transients Set transient autoload to yes/no ✅ Other Tools Display current database size Logging system for easy troubleshooting Access the WordPress debug log directly from the plugin interface Multisite support (network-wide database cleanup and optimization from the main site) Modern, responsive interface powered by React for a smooth experience without page reloads Show/hide plugin tabs for better usability ⚡ Premium Features ⚡ Official website Unlock the full power of database cleanup and optimization with Advanced Database Cleaner Premium – packed with smart features that take accuracy, speed, and cleanup control to the next level. ✅ Remote SmartScan Local scan + Remote SmartScan technology to accurately detect the true owners of tables, options, post meta, user meta, transients, and cron jobs Cloud-enhanced ownership detection using a large and continuously improving remote database Improved accuracy for identifying orphaned items left by deleted plugins and themes Ability to edit ownership of any item and correct misidentified owners Ability to send ownership corrections to improve the global detection database Enhanced “Belongs to” ownership column everywhere using cloud data + local data Display multiple possible owners for each item when applicable Display owner status (active, inactive, not installed) to simplify cleanup decisions Check your remote scan credits to monitor usage ✅ Action Scheduler Cleanup Clean Action Scheduler Completed actions Clean Action Scheduler Failed actions Clean Action Scheduler Canceled actions Clean Action Scheduler Completed logs Clean Action Scheduler Failed logs Clean Action Scheduler Canceled logs Clean Action Scheduler Orphan logs ✅ General Cleanup Enhancements Keep last X items feature in General Cleanup Keep last X items per parent (e.g., per post) Keep last X items globally (e.g., keep the last 10 pingbacks) Combine Keep Last X Days with Keep Last X Items for advanced cleanup safety ✅ Advanced Filters Advanced filters in all modules (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs) Filter by size, value content, autoload, expiration, metadata type, and more Filter by plugin owner, theme owner, WordPress core, orphan, or unknown Filter by multisite site ID with full per-site visibility Filter by action frequency and interval in cron jobs Filter by duplicated, unused, large, not-yet-scanned, or expired items ✅ Advanced Automation Unlimited automation tasks (Free version is limited to 5 tasks) Create any number of scheduled cleanup tasks with different configurations Create scheduled optimization and repair tasks Use Keep Last X Items and Keep Last X Days inside scheduled tasks Run automation tasks hourly, twice daily, daily, weekly, monthly, or at any supported frequency Pause/resume/delete automation tasks without losing settings Per-task automation event logging showing executed actions, number of items cleaned, execution timestamps, and detailed logs ✅ Database Analytics Daily tracking of total database size and number of tables Daily and monthly charts showing database growth trends Raw data tab with all recorded measurements Table-level analytics showing size growth, rows growth, and daily changes Ability to detect abnormal table growth caused by logs, caches, or runaway actions Multi-table selection and search for analyzing multiple tables at once ✅ Addons Activity Automatically track plugin activations, deactivations, and uninstalls Automatically track theme switches and uninstalls Display activity in a color-coded timeline for better readability All timestamps shown in your local timezone Multisite support (activity recorded on the main site) ✅ Full Multisite Support Clean any site or all sites Filter items by site ID in every module (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs) Display which site each item belongs to Run automation tasks across the entire network

Optimal State is a complete performance suite that does it all: database optimization, automated backups, page caching, brute force protection, 2FA, search & replace, and advanced cleanup. All in one lightweight plugin. Why pay for 4-6 separate plugins? Optimal State replaces WP Rocket, UpdraftPlus, WP‑Optimize, Perfmatters, Better Search Replace, Loginizer and more — saving you money, reducing conflicts, and simplifying your workflow. ▶ Live Interactive Demo | 📕 User Manual What Makes Optimal State Different? 🚀 All‑in‑One, Not a Collection of Features Unlike plugins that bolt on random features, Optimal State is engineered as a unified performance system. Every component works together, not against each other. 💰 Replace 6+ Premium Plugins Stop paying for multiple subscriptions. Get everything you need in one plugin: UpdraftPlus → Database backup & restore (with safety rollback) WP Rocket → Page caching, browser caching, performance tweaks WP‑Optimize → Database cleanup, table optimization, autoload optimization Better Search Replace → Serialization‑safe search & replace Perfmatters → Heartbeat control, emoji removal, header cleanup Loginizer → Brute force protection, IP blocking Plus → 2FA, legacy plugin scanner, integrity scanner, index manager 🔬 Built on Real Database Science Our proprietary health scoring algorithm (0–100) analyzes 3 key areas: Performance (40%), Cleanliness (35%), and Efficiency (25%). It tells you exactly what to fix and when. 🛡️ Enterprise‑Grade Safety Every destructive operation includes: – Automatic safety backup – Emergency rollback system – Zero‑downtime restore (temp table swap) – Database validation before restore – Maintenance mode during critical ops What You Can Do With Optimal State 🗄️ Database Optimization – One‑click optimization cleans 20 types of database bloat in seconds – Real‑time health score (0‑100) shows your database condition at a glance – Table defragmentation recovers wasted disk space – Autoload optimization speeds up every page load (critical for TTFB) – Table repair fixes corrupted tables automatically – Legacy plugin scanner removes ghost data from uninstalled plugins – Delete unused tables safely (with protection for active plugins) 💾 Backup & Restore – Create GZIP‑compressed database backups with integrity checksums – Restore any backup with automatic safety rollback – Keep up to 10 backups with automatic rotation – Upload and restore external backups (up to 5GB) – Zero‑downtime restore using temporary table technology – Protected backup directory prevents unauthorized access ⚡ Caching System – Server‑side page caching delivers lightning‑fast HTML – Browser caching with automatic .htaccess rules (Apache) – Database query caching for Redis/Memcached – Mobile‑specific cache for separate mobile layouts – Smart cache preload from sitemap – GDPR‑compliant cookie detection (supports 20+ consent plugins) – Intelligent auto‑purge on content updates 🔍 Search & Replace – Serialization‑safe — handles PHP serialized data correctly – Dry run mode previews all changes before execution – Table‑specific operations for targeted updates – Partial or whole‑word matching – Essential for domain migrations 🎛️ Performance Features – Bad bot blocker blocks resource‑hungry crawlers – Font loading optimization eliminates render‑blocking fonts – Lazy load images and iframes – Heartbeat API control reduces server load by 60%+ – Post revisions limit (save 30‑50% database space) – Trash auto‑empty after X days – Disable XML‑RPC (block brute force attacks) – Remove emoji scripts (save 12KB per page) – Clean WordPress headers (hide version, RSD, WLW, shortlinks) 📊 Analytics & Monitoring – PageSpeed Insights integration (Core Web Vitals) – Performance metrics dashboard – Detailed database statistics – Activity log (last 250 operations) – Track optimization impact over time ⏰ Automation – Schedule daily, weekly, or monthly optimization – Email notifications with detailed reports – Custom time selection (run during low traffic) – Combined backup + cleanup operations 🔒 Security – Emergency rollback on restore failure – Maintenance mode during critical operations – Database validation before restore – User access control (restrict plugin to specific admins) – Settings export/import – Brute force protection for login page – IP number blocker (block entire site access) – Two‑Factor Authentication (2FA) Perfect For 🛒 E‑commerce Stores – WooCommerce session cleanup, Action Scheduler optimization, order transient removal, product index optimization 📝 High‑Traffic Blogs – Revision control, comment spam removal, transient cleanup, cache preload 🏢 Agencies & Developers – Staging/production migrations, bulk cleanup, settings export/import 🔒 Membership Sites – User metadata optimization, scheduled maintenance, login protection 🌐 Any WordPress Site – Slow admin, bloated database, poor performance, or security concerns Replaces These Popular Plugins UpdraftPlus → Backup & Restore WP Rocket → Caching & Performance WP Super Cache → Page Caching WP-Optimize → Database Cleanup Better Search Replace → Database Search & Replace Perfmatters → Performance Optimization Heartbeat Control → Heartbeat Management WP Revisions Control → Revision Limits Clearfy → Performance Tweaks Advanced Database Cleaner → Deep Database Cleanup Autoptimize → Performance Features Loginizer → Login Page Protection What Makes Optimal State Different? Unlike WP-Optimize: We include professional backup/restore and advanced caching—not just basic cleanup. Unlike UpdraftPlus: We optimize your database for performance, not just backup. Backups are 40-60% smaller due to optimization. Unlike WP Rocket: We tackle the root cause (database bloat) instead of just caching around the problem. Combined approach = better results. Unlike Perfmatters: We provide complete database management, automated backups, and intelligent cleanup—not just toggle switches. Unlike Loginizer: We provide a user-friendly, straightforward control panel that requires no technical expertise. The Optimal State Advantage: One plugin, one interface, one optimization strategy. No conflicts, no compatibility issues, no subscription fatigue. Technical Specifications Minimum Requirements: WordPress 5.5+, PHP 7.4+ Tested Up To: WordPress 7.0 Server Compatibility: Shared hosting, VPS, dedicated, cloud (AWS, DigitalOcean, etc.) Hosting Compatibility: Bluehost, SiteGround, WP Engine, Kinsta, Cloudways, all major hosts Multisite: Not currently supported Database Support: MySQL 5.6+, MariaDB 10.1+ Cache Support: Redis, Memcached, APCu compatible External Services and Resources Optimal State utilizes the following third-party services and open-source libraries to enhance functionality and user experience: Google PageSpeed Insights API – Performance measurement tool that analyzes web page content and generates suggestions to make that page faster. The plugin’s PageSpeed integration uses this API to fetch and display Core Web Vitals metrics and optimization opportunities. When you use the PageSpeed feature, your site URL is sent to Google’s servers for analysis. Use of this API is subject to Google’s Terms of Service and Privacy Policy. API Documentation: https://developers.google.com/speed/docs/insights/v5/get-started Terms of Service: https://developers.google.com/terms Privacy Policy: https://policies.google.com/privacy GTranslate Widget – Website translation service that provides automatic language translation functionality. The plugin loads the GTranslate popup widget from cdn.gtranslate.net to enable multi-language support in the admin interface. When the widget is loaded, it may connect to GTranslate’s servers to provide translation services. Use of this service is subject to GTranslate’s Terms of Service and Privacy Policy. Service Website: https://gtranslate.io/ Terms of Service: https://gtranslate.io/terms-and-conditions Privacy Policy: https://gtranslate.io/privacy-policy Note: The PageSpeed Insights feature is optional and only activates when you manually request a performance analysis. No data is sent to external services without your explicit action. Credits Developed by Luke Garrison Icons by Dashicons (WordPress Core) Performance metrics based on Google PageSpeed Insights Contributing: Interested in contributing to Optimal State? Feature requests, bug reports, and code contributions are welcome. Visit our support page for contribution guidelines. Support and Documentation Getting Help User Manual: Comprehensive documentation built into the plugin (user manual included) FAQ Section: Common questions answered in detail Live Demo: Interactive preview to explore features before installation Email Support: Priority support for Pro version users Useful Links Live Interactive Demo Support Page User Manual Feature Requests We actively develop Optimal State based on user feedback. If you have a feature request or enhancement idea, please contact us through the support page. Many current features were implemented based on user suggestions.