Advanced Database Cleaner

Advanced Database Cleaner

Clean database by deleting orphaned data such as 'revisions', 'expired transients', optimize database and more…
Rating:
4.9
star-rating-1star-rating-2star-rating-3star-rating-4star-rating-5
Active Installations:
100000+
Last Updated:
Nov 26, 2024
WordPress Version:
3.1.0 or higher
Tested up to:
6.7.2

Optimize database performance

Clean up your database by deleting unnecessary items such as old revisions and spam comments. This will reduce the size of your database and improve the speed and performance of your website.

Save time with automated cleanup

Schedule database cleanup tasks to run automatically, saving you time and effort. Specify what items should be cleaned and how often, and the plugin will take care of the rest.

Free up storage space

By deleting orphaned items and optimizing your database, you will free up valuable storage space. This means smaller database backups and more efficient use of your server resources.

3.1.5 – 19/09/2024

  • Fix: Automatic conversion of false to array is deprecated
  • Fix: Cannot modify header information – headers already sent..
  • Fix: Object of class stdClass could not be converted to string

3.1.4 – 23/01/2024

  • Security: enhancing the security by avoiding deserialization (thanks to Richard Telleng from Wordfence)
  • PRO: fix endless scan reloading
  • PRO: fix PHP warning: Implicit conversion from float to int
  • PRO: some code cleanup

3.1.3 – 12/09/2023

  • Security: enhancing the security by sanitizing some parameters
  • Fix: fixed ‘Constant FILTER_SANITIZE_STRING is deprecated in PHP 8’
  • Fix: fixed ‘Undefined property : stdClass::$data_free’
  • Fix: fixed ‘PHP Fatal error: Uncaught TypeError: date(): Argument #2 ($timestamp) must be of type ?int’
  • Tweak: better handling of nonces
  • Compatibility: tested with the latest version of WordPress 6.3.1

3.1.2 – 22/02/2023

  • Security fix: when saving the settings
  • Fix: changing the ‘autoload’ of an option may sometimes result in it being created twice
  • Fix: activating both the free and pro versions together causes compatibility issues
  • Tweak: enhancing some blocks of code to use Ajax
  • Tweak: better handling the use of the WP_List_Table class
  • Tweak (PRO): enhancing the license page + the update process of the plugin
  • Compatibility: Tested with the latest version of WordPress 6.1.1

3.1.1 – 24/06/2022

  • Security fix: enhancing the security of the plugin by escaping some URLs before outputting them

3.1.0 – 16/06/2022

  • Fix: fixing the error ‘Fatal error: Can’t use function return value in write context’
  • Fix: fixing the Warning: count(): Parameter must be an array or an object that implements Countable
  • Tweak: correcting of some typos and grammar
  • Tweak: deleting some useless data from “overview & settings” tab
  • Tweak: enhancing the CSS code, the plugin is responsive now and can be used in small screens
  • Tweak: enhancing some blocks of PHP code
  • New: adding “delete filter” for custom cleanup elements in “general cleanup” tab
  • Info: since we have changed a lot of CSS code, please refresh your browser cache or click “Ctrl + F5”
  • Info: great feature will be added to the next version

3.0.4 – 21/01/2022

  • Tweak: Enhancing the security of the plugin
  • Tweak: Testing the plugin with latest versions of WP

3.0.3 – 06/10/2020

  • Tweak: Cleaning the code by deleting unused blocks of code
  • Tweak: Enhancing the security of the plugin

3.0.2 – 01/09/2020

  • Fix: fixing an issue in the general cleanup tab preventing users from deleting orphaned items
  • Tweak: we are now using SweetAlert for all popup boxes
  • Tweak: enhancing the JavaScript code
  • Tweak: enhancing some blocks of code
  • Tweak: enhancing the security of the plugin

3.0.1 – 26/08/2020

  • Fix: some calls in the JS file has been corrected
  • Fix: the warning “Deprecated: array_key_exists()” is now solved
  • Fix: an issue of ‘failed to open stream: No such file or directory’ is now solved
  • Tested with WordPress 5.5
  • New features very soon!

