Announcement

Collapse
No announcement yet.

Database Optimize Tables - Table does not support optimize

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Wayne Luke
    replied
    All optimize does is delete content marked for deletion. It provides no real optimization to make your database run faster overall or improve query results. The only time you should really run it is if you bulk delete a lot of content. It isn't something that we recommend running on a regular basis. In fact, in the past, running this has caused customers to damage their databases due to other issues.

    Leave a comment:


  • William Thomas Jr
    replied
    Please disregard, I found an informative article: http://www.laurencegellert.com/2011/...ith-mysql-5-1/

    Thanks Kevin,
    William
    Last edited by William Thomas Jr; Fri 16 Oct '15, 9:20am.

    Leave a comment:


  • Kevin Sours
    replied
    Optimize is a MyISAM concept and doesn't really apply to InnoDB tables. However there are some vaguely similar things you can do with InnoDB tables so the mysql optimize command does those instead when the table is InnoDB. This is perfectly normal if you are running InnoDB.

    Leave a comment:


  • Database Optimize Tables - Table does not support optimize

    Hi,

    When I try to optimize tables in the database I receive, "Note: Table does not support optimize, doing recreate + analyze instead". Is this normal? If not, is there a way to optimize the tables?

    Thanks,
    William
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X