Your WordPress site is getting slower and slower as you have too many posts or are running lots of plugins?
You may already know that Page Speed is confirmed as a critical ranking factor in today’s search engine optimization especially for mobile searches:
Today we’re announcing that starting in July 2018, page speed will be a ranking factor for mobile searches. – Google Webmaster Central Blog
Database performance is one of the most important factors that affect the page speed.
The old school way to optimize your WordPress database:
- Login to your web hosting control panel (for example cPanel).
- Login to the phpMyAdmin.
- Find and select the database you want to optimize.
- Select all tables by Clicking
- In the dropdown list, choose
Too complicated, isn’t it?
To speed up your WordPress sites with no PHP and Mysql skills, the fastest and easiest way is to use a Database optimization plugin.
Database optimization and manipulation are absolutely crucial to managing data on a WordPress website. In order to appropriately manage data and improve speeds on a WordPress site, it’s important to have these tools in place especially when performing bulk edits on posts, pages and more.
With a few database cleaners available for optimizing your WordPress, it is important to pick the plugin that offers the least amount of hassles in optimizing a database.
If you have enough budget I highly recommend that you use a premium WordPress plugin (WP Cleaner Pro as seen below) to optimize & speed up your database.
- Safe and reliable.
- Always updated with the latest WordPress.
- More features.
- With regular updates and support.
WP Cleaner Pro
WP Cleaner Pro is the most efficient and easy to use plugin that can be used to clean and optimize your WordPress website, making your website faster.
You can clean 25 types of data, optimize the database, everything at once or in a scheduled event. Clean UI interface, no back-end errors, optimized for speed.
- Instant cleaning of the WordPress website:
- Trash comments
- Spam comments
- Waiting for moderation comments
- Orphan comment meta
- Duplicated comment meta
- Trash posts
- Orphan post meta
- Duplicated post meta
- Orphan term relationships
- Unused terms
- Duplicated term meta
- Expired transients
- Orphan user meta
- Duplicated user meta
- Subscribers with invalid email
- Weird characters from posts appeared after a database migration
- Weird characters from comments appeared after a database migration
- Comment agent from comments
- oEmbed caches from posts meta
- Links in wp_links table
- Scheduled cleaning of the WordPress database.
- Optimization of the WordPress database.
- Backup of the WordPress database (create/download/delete backups).
- Cleaning process is logged.
- Logs can be seen and deleted.
- Mobile-friendly admin dashboard.
- 25 types of data that can be cleaned.
- View details of what you clean.
- Choose items to clean.
- Filter items to clean.
- Code checked with PHP CodeSniffer.
- Code developed according to WP coding standards.
- Code optimized for speed.
- Mobile-friendly documentation.
- Translation ready (English .mo and .po included).
If you don’t have a budget for WordPress plugins, there are also a large number of excellent and totally free WordPress Database Optimization Plugins on the web.
Here are the top 7 up-to-date and full free Database Optimization Plugins from which you can choose to clean up and optimize the database and speed up your WordPress site. Enjoy.
Originally Published Mar 19 2018, updated Mar 15 2019
Total downloads: 800,000+
WP-Optimize is an effective tool for automatically cleaning your WordPress database so that it runs at maximum efficiency.
- Removes all unnecessary data (e.g. trashed/unapproved/spam comments, stale data) plus pingbacks, trackbacks and expired transient options
- Compact/de-fragment MySQL tables with a button-press
- Detailed control of which optimizations you wish to carry out
- Carries out automatic weekly (or otherwise) clean-ups
- Retains a set number of weeks’ data during clean-ups
- Performs optimizations without the need for running manual queries
- Automatically trigger a pre-optimize backup via UpdraftPlus (https://updraftplus.com)
- Show database statistics and potential savings
- Mobile friendly and easy-to-use
- Translated into several languages
Total downloads: 100,000+
A popular ‘one-click’ plugin to clean and optimize your WordPress database.
- Deletes revisions of posts, pages and / or custom post types (you optionally can keep an ‘x’-amount of the most recent revisions and you can choose to delete revisions older than…)
- Deletes trashed posts, pages and comments (optional)
- Deletes spammed comments (optional)
- Deletes unused tags (optional)
- Deletes ‘expired or all transients’ (optional)
- Deletes ‘pingbacks’ and ‘trackbacks’ (optional)
- Deletes ‘orphan postmeta items’
- Optimizes the database tables (optionally you can exclude certain tables, or even specific posts/pages, from optimization)
- Creates a log file of the optimizations (optional)
- Optimization can be scheduled to automatically run once hourly, twice daily, once daily or once weekly at a specific time (optional)
- ‘Optimize DB (1 click)’ link in the admin bar (optional)
- ‘Optimize Database’ Icon in the admin menu (optional)
- MULTISITE compatible: optimizes all sites in the network with one click
Total downloads: 100,000+
This is a multi-purpose WordPress plugin which can be used to back up, optimize and repair the database.
Tthe plugin automatically creates a folder called database backup ensuring all of the most important files are kept in a separate area for recovery. The vast majority of cleanup options from this plugin are minimal at best however. It’s more designed for recovery and management.
Total downloads: 70,000+
A WordPress plugin focused on clean up your WordPress site by removing useless data such as Revisions, Auto drafts, Deleted comments, Unapproved comments, Spammed comments, Deleted comments, Orphaned post meta, Orphaned comment meta, Orphaned user meta, Orphaned term meta, Orphan term relationships, Unused terms, Duplicated post meta, Duplicated comment meta, Duplicated user meta, Duplicated term meta, Transient options, Optimizes database tables, oEmbed caches in post meta.
Total downloads: 40,000+
This plugin was created by Younes JFR and it performs a number of automatic checks to complete a full-on database cleanup. You might be surprised to know that your database is filled up with a series of old drafts, spam comments that haven’t been deleted and more.
This cleaner can work to regularly clear out almost every aspect of these bulk files which are not benefiting your website in any way. This is one of the most advanced database cleaners available on the WordPress network and it performs a variety of functions that would regularly take hours for a user.
- Delete old revisions of posts and pages
- Delete old drafts of posts and pages
- Delete old auto drafts
- Delete pending comments
- Delete spam comments
- Delete trash comments
- Delete orphan postmeta
- Delete orphan commentmeta
- Delete orphan relationships
- Delete orphan dashboard transient feeds
- You can choose what items to clean-up
- You can schedule your database clean up to run automatically
- Optimize database and improve website speed
- You can schedule your database optimization to run automatically
- View and clean cron tasks (scheduled tasks)
- View and clean tables
- View and clean options
- Supports multisite installation
Optimizing the database is just one way of speeding up your WordPress site. To boost your site’s page speed, there are tons of factors you should consider about: Web hosting, HTML/CSS/JS optimization, cache, CDN and much more. Read our Best WordPress SEO Plugins and visit the SEO section for more information.