This simple but effective plugin allows you to clean up your WordPress database and optimize it without phpMyAdmin.
WP-Optimize is a WordPress 3.xx database cleanup and optimization tool. It doesn't require PhpMyAdmin to optimize your database tables.
It allows you to remove post revisions, comments in the spam queue, un-approved comments, items in trash within few clicks.
Simple scheduler introduced (Still in very EXPERIMENTAL stage)
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. This is a must for everyone
Are you interested to be a contributed developer of this plugin, use the contact form link below to contact me.
You will be credited inside the plugin screen and the plugin listing at WordPress.
PHP 4.xx and MySql 4.xx not supported
Translators are welcome to send their Translated Files to be included.
See options inside plugin or contact me via http://www.ruhanirabin.com/contact/
Or 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: Rewolve44 - http://www.myfotohome.at/
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/
[NEW] Option to add or remove link on wp admin bar.
[NEW] New admin interface.
[NEW] Removal of WordPress transient options.
[NEW] Removal of orphaned post meta data.
[REMOVED] Removal of unused tags.
[NEW] 3 different schedule times added (weekly, bi-weekly and monthly).
[NEW] Retain/Keep last X number of weeks data - this option keeps the last selected number of weeks data when cleaning up.
[NEW] Remove all trackbacks and pingbacks (can significantly reduce db size)
[NEW] Clear Trash Comments and Posts (This will also follow the "Keep X number of weeks data" option if it was selected)
[NEW] Enable/Disable weekly schedules of optimization (This will also follow the "Keep X number of weeks data" option if it was selected) Note: This is an EXPERIMENTAL feature. It may or may not work on all servers.
[NEW] Remove the WordPress post revisions (This will also follow the "Keep X number of weeks data" option if it was selected)
[NEW] Remove the WordPress auto draft posts (This will also follow the "Keep X number of weeks data" option if it was selected)
[NEW] Remove all the comments in the spam queue (This will also follow the "Keep X number of weeks data" option if it was selected)
[NEW] Remove all the un-approved comments (This will also follow the "Keep X number of weeks data" option if it was selected)
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.
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 "Keep X number of weeks data" option.
Requires: 3.7 or higher
Compatible up to: 3.9
Last Updated: 2013-11-21
34 of 35 support threads in the last two months have been resolved.
Got something to say? Need help?