WordPress.org

Ready to get started?Download WordPress

Plugin Directory

WP-Optimize

Simple but effective plugin allows you to extensively clean up your WordPress database and optimize it without doing manual queries.

Does WP-Optimize Supports InnoDB Format

InnoDB Table formats not supported. WP-Optimize will disable some features if it detects InnoDB table format. Optimization of the database will not work but other clean up features would work.

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 ).

Is there any bug in this plugin

The plugin is a development on the go - that means there are unforeseen situations and bugs. 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).

Every time I clear transient options, it comes back automatically

WordPress automatically creates transient options. It is pretty difficult to completely 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.8
  • Upgrade/Update your WP-Optimize plugin
  • Upgrade your PHP to at least 5.5.xx
  • Upgrade your MySql to at least MySql 5.1.xx

Table size shows wrong / Not optimizing

Please check your database for corrupted tables. That can happen, usually your web hosting company can run the repair command on the db.

Requires: 3.8 or higher
Compatible up to: 4.0.1
Last Updated: 2014-9-8
Downloads: 1,536,496

Ratings

4.8 out of 5 stars

Support

0 of 2 support threads in the last two months have been resolved.

Got something to say? Need help?

Compatibility

+
=
Not enough data

2 people say 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,1,1
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 100,1,1 100,1,1 100,1,1
80,5,4 67,3,2 100,5,5 86,7,6 100,2,2 100,1,1 100,6,6 83,6,5
100,20,20
100,3,3 100,10,10 100,2,2 100,1,1
100,2,2 100,4,4 96,23,22
100,8,8
100,18,18
100,2,2