Table does not support optimize

  • Resolved aian

    (@aian)


    9 years, 10 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://wordpress.org/plugins/rvg-optimize-database/

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

    (@cageehv)

    9 years, 10 months ago

    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)

    9 years, 10 months ago

    Wow, that was lightning fast, thanks Rolf!

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

    Plugin Contributor cageehv

    (@cageehv)

    9 years, 10 months ago

    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)

    9 years, 10 months ago

    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)

    9 years, 10 months ago

    Hey Aian,

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

    Rolf

    Thread Starter aian

    (@aian)

    9 years, 10 months ago

    Thank you Rolf, you have been extremely helpful

    Best

    Shapeshifter 3

    (@shapeshifter-3)

    9 years, 6 months ago

    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

    (@mrppp)

    9 years, 5 months ago

    can you not just drop the table in myphp

    Plugin Contributor cageehv

    (@cageehv)

    9 years, 5 months ago

    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.