Title: Table does not support optimize
Last modified: August 21, 2016

---

# Table does not support optimize

 *  Resolved [aian](https://wordpress.org/support/users/aian/)
 * (@aian)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/)
 * Hello
 * Running the last version of the plugin (2.7.9) under WP 3.91.
    I recently moved
   the website to a new server (tables, db and settings) and now every time I try
   to run the optimisation, I get the message:
 * “Table does not support optimize, doing recreate + analyze instead”
 * showing next to every table.
 * Can you please explain why the tables don’t support optimisation please?
 * [https://wordpress.org/plugins/rvg-optimize-database/](https://wordpress.org/plugins/rvg-optimize-database/)

Viewing 9 replies - 1 through 9 (of 9 total)

 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/#post-4990339)
 * Hey Aian,
 * Just change your table types to **MyISAM**.
    That will fix it.
 * (Also it’s not really a problem: tables will be uptimized anyways, even if they
   are not MyISAM, it will use a different method)
 * peace,
    Rolf
 *  Thread Starter [aian](https://wordpress.org/support/users/aian/)
 * (@aian)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/#post-4990340)
 * Wow, that was lightning fast, thanks Rolf!
 * Is there a safe and easy way to do the change to MyISAM?
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/#post-4990341)
 * Hey Aian,
 * I normally do it using PHPMyAdmin (one by one).
 * I don’t think it will allow you to change all tabels with one click…
 * You could write a SQL script to do the job, I guess.
 * Good luck!
    Rolf
 *  Thread Starter [aian](https://wordpress.org/support/users/aian/)
 * (@aian)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/#post-4990342)
 * As I’m feeling a bit worried about this, would it be ok if I left the tables 
   as they are?
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/#post-4990344)
 * Hey Aian,
 * Will be totally okay!
    They just will be optimized in a different way, that’s
   all.
 * Rolf
 *  Thread Starter [aian](https://wordpress.org/support/users/aian/)
 * (@aian)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/#post-4990345)
 * Thank you Rolf, you have been extremely helpful
 * Best
 *  [Shapeshifter 3](https://wordpress.org/support/users/shapeshifter-3/)
 * (@shapeshifter-3)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/#post-4990672)
 * I have another question:
    When I DISABLE & DELETE OTHER PLUGINS that don’t support
   this optimizer, remnants of those plugins (tables) are recreated & maintained
   by this optimizer. I can’t get rid of those remnants and this plugin keeps recreating
   them. The current version of BuddyPress is a major example of this.
 * Any suggestions on how to deal with this?
    Can you add an option in THIS plugin
   to delete remnants of other plugins?
 *  [mrppp](https://wordpress.org/support/users/mrppp/)
 * (@mrppp)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/#post-4990675)
 * can you not just drop the table in myphp
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/#post-4990676)
 * No, mostly it’s about records in a WP table (like wp-options)…
    So you need to
   know the name of the keys per plugin.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Table does not support optimize’ is closed to new replies.

 * ![](https://ps.w.org/rvg-optimize-database/assets/icon-256x256.png?rev=3350597)
 * [Optimize Database after Deleting Revisions](https://wordpress.org/plugins/rvg-optimize-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/rvg-optimize-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/rvg-optimize-database/)
 * [Active Topics](https://wordpress.org/support/plugin/rvg-optimize-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/rvg-optimize-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/rvg-optimize-database/reviews/)

 * 9 replies
 * 4 participants
 * Last reply from: [cageehv](https://wordpress.org/support/users/cageehv/)
 * Last activity: [11 years, 5 months ago](https://wordpress.org/support/topic/table-does-not-support-optimize/#post-4990676)
 * Status: resolved