WordPress.org

Ready to get started?Download WordPress

Plugin Directory

WP-Optimize

This simple but effective plugin allows you to clean up your WordPress database and optimize it without phpMyAdmin.

Can you help me restore my database?

No I can't. Please make a backup of your entire database before using this Plugin for the first time. Also backup your database when you upgrade to a MAJOR NEW version (for example - v0.9.8 to 1.5.5 ).

Everytime I clear transient options, it comes back automatically

WordPress automatically creates transient options. It is pretty difficult to completley get rid of it. This is why everytime you clean transient options, you will notice new transient options has been created. My best advice would be clear the transient options on a schedule. So, for example it may create 50 transient option in a week and you clear it weekly so the next 50 transient option comes in. Rather than having 100 transient option, you will have 50 per week.

Optimization does not have any effect on database / it is not optimizing the database

Some of the shared web hosting company does not allow scripts to run OPTIMIZE command via SQL statements. If you are hosted with these web hosts, the optimize action will not be able to optimize your database. Please consult your web hosting company regarding this matter.

I am having error - Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource ...

  • Upgrade/Update your WordPress to at least 3.5

  • Upgrade/Update your WP-Optimize plugin

  • Upgrade your PHP to at least 5.1.xx

  • Upgrade your MySql to at least MySql 5.1.xx

  • Remember: PHP 4.xx and MySql 4.xx not supported

Is there any bug in this plugin

This is a very primary version of the plugin. So I would recommend you to test it out on your local system or make a backup of your database (just to be extra careful).

Requires: 3.7 or higher
Compatible up to: 3.8.3
Last Updated: 2014-4-2
Downloads: 882,505

Ratings

4 stars
4.6 out of 5 stars

Support

5 of 11 support threads in the last two months have been resolved.

Got something to say? Need help?

Compatibility

+
=
Not enough data

1 person says it works.
0 people say it's broken.

100,1,1 100,2,2
100,2,2 100,2,2 100,2,2
100,1,1 100,5,5 50,2,1
100,1,1 100,5,5 0,1,0
100,3,3 92,13,12
93,14,13
80,10,8
92,13,12
100,1,1
80,5,4
67,3,2
50,2,1 100,1,1
100,3,3 86,7,6 100,13,13 100,1,1
88,8,7
100,3,3
100,7,7 100,1,1
100,1,1
75,4,3
96,23,22 100,1,1
100,4,4 100,1,1 100,9,9
100,20,20
100,15,15
91,11,10
100,22,22
100,19,19
100,19,19
88,25,22
100,3,3
100,2,2
100,8,8 100,2,2 100,1,1 100,6,6 100,1,1
100,2,2 100,4,4 100,1,1 100,1,1
50,2,1 100,2,2 100,6,6 50,4,2 100,2,2 100,9,9 100,10,10 100,8,8
89,9,8 100,1,1 100,8,8
100,18,18 100,2,2
100,1,1
100,1,1
100,1,1