Is There An Automatic Way To Clean Up A Worpress Site

Clean upward database past deleting orphaned items such every bit 'one-time revisions', 'spam comments', optimize database and more…

If yous take been using WordPress for a while, then you should think absolutely about a database cleanup. Indeed, your database may be total of garbage that makes your site sluggish and swollen such equally one-time revisions, orphaned mail meta, spam comments, etc. Y'all should make clean-up this unnecessary data to reduce your database size and improve website speed and performance. In add-on, y'all will have quicker database backup since the file of your fill-in will be smaller.

'Advanced Database Cleaner' is a must-have plugin that allows you to clean database, optimize database and more.

Main Features

Delete old revisions of posts and pages
Delete erstwhile machine drafts
Delete trash posts
Delete pending comments
Delete spam comments
Delete trash comments
Delete pingbacks
Delete trackbacks
Delete orphan mail service metadata
Delete orphan comment metadata
Delete orphan user metadata
Delete orphan term metadata
Delete orphan relationships
Delete expired transients
Display and view orphaned information earlier making a database clean-up so yous tin be sure about what you are going to clean-upwards
Search & filter all items based on their names or values
Keep last x days' information from being cleaned: clean just data older than the number of days you take specified
Schedule database clean up to run automatically
Create as many scheduled cleanup tasks as you need and specify what items should be cleaned by the scheduled job
Scheduled tasks can be executed based on several frequencies: Once, hourly, twice a solar day, daily, weekly or monthly
Display database tables data such as the number of rows, tabular array size, etc.
Optimize database tables (The plugin will notify yous if any tables require optimization)
Repair corrupted database tables or damaged ones (The plugin will notify you if whatever tables are corrupted or damaged)
Schedule database optimization and/or reparation to run automatically and specify what tables should be optimized and/or repaired
Empty database tables rows
Clean and delete database tables
Display options list
Display options data such as option name, option value, option size, option autoload
Clean and delete options
Prepare options autoload to no / aye
Display active cron tasks list (scheduled tasks) with their information such equally arguments, side by side run, etc.
Clean and delete scheduled tasks
User-friendly and uncomplicated to use

Multisite Support

The plugin is compatible with Multisite installations
Only the main site can view, clean and optimize the whole network. Other sites in the network cannot perform these tasks. We take opted for this philosophy because we are sure that your DB is precious and only the super ambassador can perform such actions
Yous tin can clean upwards all sites from one place (the main site). You can also specify specific sites yous desire to cleanup

By using the ADC plugin, you volition

Get and overview: The plugin will assist you lot get an overview of what is happening in your database. It will study all unused/orphaned items that should be cleaned, it will give you the number of tables/options/tasks you have, etc. This way, y'all can control your database if anything goes wrong
Salve time: Y'all can specify what items should be cleaned/optimized/repaired, what is the number of days' data to proceed and the cleanup/optimization/reparation frequency. The plugin will and then automate the process to run automatically based on your settings
Save infinite: By deleting unused/orphaned items, y'all will salvage space in your database and make quicker backups since the file of your backup will be smaller

Pro Features (Official website)

Do you know that even afterwards deleting a plugin/theme from your WordPress website, some of its leftovers may remain in your database? Such as orphan options, orphan tables, and orphan cron tasks. As you may know, not all plugins/themes care virtually the housekeeping of your WordPress database. As long as you are removing plugins/themes, leftovers volition be accumulated in your database and volition influence your website functioning. The Pro version of Avant-garde Database Cleaner will assistance you remove all those leftovers and perform a deep database clean upwards. In the pro version you can:

Allocate options according to their "creator". They tin can exist either: plugins options, themes options or WP core options
Detect and delete orphan options. Your 'wp_options' table may be full of orphaned options and therefore can affect the performance of loading data from information technology, which may pb to a slow website. Make clean up orphaned options is then important
Classify tables according to their "creator". They tin be either: plugins tables, themes tables or WP cadre tables
Detect and delete orphan tables. As for options, you may also accept some orphaned tables that were created by plugins/themes you are not using anymore. Clean up orphaned tables volition subtract the size of your database
Allocate all cron tasks (cron jobs) according to their "creator". They tin can be either: plugins cron tasks, themes cron tasks or WP core tasks
Detect and delete orphan cron jobs. Afterward you lot uninstall a plugin/theme, some of its cron tasks may even so be active making WordPress calling unknown functions. using the pro version, y'all can notice and clean orphaned tasks
Search & filter options, filter tables and filter cron tasks based on several criteria such as the "name", "creator", "value", etc.
Get premium back up: we volition provide quick support as well as any technical answers to help you clean upward your database efficiently

