Table does not support optimize

  • Resolved aian

    (@aian)


    10 years, 9 months ago

    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://www.ads-software.com/plugins/rvg-optimize-database/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Contributor cageehv

    (@cageehv)

    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

    (@aian)

    Wow, that was lightning fast, thanks Rolf!

    Is there a safe and easy way to do the change to MyISAM?

    Plugin Contributor cageehv

    (@cageehv)

    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

    (@aian)

    As I’m feeling a bit worried about this, would it be ok if I left the tables as they are?

    Plugin Contributor cageehv

    (@cageehv)

    Hey Aian,

    Will be totally okay!
    They just will be optimized in a different way, that’s all.

    Rolf

    Thread Starter aian

    (@aian)

    Thank you Rolf, you have been extremely helpful

    Best

    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?

    can you not just drop the table in myphp

    Plugin Contributor cageehv

    (@cageehv)

    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.