Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance
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 ✅ WooCommerce Clean orphaned product variations Clean orphaned customer analytics Clean expired customer sessions ✅ 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 🛒 WOptimize – The Cleaner & Optimizer for WooCommerce If you run a WooCommerce store and want to go further, try our dedicated plugin WOptimize – the ultimate solution to clean and speed up your WooCommerce store. Learn more: https://sigmaplugin.com/downloads/woptimize
Top keywords
- meta43×2.71%
- post27×1.70%
- clean26×1.64%
- delete26×1.64%
- database25×1.58%
- tables20×1.26%
- size19×1.20%
- user17×1.07%
- display15×0.95%
- post meta15×0.95%
- cleanup14×0.88%
- tasks14×0.88%
Jetpack – WP Security, Backup, Speed, & Growth
JETPACK – THE BEST WORDPRESS PLUGIN Jetpack is a WordPress plugin that helps you create better content, grow your subscribers, earn money from your website and keep it safe, fast, and secure. You can grow and keep track of your website traffic with Jetpack stats, and create better content with Jetpack AI. You can start a newsletter and grow your audience, turning fans into paying subscribers. Create beautiful content with Jetpack Creator and keep your site fast with Jetpack Boost. HOW TO GET STARTED WITH JETPACK Installation is free, quick, and easy. Set up Jetpack in minutes. Take advantage of more robust features like WordPress site security and design and growth tools by upgrading to a paid plan. NEED EXPERT SUPPORT? We have a global team of Happiness Engineers ready to provide incredible support. Ask your questions in the support forum or contact support. WHY USE JETPACK ON YOUR SITE Safer. Faster. More traffic. WordPress security, performance, marketing, and design tools — Jetpack is made by WordPress experts to make WP sites safer and faster, and help you grow your traffic. 24/7 AUTO SITE SECURITY We guard your site so you can run your site or business. Jetpack Security provides easy-to-use, comprehensive WordPress site security including auto real-time backups and easy restores, malware scans, and spam protection. Essential features like brute force protection and basic downtime / uptime monitoring are free. Back up your site automatically in real time and restore to any point with one click. Cloud storage starts at 10GB, which is more than enough for most sites, with additional storage options available if needed. Great for eCommerce stores especially Woo. Manage migration to a new host, migrate theme files and plugins to a new database, easily duplicate websites, create full database backups, clone websites, repair broken websites by restoring older backups or easily set up a test site by creating a duplicate of your existing WP website. See every site change and who made it with the activity log, great for coordination, debug, maintenance, or troubleshooting. Examine incoming traffic to your WordPress site with our WAF (Web Application Firewall) and decide to allow or block it based on various rules. Add an important layer of protection to your site with our WAF (Web Application Firewall), particularly when attackers actively exploit unpatched vulnerabilities. Automatically perform malware scans and security scans for other code threats. One click fix to restore your site for malware. Block spam comments and form responses with anti spam features powered by Akismet. Brute force attack protection to protect your WordPress login page from attacks. Monitor your site uptime / downtime and get an instant alert of any change by email. Secure WordPress.com powered login used by millions of sites with optional 2FA (two factor authentication) for extra protection. Auto update individual plugins for easy site maintenance and management. You can purchase all of Jetpack’s security features in our Security bundle, or VaultPress Backup, Scan, and Akismet Anti-spam can each be purchased individually. PEAK SPEED AND PERFORMANCE Get blazing fast site speed with Jetpack. Jetpack’s free CDN (content delivery network) auto optimizes your images. Watch your page load times decrease — we’ll optimize your images and serve them from our own powerful global network, and speed up your site on mobile devices to reduce bandwidth usage and save money! Image CDN for images and core static files, like CSS and JavaScript, served from our servers, not yours, which saves you money and bandwidth. Unlimited, high speed, ad free video hosting keeps the focus on your content, not on ads or recommendations that lead people off site. Custom site search is incredibly powerful and customizable. Helps your visitors instantly find the right content so they read and buy more. Works great with WooCommerce / eCommerce sites to help filter products so customers get what they want on your site faster. Recommended to use with Jetpack Boost for ultimate WordPress site speed. POWERFUL TOOLS FOR GROWTH Create and customize your WordPress site, optimize it for visitors and revenue, and enjoy watching your stats tick up. Build it, share it, and watch it grow. Auto publish blog posts and products to social media by simply using our tools to connect to Facebook, Bluesky, Threads, Tumblr, Mastodon, LinkedIn, and Nextdoor. Easily share Instagram posts on your pages and blog posts. Collect a payment or donation, sell a product, service, or membership with simple integrations with PayPal and Stripe. Grow traffic with SEO tools for Google, Bing, Facebook, and WordPress.com. XML sitemap created automatically. Advertise on your site to generate revenue. The ad network automatically does the work for you to find high-quality ads that are placed on your site. Manage Jetpack features from anywhere with the official WordPress mobile app, available for Apple iOS (iPhone or iPad) and Google Android. Looking for Customer Relationship Management? Check out the Jetpack CRM plugin which works alongside Jetpack to give you a simple and practical way to build relationships with your customers and leads. POWERFUL STATS TO GROW YOUR SITE With Jetpack Stats, you don’t need to be a data scientist to see how your site is performing. Advanced site stats and analytics to help you understand your audience. Discover your top performing posts & pages. See who is creating the most popular content on your team with our author metrics. Easily keep track of your content creation habits & trends over the years. View weekly and yearly trends with 7-day Highlights and Year in Review. See what popular social networks your content is being shared to the most. Explore real-time data on visitors, likes, and comments. Get detailed insights on the referrers that bring traffic to your site. Discover what countries your visitors are coming from. Measure link clicks, video plays, and file downloads within your site. WRITE SMARTER, NOT HARDER. Experience the ease of crafting professional content with intuitive and powerful AI. Jetpack AI Assistant effortlessly integrates with your WordPress editor, offering an intuitive interface to interact with AI. This powerful block lets you generate diverse content at your command, significantly reducing the time and effort required in content creation. Simply provide a prompt, and watch as Jetpack AI Assistant crafts compelling blog posts, detailed pages, structured lists, and comprehensive tables – all tailored to your needs. Harness AI power directly from your editor. Unlock high-quality, tailored content at your command. Maintain professional standards with ease. AI-powered translations across numerous languages at your fingertips, breaking down language barriers. PROMOTE YOUR CONTENT EASILY WITH JETPACK BLAZE Find new fans by promoting your posts and pages across millions of sites in the WordPress.com and Tumblr ad network. Create your ad. Choose your audience. Set your budget. It’s that easy. Amplify your reach for just a few dollars. EASY DESIGN TOOLS Quickly customize your site to make it stand out — no coding needed. Themes — Simple WordPress themes to get started on your site. Related posts — Keep visitors on your site by automatically showing them related content they will be interested in. Gallery and Slideshow tools — Image galleries, carousel slider, and slideshows for WP sites and stores. Subscriptions — Make it easy for visitors to sign up to receive notifications of your latest posts and comments. Contact form — Easily build unlimited contact forms for free without any coding. Receive email notifications for each response. Integrate with mail solutions like Creative Mail to reach your customers and leads quickly. Connect to Jetpack Anti spam (powered by Akismet) to filter submissions. oEmbed Support — easily embed images, posts, and links from Facebook and Instagram. INTEGRATIONS Jetpack is updated monthly to ensure seamless integration with top WordPress plugins and other tech products. Built for WooCommerce: Jetpack and WooCommerce are both made by Automattic. Backup, Scan, Anti-spam, integrate perfectly for Woo / eComm stores. Jetpack is fully compatible with v2.0 of the official AMP plugin for WordPress. Better understand your customers and marketing with Google Analytics (GA) integration. Social media platforms: Instagram, Facebook, Tumblr, LinkedIn, Threads, Bluesky, Nextdoor. Simple Blocks to customize your site: Pinterest, Whatsapp, Podcast player, GIFs, maps, tiled gallery, slideshow. Payment processors: easily collect payments or donations and sell products through Stripe and PayPal. Site speed and performance plugins: Works great with WP Super Cache by Automattic and Cloudflare. Contact form: Anti-spam (Powered by Akismet) blocks spam comments for Jetpack forms, Contact Form 7, Ninja Forms, Gravity Forms, Formidable Forms, and more. Other tech integrations: Instagram, Creative Mail, Mailchimp, Calendly, Whatsapp, Pinterest, Revue, and more. EXPLORE MORE OF JETPACK If you like Jetpack, consider checking out our other products and bundles Jetpack Complete – The Complete bundle with real‑time security, top performance, and everything you need to grow your business. Jetpack Security – Our Security bundle provides easy‑to‑use, comprehensive WordPress site security, including real‑time backups, a web application firewall, malware scanning, and spam protection. Jetpack Backup – Save every change and get back online quickly with one‑click restores from Jetpack VaultPress Backup. Jetpack Scan – Protect your site from bad actors around‑the‑clock ‑ with our web application firewall (WAF) and automated malware scanning with one‑click fixes. Jetpack Search – Instantly deliver the most relevant results to your visitors with Jetpack Search. No coding required, no ads, and no tracking. Jetpack Boost – Increase your website speed. Enjoy the same performance advantages as the world’s leading websites, no developer required. Jetpack VideoPress – Display stunning‑quality video with none of the hassle. Drag and drop videos through the WordPress editor and keep the focus on your content, not the ads. Jetpack AI – Turn your ideas into ready‑to‑publish content at lightspeed. Jetpack Stats – Keep track of your website visits, popular posts, newsletter subscribers and more. Jetpack Social – Automatically share your website content to your favorite social media platforms, from one place. Jetpack CRM – Jetpack CRM has all of the tools you need to grow your business. It’s also modular, so you can customize it to suit your needs. Jetpack Creator – Craft stunning content, boost your subscriber base, and monetize your online presence. Jetpack Newsletter – Transform your blog posts into newsletters to easily reach your subscribers. Offer paid subscriptions and earn from your content. KEEP SPAM OFF YOUR WEBSITE Akismet Anti-spam – Automatically clear spam from comments and forms. Save time, get more responses, give your visitors a better experience – all without lifting a finger. PROMOTE YOUR CONTENT FOR MORE VIEWS Blaze – Find new fans by promoting your posts and pages across millions of sites in the WordPress.com and Tumblr ad network. MANAGE MORE THAN ONE SITE? Jetpack Manage – All the tools you need to manage multiple WordPress sites. Monitor site security, performance, and traffic, and get alerted if a site needs attention. FLY HIGHER WITH INDIVIDUAL PLUGINS Ever wish you could have just one feature of Jetpack in its own plugin? Now you can. Check out our individual plugins and install only what you need. Jetpack VaultPress Backup Jetpack Boost Jetpack CRM Jetpack Protect Jetpack Search Jetpack Social Jetpack VideoPress Akismet Anti-Spam