WP Database Optimizer

1295376053_kexi

Ever wish that you could take some measure to speed up your WordPress site? Have you created and deleted a lot of posts as well as experimented with plugins? All these deleted entries leave overhead on the database that should be routinely cleared out. This plugin allows you to have your WordPress tables to be optimized on a schedule. It uses the WordPress Database Class to do the work, and you can set the number of days in between optimizations.

To install this plugin download it here: http://wordpress.org/extend/plugins/wp-database-optimizer/

Then upload it to your plugins directory and activate it via the WP-Admin interface.

You will then have a new menu option under the Tools Menu where you can set the number of days in between optimizations. You can also view the last time the database was optimized.

28 Responses to “WP Database Optimizer”

  1. hpguru

    Thank you for this plugin.

    Just what i need… No i forgot manual database optimization.

    Have a nice day!

    Reply
  2. Matt Price

    I am glad you like it. Necessity breeds invention. I needed it…so i wrote it

    Reply
  4. Matt Price

    Hi Kat

    I have it running on my sites and they are 3.0.1

    I will update the readme file tonight to reflect that it is compatible with 3.0.1

    Thanks for the heads up!

    Reply
  5. derek

    Hi there,

    The wordpress plugin page says that the plugin is compatible up to 2.9.2, and it says “2 people say it’s broken” for 3.0.1.

    Can you confirm that the plugin works on 3.0.1??

    Maybe you want to update the wordpress plugin info page.

    Thanks a lot for your work.

    Reply
  6. Matt Price

    Hi Derek

    I have updated the Readme File to reflect 3.0.1

    The plugin is running on this site and i am running 3.0.1

    Matt

    Reply
  7. chris

    Download link seems to be broken at the moment,

    I had installed buddypress and the plugin that changes your theme to work with it, after deciding against using buddypress the screen now does a weird shift between what it used to look like to what it should look like, do you think your plugin will help?

    I did a re installation of the theme btw and that didn’t work.

    Thanks,

    Chris.

    Reply
    • Matt Price

      Hello

      So i have been having this issue a lot recently. if you click the download link button again, it works. I have a support email into wordpress to ask why this is happening.

      In response to your message, when i have uninstalled buddypress, i normally go to the Appearance menu and just make sure that the old theme is activated. What screen is it that does the weird shift? I don’t know if my plugin will do anything for you here, as it just checks the tables and optimizes them. it does not affect any options or settings.

      Matt

      Reply
  8. Linkes

    Hello,

    When I installed the WP Database Optimizer, Site Stats disappeared from the panel.

    thank

    Reply
    • Matt Price

      Hello

      So i have not tested this plugin with Site Stats. I can get around to it this weekend. until then, i would uninstall my plugin and i will get back to you soon.

      Thank you for the heads up

      Matt

      Reply
  9. Linkes

    Matt,

    Back to work. I was probably doing something wrong in relation to the Site Stats. Now this working together.

    Thanks

    Reply
  12. Cam

    When will this be 3.1.1 compatible? I look forward to using it on my sites when it is.

    Reply
    • admin

      Hi Cam

      I will update the readme file. It is completely compatible with 3.1.1

      I am running it on this site with no errors.

      Matt

      Reply
    • admin

      I have made the adjustment to the readme file. thanks for the heads up

      Matt

      Reply
      • Matthew Price

        Hi

        Glad you found it. Also, it will optimize any table that has the site prefix. ie. “wp_” which is the default

        Matt

        Reply
  14. Rafael

    Congratulations on the great work!
    Are you planning to make it compatible with wp 3.3?

    Reply
    • Matthew Price

      Hi Rafael

      I have just installed and tested it on a completely fresh install of 3.3 and it works as expected. I have updated the plugin in the WordPress repository to reflect it is comaptible up to 3.3. (i have been using it on my site since 3.3 came out with no issues too)

      Matt

      Reply
  15. avalanch

    In this ticket, it appears that the plugin WP Database Optimizer may have triggered the automated monitoring script when it issued 10 OPTIMIZE queries at once. This is totally unnecessary behaviour, and the queries themselves ended up writing several temporary tables in order to perform their work. It’s only necessary to run an OPTIMIZE on all of your tables once as another OPTIMIZE shortly afterwards would have any effect, if at all.

    Fix this please. Thanks.

    Reply
    • Matthew Price

      Hi

      I am a bit confused as to what you are referring. if for example you are in some kind of development mode adding and deleting posts all the time, this can create overhead. and even after regular use overhead can be accumulated. and my plugin only optimizes tables that need it. it skips over those that do not.

      I give the user the option to set the timeframe in between optimizations for the very reason you describe. feel free to set it to once every 30 days…that works, right?

      I hope this helps, as i do not think there is much to fix. if you can give me a bit more detail, i am all ears and willing to listen/learn.

      Matt

      Reply

Leave a Reply