WordPress.org

Plugin Directory

Test out the new Plugin Directory and let us know what you think.

WP-Optimize

WP-Optimize is WordPress's most-installed optimization plugin. With it, you can clean up your database easily and safely, without manual queries.

Is optimizing my database safe?

Yes; optimizing does not involve any "tricks" or poking around in dangerous ways. It involves running routine clean-up operations using well-defined, common MySQL commands. Nevertheless, we always recommend backups, which cover every possibility; not just database malfunctions, but hackers, human errors, etc. We recommend UpdraftPlus.

What savings can I expect to make?

This is a "how long is string?" sort of question. It depends completely on your site - how big it is, how many users interact on it, how long it has been running, and when you last optimised it. However, the savings and speed-ups can be substantial; it is always worth making sure that your database is optimized.

How do I get support?

In our support forum, here: https://wordpress.org/support/plugin/wp-optimize/

WP-Optimize does not make large savings on my database

This is rare; it’s probably because you’re with a shared web hosting company that doesn’t allow scripts to run an optimize command via SQL statements (SQL "OPTIMIZE" instruction). Please consult your web hosting company on this matter.

Is the plugin tried and tested?

Yes - WP-Optimize is WordPress's #1 most-installed optimization plugin, with over 500,000 users and a pedigree going back over 7 years.

Does WP-Optimize support InnoDB tables?

WP-Optimize will disable some features if it detects InnoDB tables. Optimization of the database tables on-disk is not available, but other clean up features would work.

Can you help me restore my database?

I'm afraid that this is not possible. Please ensure that you make a backup of your entire database before using WP-Optimize for the first time, and when you upgrade to a major new version of it. We recommend UpdraftPlus.

Are there any bugs in this plugin?

The plugin is an ongoing work; that means that it is impossible to rule out 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).

How do I stop transient options from coming back automatically each time I clear them?

When WordPress uses a particular transient, that specific transient is re-created automatically. So, it's normaly for ones which are in active use to gradually re-appear. The best way to keep things optimal is to clear the transient options on a scheduled basis. For example, WordPress may create 50 transient option in a week. If you schedule WP-Optimize to clear these options on a weekly basis, you’ll have far fewer building up.

The 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.7.3
Last Updated: 3 weeks ago
Active Installs: 500,000+

Ratings

4.9 out of 5 stars

Support

4 of 14 support threads in the last two months have been marked 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,14,14 100,3,3 100,9,9
100,3,3
100,2,2
100,7,7
100,3,3
100,1,1
88,8,7
100,11,11
75,4,3
100,8,8
89,9,8
100,3,3
100,1,1
100,4,4 100,4,4
100,10,10
100,3,3
100,12,12 100,4,4 100,1,1
100,2,2 100,9,9 100,6,6 100,1,1
100,3,3 100,1,1
100,4,4 100,8,8
100,2,2