• Resolved mjoly2000

    (@mjoly2000)


    Hello,

    After using your plugin, I can’t optimize or repair my database. Is this normal?

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author OllieJones

    (@olliejones)

    If you do what I think you do, yes it is normal.

    OPTIMIZE and REPAIR are legacy MySQL commands for the legacy MyISAM storage engine. If you used my plugin you probably upgraded your tables from MyISAM to InnoDB. InnoDB is far more robust about maintaining internal integrity than is MyISAM — it’s self-optimizing and self-repairing.

    The OPTIMIZE TABLE command does nothing on InnoDB tables. On my setup when I say OPTIMIZE TABLE wp_options (for example) I get this message:

    > Table does not support optimize, doing recreate + analyze instead

    The REPAIR TABLE doesn’t do anything either. It gives this message.

    > The storage engine for the table doesn’t support repair

    Please don’t hesitate to follow up if I have this wrong.

    Nice site by the way. Congratulations.

    Thread Starter mjoly2000

    (@mjoly2000)

    Thank you for your help. Your plugin is amazing, my website is very fast !

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘This database can not be repaired or optimized’ is closed to new replies.