After running your WordPress website more than 2 years, you will find your database size bigger than your thoughts. Over time WordPress saves a ton of information to its database, which can become bloated with unnecessary values, thus slowing down your site and putting more stress on your server setup. WordPress database bloat may be the hidden cause of a number of issues your blog may be experiencing!
Just like anything, your WordPress blog also needs some maintenance, servicing and cleaning every now and then to keep it running smoothly, speedily and effectively. In this post we’ll look at 10 ways you can give your WordPress install a spring clean to trim the fat and put everything in its place. It’s help you prevent hidden causes may occurring to your WordPress website.
Backup your files and databases
The first thing to do before you start cleaning job is backup WordPress files and databases to prevent unwanted incidents occurred. I’ve wrote an article about Backup WordPress files and databases, read it if you aren’t.
Cause of Database Bloat
- Spam, Trashed comments and Comments-meta: Like many other folks, I use Akismet to automate the filtering of comments into those that are likely to be genuine and the 99% that sadly are no more than spam links to dodgy sites. Unfortunately,rather than delete all these,Akismet simply holds them in a queue and you have to delete them yourself.
- WordPress Post Revisions: WordPress automatically saves multiple copies of your posts while they’re being written so they can be restored if an editing mistake is made. This can be quite handy if you’re running a multi-author blog, but for most of us it means there’s an insane number of duplicate posts bloating our databases.
- WordPress Post Meta information: Every post in your database is saved with a collection of information. Such information can bloat your database with values that are no longer relevant.
- Unused settings from old plugins: if your site has been live for a number of years, think of all the plugins you’ve installed and since removed in that period of time. Well built plugins will clean up after themselves, but others might have left their settings as values in the options table of your database.
- Un-Optimize WordPress database tables: Over time, data in the database due to constant update and deletion of records gets fragmented, creating overhead. Optimize MySQL tables can be removed and it can speed up database queries.
- Large Log Files: There are too many plugins store logs in your database then it increase the size very fast. I’m using Redirection plugin to fix broken link, after 2 weeks since it installed, I found 8000+ log pages and my database increase double size.
- Database Bloat by Transients: Transient records are temporary data stored by WordPress and plugins. They have expiration data, and if they are missing, they will be regenerated on first use.
Clean up WordPress Database Bloat Issues
Smart Cleanup Tools is an easy to use, powerful plugin for database cleanup with total of 30 cleanup tools. With this plugin you can remove data that is no longer in use, or it is unneeded. Also, it can help you restore database overhead and speed up database operations. Plugin supports WordPress multi website, and it has few tools designed for the Network administration.
You can schedule cleanup jobs to run at any time, they can run once or they can run on a repeat with selected period. All cleanup reports can be saved into files. All plugin settings and settings for scheduled jobs can be exported into file and later imported back.
- Remove oEmbed cached postmeta records (v3.1)
- Remove orphaned relationships records (v3.0)
- Remove expired transient records (also in multisite mode) (v2.5)
- Remove GravityForms spammed submissions (v2.1)
- Remove GravityForms trashed submissions (v2.1)
- Remove draft posts records
- Remove auto-draft posts records
- Remove trashed posts records
- Remove spammed posts records
- Remove published posts revisions records
- Remove orphaned posts revisions records
- Remove trashed comments records
- Remove unapproved comments records
- Remove spammed comments records
- Remove empty postmeta records
- Remove orphaned postmeta records
- Remove empty comment meta records
- Remove orphaned comment meta records
- Remove orphaned comments records
- Remove RSS feeds cache
- Remove empty user meta records
- Remove transient records (also in multisite mode)
- Remove database overhead (also in multisite mode)
WP CleanFix is a management tool for for check, repair, fix and optimize your WordPress blog. The Ajax interface allow to manage all status in one only page!
Performance Optimizer Plugin for WordPress
The plugin will help you increase the performance of your WordPress website. We aim to do this by optimizing key features of the website’s loading process thus increasing the loading speed and limiting the bandwidth consumption.
- database optimization support: The following actions can be performed: remove post’s revisions,remove post’s auto drafts,remove comments marked as spam and optimizes database tables.
- cache system: The caching system includes a wide range of options that you will find in the admin area each option has a detailed description of what it does.
- .htaccess optimization: The .htaccess code will be put in automatically, no configuration needed.
- gzip content: The .htaccess code will be inserted automatically no configuration needed.This feature will help speed up your website if your server offers gzip library.
- adding expiry headers: The .htaccess code will be inserted automatically no configuration needed. This feature will help speed up your website considerably for returning visitors.
- disable hot linking to your blog images from other websites: The .htaccess code will be inserted automatically no configuration needed. This feature will help you save bandwidth.
- minify added for CSS files: The CSS files will be minified automatically, no configuration needed.
- etags support: This will help speed up the site.
- WordPress header optimization: This is the only option that can be customized in the admin section. You can see the configuration possibilities bellow in the “Configuration section”.
WP Clean Up can help us to clean up the WordPress database by removing “revision” “draft” “auto draft” “moderated comments” “spam comments” “trash comments” “orphan postmeta” “orphan comment-meta”, “orphan relationships” “dashboard transient feed”. It allows you to optimize your WordPress database without phpMyAdmin. It adds a settings page to “Dashboard”->”Settings”->”WP Clean Up” where you can clean up the WordPress database. It allows you to remove the redundant data within few clicks. It is a effective tool to keep your database clean and surely save a lot of space of your MySQL Database.
WP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces. It allows you to remove post revisions, comments in the spam queue, un-approved comments within few clicks.
- Remove the WordPress post revisions
- Remove the WordPress auto draft posts [NEW]
- Remove all the comments in the spam queue
- Remove all the un-approved comments
- Apply MySQL optimize commands on your database tables without phpMyAdmin.
- Display Database table statistics. Shows how much space can be optimized and how much space has been cleared.
- Visible only to the administrators.
“Transients are a simple and standardized way of storing cached data in the WordPress database temporarily by giving it a custom name and a timeframe after which it will expire and be deleted.”
Unfortunately, expired entries will only be deleted if you attempt to access the transient again. If you don’t access the transient then, even though it’s expired, WordPress will not remove it. This is a known “issue” and is due to be corrected at some point in the WordPress core code.
Why is this a problem? Transients are often used by plugins to “cache” data (my own plugins included). Because of the housekeeping problems this means that expired data can be left and build up, resulting in a bloated database table.
Meantime, this plugin is the solution, using the same proposed method as the WordPress core change will use. Simply activate the plugin, sit back and enjoy a much cleaner, smaller options table. It also adds the additional recommendation that after a database upgrade all transients will be cleared down.
Scans your WordPress system and identifies and deletes unused database tables from uninstalled plugins. This plugin also allows you to optimize DB Tab. By default if no search criteria is specified, the plugin will identify all tables which have an overhead of greater than 10%. (Note: “Overhead” in this plugin is defined as (Data_free/Data_length) expressed as a percentage and where Data_free and Data_length are MySQL table parameters)
This WordPress plugin Removes some, in my opinion, unused crappy dashboard, post & page widgets, checks for and nukes Hello Dolly, removes junk header tags including the generator tag for extra security, removes update notifications for non-admins, removes old user profile fields like aim, prevents self pinging, removes smilies and track backs, and a few other settings that nobody needs either. This is built to be very generalized so it’ll work with every site as a good clean-up fresh start and help keep clients out of the edit menus.
In next page, you will know how to Clean up WordPress Database Bloat Issues by yourself without plugins