Translations

You are welcome to contribute to the plugin translation via the WordPress translation website.

Thank you To

Fabio Fava for translating the plugin to pt_BR
Julio Potier for the security remarks

This section describes how to install the plugin. In full general, there are 3 ways to install this plugin similar any other WordPress plugin.

1. Via WordPress dashboard

Click on 'Add New' in the plugins dashboard
Search for 'advanced-database-cleaner'
Click 'Install At present' button
Activate the plugin from the same page or from the Plugins dashboard

ii. Via uploading the plugin to WordPress dashboard

Download the plugin to your computer from (https://wordpress.org/plugins/advanced-database-cleaner/)
Click on 'Add New' in the plugins dashboard
Click on 'Upload Plugin' push button
Select the naught file of the plugin that you accept downloaded to your computer earlier
Click 'Install At present'
Activate the plugin from the Plugins dashboard

3. Via FTP

Download the plugin to your computer from (https://wordpress.org/plugins/advanced-database-cleaner/)
Unzip the zip file, which will extract the 'advanced-database-cleaner-3.0.0' directory
Upload the 'advanced-database-cleaner' directory (included within the extracted folder) to the /wp-content/plugins/ directory in your web infinite
Actuate the plugin from the Plugins dashboard

For Multisite installation

Log in to your master site and go to "My Sites" » "Network Admin" » "Plugins"
Install the plugin post-obit one of the above ways
Network actuate the plugin (Note that only the primary site can have access to the plugin)

Where the plugin carte du jour volition be displayed?

The plugin page tin can exist accessed via "Dashboard" » "Tools" » "WP DB Cleaner" or via the left menu "WP DB Cleaner" (You can change this via the plugin settings)

What does mean "clean my database"?: Every bit yous employ WordPress, your database accumulates a lot of extra data such as revisions, spam comments, trashed comments, etc. Removing this unnecessary information volition reduce your database size, speeds upwards your fill-in process and speeds up your site also.
Is it safe to clean my database?: Aye, it is. We do non run whatever code that can break down your site or delete your posts, pages, comments, etc. Nonetheless, make sure to always back up your database earlier any cleanup. This is not optional; it is required! It is always ameliorate to be safety than lamentable!
What does hateful "Optimize my database"?: Optimizing your database will reclaim unused space in your tables, which will reduce storage space and ameliorate efficiency when accessing tables. Optimizing the database can sometimes significantly improve performance, particularly on sites that receive a lot of traffic or have a big corporeality of content. Optimizing your database is absolutely prophylactic.
Is information technology safe to make clean the cron (scheduled tasks)?: A scheduled task enables plugins to execute some actions at specified times, without having to manually execute code at that time. WordPress itself uses some scheduled tasks to perform some regular actions. Still, some scheduled tasks may not be removed even if the responsible plugins are deleted from your WordPress installation. As yous know, not all plugins care about the housekeeping of your WordPress. Hence, deleting these unnecessary tasks may help in cleaning your site. It should exist noted that cleaning scheduled tasks is safe every bit long as you know what tasks to make clean. If you are not sure, information technology is better to not clean any job.
What does hateful "Revision"? What sql lawmaking is used to make clean information technology?: WordPress stores a record (called "revision") of each saved typhoon or published update. This system allows yous to see what changes were made in each post and folio over time. Nevertheless, this can lead to a lot of unnecessary overhead in your WordPress database, which consumes a lot of space. The sql query used by the plugin to clean all revisions is:
DELETE FROM posts WHERE post_type = 'revision'
What does mean "Auto-draft"? What sql code is used to make clean it?: WordPress automatically saves your postal service/page while you are editing it. This is called an car-draft. If you don't hit the publish/update button, then the post/page will be saved as car-draft and whatsoever modification to your post/folio will not be visible in your public site. Over time, you could accept multiple automobile-drafts that you will never publish and hence yous tin can make clean them. The sql query used past the plugin to make clean all car-drafts is:
DELETE FROM posts WHERE post_status = 'automobile-typhoon'; Pending comments are comments published by users and which are waiting for your approval earlier appearing in your site. In some cases, you lot will have to make clean all these comments. The sql query used by the plugin to make clean all pending comments is:
DELETE FROM comments WHERE comment_approved = '0'; It is a comment that you (or a plugin) take marked equally spam. The sql query used by the plugin to make clean all spam comments is:
DELETE FROM comments WHERE comment_approved = 'spam'; A trash comment is a annotate that you have deleted from your WordPress and have been moved to the trash. A trash annotate is not visible in your site and should exist deleted forever. The sql query used by the plugin to clean all trash comments is:
DELETE FROM comments WHERE comment_approved = 'trash'
What does mean "trackback"? What sql code is used to clean information technology?: Trackbacks allows y'all to notify other websites owners that yous have linked to their article on your website. These trackbacks can be used to send huge amounts of spam. Spammers use them to get their links posted on as many sites as possible. That is why they should be deactivated/cleaned if you do not use them. The sql query used past the plugin to make clean trackbacks is:
DELETE FROM comments WHERE comment_type = 'trackback'
What does mean "pingback"? What sql code is used to clean it?: Pingbacks allow you to notify other websites owners that you have linked to their commodity on your website. Pingbacks were designed to solve some of the issues that people saw with trackbacks. Although there are some minor technical differences, a trackback is basically the same things every bit a pingback. These pingbacks can exist used to transport huge amounts of spam. Spammers use them to get their links posted on as many sites every bit possible. That is why they should exist deactivated/cleaned if you practise not apply them. The sql query used by the plugin to make clean pingbacks is:
DELETE FROM comments WHERE comment_type = 'pingback'
What does mean "Orphan post meta"? What sql code is used to clean it?: The post meta data is the data you provide to viewers well-nigh each post. This information usually includes the author of the postal service, when information technology was written (or posted), and how the author categorized that particular post. In some cases, some post meta data data becomes orphan and does not belong to any post. They are then called "orphan postmeta" and should be cleaned since they are non useful. The sql query used by the plugin to clean all orphan postmeta is:
DELETE pm FROM postmeta pm LEFT JOIN posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL; The aforementioned as "Orphan mail meta" with the exception that "orphan comment meta" business comments and not posts. The sql query used by the plugin to make clean all orphan comment meta is:
DELETE FROM commentmeta WHERE comment_id Not IN (SELECT comment_id FROM comments)
What does hateful "Orphan user meta"? What sql code is used to make clean it?: The user meta information is the data you provide to viewers about each user. This information usually includes additional data that is not stored in the users table of WordPress. In some cases, some user meta data data becomes orphaned and does non vest to whatsoever user. They are then called "orphaned usermeta" and should be cleaned since they are non useful. The sql query used by the plugin to clean all orphan comment meta is:
DELETE FROM usermeta WHERE user_id NOT IN (SELECT ID FROM users)
What does mean "Orphan term meta"? What sql lawmaking is used to clean it?: The term meta data is the information that is provided for each taxonomy term. This data usually includes additional data that is not stored in the terms table of WordPress. In some cases, some term meta data data becomes orphaned and does not vest to whatever taxonomy term. They are then called "orphaned termmeta" and should be cleaned since they are not useful. The sql query used by the plugin to clean all orphan comment meta is:
DELETE FROM termmeta WHERE term_id Not IN (SELECT term_id FROM terms)
What does hateful "Orphan relationships"? What sql code is used to clean it?: Sometimes the wp_term_relationships table becomes bloated with many orphaned relationships. This happens especially oft if yous're using your site not as a blog but as some other type of content site where posts are deleted periodically. Over fourth dimension, you could go thousands of term relationships for posts that no longer exist which consumes a lot of database space. The sql query used by the plugin to clean all orphan relationships is:
DELETE FROM term_relationships WHERE term_taxonomy_id=1 AND object_id Non IN (SELECT id FROM posts)
What does hateful "expired transient"?: Transients are a fashion of storing cached data in the WordPress DB temporarily by giving it a name and a time frame after which it will elapse and be deleted. This helps improve WordPress operation and speed up your website while reducing the overall server load. Expired transients are transients that are expired and even so exist in the database. These ones tin can exist safely cleaned. Transients housekeeping is now office of WordPress core, every bit of version 4.9, and so no need to clean up them manually unless you lot take specific needs.
Is this plugin compatible with multisite?: Yes, it is compatible with multisite. It should be noted that only the main site in the network tin can clean the database and orphan items of all the network. We prevent other sites to make clean your DB since we believe that only the super administrator has the right to perform such performance. Your database is precious!
Is this plugin compatible with SharDB, HyperDB or Multi-DB?: Actually the plugin is non supposed to be compatible with SharDB, HyperDB or Multi-DB. Nosotros will endeavor to make it compatible in the coming releases.
Does this plugin cleans itself after the uninstall?: We practise make clean-up of your WordPress site, information technology volition be a shame if the plugin does not clean itself after an uninstall! Of course yes, the plugin cleans itself and removes any data used to shop its settings one time uninstalled.

Melhorou bastante a operation do meu banco de dados.

Not been installed for very long... so too early to give an accurate, or five-star rating.

Zip bad to point out.

sembra funzionare molto bene

The interface is quite manifestly and information technology can be understood even by not-technical people.

Read all one,006 reviews

"Advanced Database Cleaner" is open source software. The following people take contributed to this plugin.

Contributors

Younes JFR.

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/ten/2020

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

three.0.2 – 01/09/2020

Set up: fixing an consequence 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 lawmaking
Tweak: enhancing the security of the plugin

3.0.1 – 26/08/2020

Prepare: some calls in the JS file has been corrected
Fix: the alert "Deprecated: array_key_exists()" is now solved
Set up: an issue of 'failed to open stream: No such file or directory' is now solved
Tested with WordPress five.v
New features very presently!

3.0.0 – 05/12/2019

Important Observe FOR PRO USERS: Later on you lot upgrade to 3.0.0 from an quondam version, you will notice that WordPress has deactivated the plugin due to an error: 'Plugin file does not exist'. This is considering we have renamed the pro plugin folder proper name from "avant-garde-db-cleaner" to "advanced-database-cleaner-pro", causing the WordPress to not being able to find the old ane and therefore deactivating the plugin. But activate it over again. Information technology doesn't break anything. Once yous activate the plugin once again it will continue working normally without any issues. You lot will also probably lose the pro version later on this upgrade (This is due to a disharmonize betwixt 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-three-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 take reported that drafts are useful for them
New: Yous can at present 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 await and feel of the plugin
New: The sidebar has been inverse for the free version and deleted in the pro version
New: For options, we accept added the option size column and two new actions: Set autoload to no / yeah
New: For tables, we take added two actions: Empty tables and repair tables
New: You can now society and sort all items
New: Yous can modify the number of items per folio
New: You can go on terminal x days' data from being cleaned and clean but data older than the number of days you have specified
New: You lot tin 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 make clean-upwards' tab to permit users know more about each item they will make clean
New: Display/view items earlier cleaning them (in 'General cleanup' tab) is at present in the free version
New: Add a new setting to hibernate the "premium" tab in the free version
Fix: Repair some strings with correct text domain
Set up: Some tasks with arguments can't be cleaned. This is fixed now
Fix: Some tasks with the same hook proper name and unlike arguments were not displayed. This is stock-still now
Set: In some previous versions, tables were not shown for some users. This has been stock-still
Performance: All images used past the plugin are now in SVG format
PERFORMANCE: Restructuring the whole lawmaking for better performance
SECURITY: add together 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 tin 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 outcome is now fixed
Prepare (PRO): The scan of orphaned items generated timeout errors for big databases, we use at present ajax to solve this
Prepare (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 past the plugin
Operation (PRO): The plugin does not store scan results in DB anymore. We use files instead
SECURITY (PRO): The license is now subconscious after activation for security reasons
WEBSITE (PRO): You can now view your buy history, downloads, generate an invoice, upgrade your license, etc. Read more than
WEBSITE (PRO): Enhancements of the plugin premium folio

2.0.0

Some changes to readme.txt file
Irresolute the way the plugin tin exist translated
Correcting __() to some texts
Correcting some displaying texts
Big change in styles
Restructuring the whole lawmaking for better operation
Creation of the plugin master folio: (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
Modify size of lost tables information from 'o' to 'KB'
Main menu is now nether 'Tools' not 'settings'
Adding carve up 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 folio)
Multisite: now only the main site tin clean the network
New characteristic: Brandish/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 characteristic: Detect orphan tasks, plugins tasks, themes tasks and WP tasks (Pro)
New feature: view and make clean database tables
New characteristic: Detect orphan tables, plugins tables, themes tables and WP tables (Pro)

1.3.7

Calculation "clean trash-posts"
Updating FAQ
Updating readme file
Tested upwardly to: four.4

1.iii.6

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

1.3.5

New characteristic: Calculation "Make clean Cron". Yous can now clean unnecessary scheduled tasks.
Updating FAQ

ane.iii.1

Adding FAQ

1.iii.0

Some lawmaking optimizations
New feature: Back up multisite. You can now clean and optimize your database in multisite installation.

ane.2.3

Some optimizations and fashion modifications
New feature: Adding the scheduler. Y'all can now schedule the make clean-up and optimization of your database.

1.ii.2

Some optimizations and way modifications

ane.2.i

Some optimizations and mode modifications
"Clean database" tab shows now just 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 at present a warning before resetting the database.

1.2.0

Some optimizations and style modifications
New feature: Calculation "Reset database"

1.1.1

Some optimizations and manner modifications
Adding "Donate link"

1.1.0

Some optimizations and manner modifications
New feature: Adding "Optimize Database"

1.0.0

Get-go release: Hi globe!