WP-Optimize is an extensive WordPress database cleanup and optimization tool. It doesn't require PhpMyAdmin to clean and optimize your database tables.
Please show your support for this plugin by giving it a rating :)
Now hosted at GitHub. I do not monitor wp forums, so use plugins+support(at)ruhanirabin.com for support questions.
Please join GitHub and collaborate.
Removal of stale post revisions
Removal of stale unapproved and spam comments
Removal of trshed comments
Mobile device friendly, now you can optimize your site on the go
Removal of all trackbacks and pingbacks
Cleaning up auto draft posts
Removal of transient options
Clear out the post trash
Automatic cleanup of all the integrated options (also uses retention if enabled)
Ability to keep selected number of weeks data when cleaning up
Option to add or remove link on wp admin bar.
Enable/Disable weekly schedules of optimization
Apply native WordPress MySql optimize commands on your database tables without phpMyAdmin or any manual query.
Display Database table statistics. Shows how much space can be optimized and how much space has been cleared.
Enabled for Administrators only.
All the potentially dangerous clean up options are marked RED.
When you use this plugin for the first time or just updated to major version, make a backup of your database. It is always the best practice to make a database backup before using this program first time.
How this could help you?
Every-time you save a new post or pages, WordPress creates a revision of that post or page. If you edit a post 6 times you might have 5 copy of that post as revisions. Imagine if your post or pages are long and big. It is a huge number of bytes that's on your MySQL overhead. Now WP-Optimize allows you to optimize and shrink your posts table by removing not necessary post revisions from the database. As example, if you have a post which is approximately 100KB data and you have 5 revisions of that post, the total space wasted is about 500KB. And if you have 100 posts similar to it, you have 50MB database space wasted.
Similar to the scenario described above, there might be thousands of spam and un-approved comments in your comments table, WP-Optimize can clean and remove those in a single click
WP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces
Automatically cleans database every week and respects the "Keeps selected number of weeks data" option.
Are you interested to be a contributed developer of this plugin, join with me at GitHub. Or email plugins(at)ruhanirabin.com
You will be credited inside the plugin screen and the plugin listing at WordPress.
Translators are welcome to send their Translated Files to be included.Existing translators should join GitHub to submit their translations too.
Download the RAW .POT file. This is for the translators, who wants to translate to new language.
You can Email translations to plugins(at)ruhanirabin.com
Language ru_RU: Русский язык - Виталий МакЛауд (Эликсир жизни) - http://www.visbiz.org/
Language zh_TW: 正體中文語系檔案由香腸炒魷魚(香腸)翻譯。 - http://sofree.cc
Language zh_CN: 简体中文语言包 由 SoumaHoshino 提供 - http://moesora.com/
Language fr_FR: Stéphane Benoit. - http://www.gnosticisme.com
Language de_DE: Kniebremser - http://www.fluchtsportler.de
Language lv : Tulkotāji - http://trendfor.lv
Language pt_BR: Leonardo Kfoury - http://www.kfoury.com.br/site/
Language fa_IR: Morteza Amiri - http://www.GameSiders.com/
Language es_ES: Navone Juan - http://navonejuan.com.ar/
Language tr_TR: Hakan Er tarafından Türkçe Dili - http://hakanertr.wordpress.com/
Language id_ID: Nasrulhaq Muiz - http://al-badar.net/
Language sl_SI: Tomi Sambrailo - http://www.refuzed.it/
Language nb_NO: Simen Eggen - http://www.simeneggen.com
Language nl_NL: Mischa ter Smitten - http://blog.tersmitten.nl/
Language sk_SK: Patrik Žec (PATWIST) - http://patwist.com
Language lt_LT: Su pagarba Bronislav - http://www.internetiniusvetainiukurimas.com/
Language it_IT: Diego Belli
Language pl_PL: Kornel
Language ja : stranger-jp