Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance vs AMP

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

Page Experience (PX) is a set of ranking signals—including Core Web Vitals (CWV)—measuring the user experience of interacting with a web page. AMP is a powerful tool which applies many optimizations and best practices automatically on your site, making it easier for you to achieve good page experience for your visitors. The official AMP Plugin, supported by the AMP team, makes it easy to bring the power of AMP to your WordPress site, seamlessly integrating with the normal publishing flow and allowing the use of existing themes and plugins. For more videos like this, check out the ongoing AMP for WordPress video series. The plugin’s key features include: Automate the process of generating AMP-valid markup as much as possible, letting users follow the standard workflows they are used to in WordPress. Provide effective validation tools to help users deal with AMP incompatibilities when they happen, including mechanisms for identifying, contextualizing, and resolving issues caused by validation errors. Provide development support to make it easier for WordPress developers to build AMP-compatible ecosystem components and build websites and solutions with AMP-compatibility built-in. Support the serving of AMP pages to make it easier for site owners to take advantage of mobile redirection, AMP-to-AMP linking, and generation of optimized AMP by default (via PHP port of AMP Optimizer). Provide a turnkey solution for segments of WordPress creators to be able to go from zero to publishing AMP pages in no time, regardless of technical expertise or availability of resources. The official AMP plugin for WordPress is a powerful tool that helps you build user-first WordPress sites, that is, sites that are fast, beautiful, secure, engaging, and accessible. A user-first site will deliver experiences that delight your users and therefore will increase user engagement and the success of your site. And, contrary to the popular belief of being only for mobile sites (it doesn’t stand for Accelerated Mobile Pages anymore!), AMP is a fully responsive web component framework, which means that you can provide AMP experiences for your users on both mobile and desktop devices. AMP Plugin Audience: Everyone This plugin can be used by both developers and non-developer users: If you are a developer or tech savvy user, you can take advantage of advanced developer tools provided by the AMP plugin to fix validation issues your site may have and reach full AMP compatibility. If you are not a developer or tech savvy user, or you just simply don’t want to deal with validation issues and tackling development tasks, the AMP plugin allows you to assemble fully AMP-compatible sites with different configurations taking advantage of AMP-compatible components. The plugin helps you to deal with validation issues by removing invalid AMP markup in cases where it is possible, or altogether suppressing AMP-incompatible plugins on AMP pages. The bottom line is that regardless of your technical expertise, the AMP plugin can be useful to you. Template Modes The official AMP plugin enables site owners to serve AMP to their users in different ways, which are referred to as template modes: Standard, Transitional, and Reader. The differences between them are in terms of the number of themes used (one or two), and the number of versions of the site (non-AMP, AMP). Each template mode brings its own value proposition and serves the needs of different scenarios in the large and diverse WordPress ecosystem. And in all cases, the AMP plugin provides as much support as possible in terms of automating the generation of AMP pages, as well as keeping the option chosen AMP valid. In a nutshell, the available template modes are the following: Standard Mode: This template mode is the ideal, as there is only one theme for serving requests and a single version of your site: the AMP version. Besides enabling all of your site to be AMP-first, this has the added benefit of reducing development and maintenance costs. This mode is the best choice for sites where the theme and plugins used in the site are fully AMP-compatible. It's also a good option if some components are not AMP-compatible but the site owner has the resources or the know-how to fix them. See our showcase of sites using Standard mode. Transitional Mode: In this mode there is also a single theme used, but there can be two versions of each page: AMP and non-AMP. The active theme is used for serving the AMP and non-AMP versions of a given URL. This mode is a good choice if the site uses a theme that is not fully AMP compatible, but the functional differences between the AMP and non-AMP pages are acceptable (due to graceful degradation). In this case, users accessing the site from mobile devices can get the AMP version and get an optimized experience which also retains the look and feel of the non-AMP version. Check out our showcase of sites using Transitional mode. Reader Mode: In this mode there are two different themes, one for AMP pages and another for non-AMP pages, and therefore there are also two versions of the site. This mode may be selected when the site is using an AMP-incompatible theme, but the level of incompatibilities is significant without graceful degradation. It’s also a good choice if you are not technically savvy (or simply do not want to deal with the incompatibilities) and therefore want simplified and robust workflows that allow you to take advantage of AMP with minimal effort. Different modes would be recommended in different scenarios, depending on the specifics of your site and your role. As you configure the plugin, it will suggest the mode that might be best for you based on its assessment of the theme and plugins used on your site. And, independently of the mode used, you have the option of serving all or only a portion of your site as AMP. This gives you all the flexibility you need to get started enabling AMP on your site progressively. AMP Ecosystem It is possible today to assemble great looking user-first sites powered by the AMP plugin by picking and choosing themes and plugins from a growing AMP-compatible ecosystem. In this context, the AMP plugin acts as an orchestrator of the overall AMP content creation and publishing process; it serves as a validator and enforcer making it easier to not only get to AMP experiences, but to maintain them with confidence. Many popular theme and plugin developers have taken efforts to support the official AMP plugin. If you are using a theme like Astra or Newspack, or if you are using plugins like Yoast or WP Forms — they will work out of the box! You can see the growing list of tested themes and plugins. AMP Development Although there is a growing ecosystem of AMP-compatible WordPress components, there is still a ways to go before majority AMP compatibility in the ecosystem. If you are a developer, or you have the resources to pursue development projects, you may want in some cases to develop custom plugin or theme to serve your specific needs. The official AMP plugin can be of great help to you by providing powerful and effective developer tools that shed light into the AMP development process as it is done in WordPress. This includes mechanisms for detailing the root causes of validation issues, the contextual space to understand them properly, and methods to deal with them during the process of achieving full AMP compatibility. Read more about Developer Tools. Getting Started To learn more about the plugin and start leveraging its capabilities to power your AMP publishing workflow, check the official AMP plugin product site. If you are a developer, we encourage you to follow along or contribute to the development of this plugin on GitHub. We have put up a comprehensive FAQ page and extensive documentation to help you start as smoothly as possible. But if you need some help, we are right here to support you in the plugin’s support forum, as well as through GitHub issues (for technical bugs and feature requests). And our thriving AMP Expert ecosystem has indie freelancers to enterprise grade agencies in case you need commercial support!