Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance vs PageSpeed Ninja – Cache, Minify, Defer CSS JavaScript, Critical CSS, Optimize Images, Convert WebP

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

PageSpeed Ninja is the ultimate performance plugin, specially designed to tackle slow loading times on your website on both desktop and mobile platforms. This plugin effortlessly addresses Google PageSpeed Insights issues and significantly improves Core Web Vitals. This tool offers a range of features designed to optimize your website’s performance: Compression: Implement Gzip and Brotli compression for faster load times. Resolve Render-Blocking Issues: Address render-blocking CSS and JavaScript issues to streamline loading. Enhancing Critical Rendering Path: Automatically generate critical CSS for above-the-fold content to improve the critical rendering path. Minification: Reduce load size by minifying HTML, JavaScript, and CSS files. Resource Bundling: Combine and inline JavaScript and CSS to reduce server requests. Defer Loading: Prioritize content rendering by choosing to defer CSS and JavaScript loading. Optimize Images: Improve loading speed with optimized image formats. Efficient Image Formats: Convert to WebP format for faster performance. Lazy Load: Optimize initial load with image lazy loading and optional low-quality placeholders. Optimize Google Fonts: Streamline Google Fonts loading for quicker rendering. Cache Leveraging: Utilize browser and server-side caching for improved performance. Benefit from 10+ years of experience optimizing 200,000+ mobile-friendly websites to offer even more enhancements, including image optimization, caching, and a suite of front-end and back-end performance improvements. This plugin is your go-to solution for reducing slow loading times, improving SERP optimization, and boosting website speed, making it an essential tool for performance optimization and SEO. Why Choose PageSpeed Ninja? Are you looking to improve your website’s performance and Google search rankings? PageSpeed Ninja excels in core web vitals and SEO optimization. For over a decade, we’ve been at the forefront of mobile web optimization. You might be familiar with one of our popular projects, Lazy Load XT. PageSpeed Ninja represents our expertise gained from optimizing the performance of over 200,000 websites on mobile devices. We believe you won’t find a similar, user-friendly, all-in-one solution for boosting the performance your website. Benefit from our suite of unique features designed to turbocharge your site’s loading speed. From innovative critical CSS generation for above-the-fold content to implementation of tagged page caching, we ensure lightning-fast load times that improve critical performance metrics such as Largest Contentful Paint (LCP), Cumulative Layout Shift (CLS), and more. Before You Install Our statistics indicate that the plugin improves the speed of 4 out of 5 websites. However, certain theme and plugin combinations, especially those related to caching and optimization, may lead to compatibility issues. Therefore, our plugin might not suit every website. To preview how PageSpeed Ninja could benefit your site, we’ve developed a simple tool that allows you to test it before installing it. We highly recommend that you visit PageSpeed.Ninja and run a test of your website beforehand. Please note: To accurately test your site on PageSpeed.Ninja, it’s crucial to temporarily disable any optimizing plugins. This test requires raw data to apply its own optimization. Features Presets People who own, design, or develop websites are constantly looking for efficient ways to boost performance without getting down in tweaking every single setting. This is precisely where the “Presets” feature of the PageSpeed Ninja comes in. PageSpeed Ninja offers five different presets, each tailored to specific optimization needs: – Optimal: suitable for the majority of websites, – Safe: prioritizes compatibility (only a minimal subset of optimizations is enabled), – Compact: focuses on saving disk space (image optimization and convert to WebP are disabled), – Ultra: aims for maximum optimization (but may be incompatible with some themes and plugins), – Experimental: reserved for testing new, possibly less stable features. PageSpeed Ninja Settings Groups PageSpeed Ninja organizes its settings into groups aligned with the Google PageSpeed Insight categories. Using the data from the Google PageSpeed Insight speed analysis, the plugin categorizes the settings groups into three distinct classes: Should Fix, Consider Fixing, and Passed. Within the General settings, users can easily enable or disable each settings group (specific settings depend on the preset selected), and the Advanced settings page offers fine-tuning all settings according to specific preferences. Each switch in the settings interface is color-coded to reflect its impact on your website’s PageSpeed Insights score: – Green: Improves the score. – Orange: Has minimal effect on the score. – Red: Negatively affects the score. Note that adjusting certain settings may cause related switches to change color due to their interrelated effects on performance. Initial Server Response Time was Short This feature within the PageSpeed Ninja optimizes server responses by implementing efficient caching mechanisms. By using advanced page cache strategies, it reduces response time to incoming requests (the Time To First Byte metric). Serve Static Assets with an Efficient Cache Policy This feature of the PageSpeed Ninja optimizes website performance by implementing an effective caching strategy for static resources. This feature refines the cache policy to improve browser caching for elements such as images, CSS, and JavaScript files. It maximizes caching efficiency by instructing the browser on the optimal duration to retain these assets, reducing server requests and accelerating page load times for returning visitors. Enable Text Compression This setting in the PageSpeed Ninja optimizes website performance by using two powerful compression techniques: Gzip and Brotli compression. Gzip compression, a widely supported method, reduces the size of text-based files such as HTML, CSS, and JavaScript by compressing them before transmission, thereby speeding up website load times. Brotli compression, a newer and more efficient algorithm, further reduces file sizes and improves performance for modern browsers that support this advanced compression method. Preconnect to Required Origins This feature in the PageSpeed Ninja optimizes website performance by initiating early connections to third-party origins, reducing latency and improving load times. Using DNS prefetching, it proactively resolves domain names for faster connections. By pre-establishing connections to essential domains such as CDNs or external APIs, it reduces handshake time and improves overall page speed. Preload Key Requests This setting within the PageSpeed Ninja focuses on optimizing website load times by proactively preloading critical resources. This feature strategically identifies and preloads essential assets, such as fonts, scripts, or CSS files that are required for the initial page rendering process. By fetching these key requests ahead of time, it significantly improves page speed. Minify CSS The “Minify CSS” settings within the PageSpeed Ninja offer a robust set of tools designed to boost website performance by minimizing CSS files. These settings use advanced CSS minification techniques by using a CSS minifier to compress and optimize CSS resources. By reducing CSS size, the plugin significantly improves page load times. Minify JavaScript The “Minify JavaScript” setting in the PageSpeed Ninja provides powerful tools to optimize website performance by reducing JavaScript file sizes. This feature uses advanced JavaScript minification techniques, employing a JavaScript minifier to compress and condense code, improving load times and overall site speed. By enabling JS compression, Minify JavaScript helps to reduce JavaScript size, optimize script delivery and boost web page efficiency. Eliminate Render-Blocking Resources This feature of the PageSpeed Ninja significantly improves page loading speed by focusing on critical aspects of optimization. This feature uses various strategies such as Above-the-fold Critical CSS and Non-blocking JavaScripts to streamline the critical path for fast rendering of essential content. The plugin provides options to inline critical CSS and defer (asynchronously lazy load) non-essential CSS for improved performance. In addition, the plugin manages JavaScript by deferring or asynchronously loading scripts to improve the critical rendering path. Ensure Text Remains Visible During Webfont Load This feature within the PageSpeed Ninja prioritizes the visibility of text while web fonts are loading. It uses the “swap” mode for web fonts to ensure that a fallback font is displayed immediately, preventing a flash of invisible text (FOIT). Additionally, it optimizes the loading of Google Fonts, ensuring that content remains visible during the font-loading process. This optimization significantly improves the user experience and page performance. Avoids Enormous Network Payloads This setting within the PageSpeed Ninja includes several optimization techniques aimed at reducing excessive data transfer. It includes features such as CSS optimization, minifying HTML, bundling/merging CSS and JavaScript files, async script loading, HTML minification, and optimizing emoji loading. Together, these settings work to reduce file sizes and improve page loading speed by minimizing unnecessary network payloads. Efficiently Encode Images This setting within the PageSpeed Ninja provide a comprehensive suite of optimize images tools. This feature allows users to fine-tune the optimization process by adjusting JPEG, WebP, and AVIF qualities to ensure efficient compression. With its range of customizable settings, it allows users to optimize and compress images to varying degrees, serving as a powerful picture optimizer. Serve Images in Next-Gen Formats This feature, a core component of the PageSpeed Ninja, is a key tool for optimizing website images. This feature facilitates the conversion of images into modern formats such as WebP, a next-gen image format known for its superior compression and quality attributes. This setting acts as an image converter, seamlessly converting existing image files into the WebP format, thereby improving website loading speed and performance. By leveraging the capabilities of WebP, this image conversion setting ensures optimal image delivery. Defer Offscreen Images The “Defer offscreen images” feature within the PageSpeed Ninja offers various optimizations aimed at improving page load times by implementing lazy loading techniques. This feature delays the loading of images, videos, and iframes that are not immediately visible on the user’s screen, using image lazyload methods to prioritize content above the fold. The plugin allows users to choose lazy load with one of two types of Low-Quality Image Placeholders (LQIPs): gradient placeholders and blurred low-quality placeholders. These placeholders are displayed in place of the actual images, providing a smoother initial load while the full-quality images lazy load in the background. Image Elements Have Explicit Width and Height This setting in the PageSpeed Ninja focuses on optimizing the rendering of web pages by ensuring that all images have width and height attributes. This optimization strategy aims to prevent layout shifts during page loading by specifying the exact dimensions for each image element and ensures that browsers pre-allocate space for images based on the provided dimensions, eliminating the need for recalculations when images load. JavaScript Execution Time This setting in the PageSpeed Ninja provides control over optimizing JavaScript to improve site performance. It enables features like deferring critical JS to prioritize vital scripts for faster loading, optimizing integrations with platforms (like Facebook, Twitter, etc.) to streamline their scripts’ loading mechanisms, and delaying the loading of all asynchronous JavaScripts to prevent potential bottlenecks. Additionally, it allows for the selective delay of loading of specific JavaScripts in Advanced settings. Avoids an Excessive DOM Size This setting within the PageSpeed Ninja focuses on optimizing webpage performance by reducing the Document Object Model (DOM) size. Currently, this is accomplished by eliminating embedded plugins such as Flash, ActiveX, Silverlight. In the Pro version it’s possible to hide extra DOM elements and reveal them after user interaction. Ongoing development may introduce further optimization techniques to trim excess DOM elements and improve overall website speed. Avoid serving legacy JavaScript to modern browsers This setting allow to detect polyfill JavaScript files and load them in legacy browsers only, thereby reducing network payload. Has a Meta Viewport Tag with width or initial-scale This feature within the PageSpeed Ninja optimizes web pages by ensuring that they contain an important meta viewport tag. This tag is crucial for improving mobile responsiveness. Including this tag allows web content to properly scale and adapt to different devices and screen sizes, ultimately optimizing the page for seamless viewing across a range of devices. Advanced Settings The Advanced Settings page within the PageSpeed Ninja serves as a central hub for users seeking more control over their website optimization. This section not only allows users to fine-tune settings but also facilitates efficient cache management and provides troubleshooting capabilities. Users can adjust specific parameters to tailor the plugin’s performance optimization precisely to their website’s requirements. Free License Key Starting from November 2023, PageSpeed Ninja requires a free license key for connectivity to our servers. This important update results in improved server load balancing to prevent resource exhaustion and ensure uninterrupted performance. You can get your free license key by visiting https://pagespeed.ninja/download/. PageSpeed Ninja Pro PageSpeed Ninja Pro is a powerful plugin designed to optimize website performance through a range of advanced features. It drastically reduces load times with its fast advanced page caching and multithreading background optimization, image optimization features that include properly sizing images and AVIF format support. The plugin excels in efficient CLI asset optimization through minification tools such as UglifyJS for JavaScripts, CSSO for stylesheets, JPEGOptim/OptiPNG/GIFsicle for images, and many others. Its DNS Prefetch and Preload Assistants fine-tune site responsiveness. Notably, it allows users to self-host and optimize external resources like Google Analytics and offers robust backup/restore capabilities, culminating in a comprehensive solution for turbocharging website performance. Get PRO with PageSpeed.Ninja Uninstallation When you delete the plugin, it will automatically revert all settings to the original state as they were before this plugin was installed. During this process, the “/s” directory containing optimized files will be removed and changes made to “.htaccess” files will be undone. Please note that uninstalling the plugin will remove all data associated with the plugin, including settings and logs. Feedback, Bug Reports, and Logging Possible Issues If you have any questions, suggestions, or encounter issues related to site speed optimization, we encourage you to contact us at [email protected]. Whether you’re a user, developer, or tester, your feedback is essential to improving our services. To facilitate troubleshooting, PageSpeed Ninja offers error logging capabilities. You can enable this feature in the Advanced tab of the PageSpeed Ninja settings. If you encounter any problems, you can help us in resolving them by providing us with the relevant error log file. Your assistance will help us improve your experience with PageSpeed Ninja.