3.0.0 – 05/12/2019

  • IMPORTANT NOTICE FOR PRO USERS: After you upgrade to 3.0.0 from an old version, you will notice that WordPress has deactivated the plugin due to an error: ‘Plugin file does not exist’. This is because we have renamed the pro plugin folder name from “advanced-db-cleaner” to “advanced-database-cleaner-pro”, causing the WordPress to not being able to find the old one and therefore deactivating the plugin. Just activate it again. It doesn’t break anything. Once you activate the plugin again it will continue working normally without any issues. You will also probably lose the pro version after this upgrade (This is due to a conflict between the free and pro versions which is now solved). If it is the case, please follow these steps to restore your pro version with all new features: (https://sigmaplugin.com/blog/restore-pro-version-after-upgrade-to-3-0-0)

  • COMPATIBILITY: The plugin is tested with WordPress 5.3

  • CHANGE: Some changes to readme.txt file
  • REMOVE: Drafts are not cleaned anymore in 3.0.0 since many users have reported that drafts are useful for them
  • New: You can now clean up new items: pingbacks, trackbacks, orphaned user meta, orphaned term meta, expired transients
  • New: The plugin icon in the left side menu has been changed to white color
  • New: Change text-domain to ‘advanced-database-cleaner’
  • New: Enhancements to the look and feel of the plugin
  • New: The sidebar has been changed for the free version and deleted in the pro version
  • New: For options, we have added the option size column and two new actions: Set autoload to no / yes
  • New: For tables, we have added two actions: Empty tables and repair tables
  • New: You can now order and sort all items
  • New: You can change the number of items per page
  • New: You can keep last x days’ data from being cleaned and clean only data older than the number of days you have specified
  • New: You can specify elements to cleanup in a scheduled task. You can also create as many scheduled tasks as you need
  • New: Add information to each line of unused data in ‘General clean-up’ tab to let users know more about each item they will clean
  • New: Display/view items before cleaning them (in ‘General cleanup’ tab) is now in the free version
  • New: Add a new setting to hide the “premium” tab in the free version
  • Fix: Repair some strings with correct text domain
  • Fix: Some tasks with arguments can’t be cleaned. This is fixed now
  • Fix: Some tasks with the same hook name and different arguments were not displayed. This is fixed now
  • Fix: In some previous versions, tables were not shown for some users. This has been fixed
  • PERFORMANCE: All images used by the plugin are now in SVG format
  • PERFORMANCE: Restructuring the whole code for better performance
  • SECURITY: add some _wpnonce to forms
  • New (PRO): Add “Pro” to the title of the pro version to distinguish between the free and the pro versions
  • New (PRO): You can now search and filter all elements: options, tables, tasks, etc. based on several criteria
  • New (PRO): Add progress bar when searching for orphan items to show remaining items to process
  • New (PRO): Add a category called “uncategorized” to let users see items that have not been categorized yet
  • Fix (PRO): The activation issue is now fixed
  • Fix (PRO): The scan of orphaned items generated timeout errors for big databases, we use now ajax to solve this
  • Fix (PRO): A conflict between the free and the pro versions is now solved
  • PERFORMANCE (PRO): We are now using an enhanced new update class provided by EDD plugin
  • PERFORMANCE (PRO): Set autoload to no in all options used by the plugin
  • PERFORMANCE (PRO): The plugin does not store scan results in DB anymore. We use files instead
  • SECURITY (PRO): The license is now hidden after activation for security reasons
  • WEBSITE (PRO): You can now view your purchase history, downloads, generate an invoice, upgrade your license, etc. Read more
  • WEBSITE (PRO): Enhancements of the plugin premium page

2.0.0

  • Some changes to readme.txt file
  • Changing the way the plugin can be translated
  • Correcting __() to some texts
  • Correcting some displaying texts
  • Big change in styles
  • Restructuring the whole code for better performance
  • Creation of the plugin main page: (https://sigmaplugin.com/downloads/wordpress-advanced-database-cleaner)
  • Adding language translation support
  • Correct the time zone offset for the scheduled tasks
  • Skipping InnoDB tables while optimizing
  • Change size of lost tables data from ‘o’ to ‘KB’
  • Main menu is now under ‘Tools’ not ‘settings’
  • Adding separate left menu (can be disabled)
  • Adding overview page with some useful information
  • Adding settings page
  • “Reset database” is now in a separate plugin (please view our plugins page)
  • Multisite: now only the main site can clean the network
  • New feature: Display/view items before cleaning them (Pro)
  • New feature: view and clean options
  • New feature: Detect orphan options, plugins options, themes options and WP options (Pro)
  • New feature: view and clean cron (scheduled tasks)
  • New feature: Detect orphan tasks, plugins tasks, themes tasks and WP tasks (Pro)
  • New feature: view and clean database tables
  • New feature: Detect orphan tables, plugins tables, themes tables and WP tables (Pro)

1.3.7

  • Adding “clean trash-posts”
  • Updating FAQ
  • Updating readme file
  • Tested up to: 4.4

1.3.6

  • Fixing a problem in donate button
  • Using _e() and __() for all texts in the plugin

1.3.5

  • New feature: Adding “Clean Cron”. You can now clean unnecessary scheduled tasks.
  • Updating FAQ

1.3.1

  • Adding FAQ

1.3.0

  • Some code optimizations
  • New feature: Support multisite. You can now clean and optimize your database in multisite installation.

1.2.3

  • Some optimizations and style modifications
  • New feature: Adding the scheduler. You can now schedule the clean-up and optimization of your database.

1.2.2

  • Some optimizations and style modifications

1.2.1

  • Some optimizations and style modifications
  • “Clean database” tab shows now only elements that should be cleaned instead of listing all elements.
  • “Clean database” tab shows now an icon that indicates the state of your database.
  • “Optimize database” tab shows now only tables that should be optimized instead of listing all tables.
  • “Optimize database” tab shows now an icon that indicates the state of your tables.
  • “Reset database” shows now a warning before resetting the database.

1.2.0

  • Some optimizations and style modifications
  • New feature: Adding “Reset database”

1.1.1

  • Some optimizations and style modifications
  • Adding “Donate link”

1.1.0

  • Some optimizations and style modifications
  • New feature: Adding “Optimize Database”

1.0.0

  • First release: Hello world!

My site is Polycomposite

By mfahul on February 24, 2025

good plugin

👍🏻

By cleverlittleschmidt on February 21, 2025

Did the job, wasn't too hard to use.

Пока все нормально

By doberman99 on February 20, 2025

Здравствуйте! Установил плагин неделю назад, пока все нормально. Настроил автоматическую отчиску, с другими плагинами не конфликтует. Самое главное, настройки на Русском, все ясно и понятно. Спасибо за плагин!

Works Great

By egambiani on February 19, 2025

Simple way to clean database. I would recommend!

Awesome Plugin

By Claudiu T. on February 19, 2025

It does what it says it does.

Good plugin !

By pascal100359 on February 19, 2025

Très content !

good

By amoran26 on February 19, 2025

good

Fantastic DB plugin

By iHuman on February 19, 2025

Great plugin. Simple to use Efficient! Add it to your site…you’ll be glad you did!

Essential tool for maintinaing DB integrity

By Timothy Michel (Edgar_Michel) on February 18, 2025

Had accidentally set DB collation type to utf8mb3_unicode-ci instead of utf8mb4_unicode_ci. Ran queries on the DB to change the collation to utf8mb4_unicode_ci and then ran Advanced DB Cleaner and everything works very well now.

The Pro Version Business is great!

By nmrockswp on February 16, 2025

I have been using the Pro Version Business for many years and can only recommend the plugin to anyone who wants to keep their WordPress database clean.
Try other plugins too!

WebP Uploads

Creates WebP versions for new JPEG image uploads if supported by the server.

Try Demo More Details

Brozzme DB Prefix & Tools Addons

Easily change your WordPress DB prefix, save time, increase security.

Try Demo More Details

Image Optimization For SEO

Image Optimization For Seo is the wordPress plugin. This plugin Resize and Compress the images to boost your site speed. It's also replaces the t …

Try Demo More Details
Screenshots
Author Site Author Site

Try Advanced Database Cleaner With InstaWP

Contact Sales

Reach out to us to explore how InstaWP can benefit your business.