Aug 062019
 

WP Database Cleaner Plugin tutorial shows you how to manage and maintain a clean and optimize database using this great plugin.

Last Updated: August 11, 2019

Latest News: I updated the documentation.

clean-and-optimize-wordpress-database-plugin

Advanced Database Cleaner plugin is simple and easy to use and setup. It has many potential features that help you maintain and optimize your database without having to leave your admin site. It is a simple plugin for users who don’t have any database knowledge and don’t know how to log into their server and use phpMyAdmin or something similar to clean the database.

This tutorial list below will show you how to set up and use Advanced Database Cleaner plugin.

Advanced Database Cleaner changelog 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’
  • and more.

What You Need:

WP Database Cleaner Tutorials:

WP Database Cleaner Plugin

Warning: Before you begin, make sure you create a database backup of your site. Just in case something goes wrong.

Before You Begin

Make a note of the following list of 12 default tables used by WordPress. These 12 tables exist in your site, before other tables are added by plugins or theme/s. It is important that you make a note of this. It can help you make sure you don’t delete any of these default WordPress tables by accident.

Note: Click the following link Database Description to learn more. 

Default WordPress Tables

  • wp_options
  • wp_users
  • wp_links
  • wp_commentmeta
  • wp_term_relationships
  • wp_postmeta
  • wp_posts
  • wp_term_taxonomy
  • wp_usermeta
  • wp_terms
  • wp_comments
  • wp_termmeta

Step 1 ) Go to WP DB Cleaner as illustrated in the image to start setting up the plugin.

wp-database-cleaner-plugin-admin-panel

Step 2 ) The following image shows you the different admin tabs available for you to setup and help you keep your database clean and optimized.

WP DB Cleaner Admin Tabs

  • General clean-up
  • Optimize
  • Tables
  • Options
  • Scheduled tasks
  • Overview & Settings
  • Premium

wp-database-cleaner-admin-tabs

General clean-up

Step 3 ) Go to WP DB Cleaner -> General clean-up as illustrated in the image below to clean up the following options. In the following list you can see 3 different elements that need attention.

Note: The View option is only available in pro version.

General clean-up Options

  • Revisions 13 view = There are 16 revisions that can be cleaned.
  • Drafts 1 view = There is 1 draft that can be cleaned.
  • Auto Drafts 1 view = There is 1 auto draft that can be cleaned.
  • Trash posts
  • Pending comments
  • Spam Comments
  • Trash comments
  • Orphan Postmeta
  • Orphan Commentmeta
  • Orphan Relationships
  • Dashboard Transient Feed

wp-database-cleaner-general-clean-up-options

Step 3-a ) The following image allows you to set up General clean-up scheduled options. Click on the drop down menu to select when you want to schedule the clean up run.

wp-database-cleaner-general-clean-up-schedule-options

Optimize

Step 4 ) Go to WP DB Cleaner -> Optimize as illustrated in the image below to optimize any table that needs optimizing. The following image shows you all tables optimized. You can also set up the Optimize scheduled options. Click on the drop down menu to select when you want to schedule the table optimize run.

wp-database-cleaner-optomize-tab-options

Tables

Step 5 ) Go to WP DB Cleaner -> Tables as illustrated in the image below to check and delete any obsolete tables if there are any.

Note: Remember to read the note in yellow. It is important that you don’t delete any tables that belong to a plugin or theme and is currently used in your site.

Tables List Options

  • All tables: 18 = Currently there are 18 tables in this database.
  • Orphan tables = Only available in pro version.
  • Plugin tables = Only available in pro version.
  • Themes tables = Only available in pro version.
  • WP tables = Only available in pro version.

wp-database-cleaner-plugin-tables-tab-options

Options

Step 6 ) Go to WP DB Cleaner -> Options as illustrated in the image below to check and delete any obsolete options if there are any.

Note: Remember to read the note in yellow. It is important that you don’t delete any options that belong to a plugin or theme and is currently used in your site.

Tables List Options

  • All tables: 131 = Currently there are 18 tables in this database.
  • Orphan options = Only available in pro version.
  • Plugin options = Only available in pro version.
  • Themes options = Only available in pro version.
  • WP options = Only available in pro version.

Scheduled tasks

Step 7 ) Go to WP DB Cleaner -> Scheduled tasks as illustrated in the image below to check and delete any schedule tasks that is not needed any more.

Note: Remember to read the note in yellow. It is important that you don’t delete any schedule tasks that is currently in used.

Tables List Options

  • All tasks: 10 = Currently there are 18 tables in this database.
  • Orphan tasks = Only available in pro version.
  • Plugin tasks = Only available in pro version.
  • Themes tasks = Only available in pro version.
  • WP tasks = Only available in pro version.

wp-database-cleaner-plugin-scheduled-tasks-tab-options

The above steps should help you maintain a cleaner and optimize table for your site.

If you have any questions please let me know. I will be updating this post from time to time. So keep coming back for the latest.

Enjoy.

Manuel Ballesta Ruiz is a web developer, Blogger and WordPress Enthusiast.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)