1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 table optimize

Discussion in 'Troubleshooting and Problems' started by Lexy, Aug 1, 2014.

  1. Lexy

    Lexy Active Member

    when try optimize xenforo database table gives me this Table does not support optimize, doing recreate +
    The storage engine for the table doesn't support repair
     
  2. Lexy

    Lexy Active Member

    it is command for optimize table ALTER TABLE yourtablename ENGINE='InnoDB';
     
  3. Brogan

    Brogan XenForo Moderator Staff Member

    What are you trying to do?

    You shouldn't be changing the table engine from the default.
     
  4. Lexy

    Lexy Active Member

    try to optimize table
     
  5. Lexy

    Lexy Active Member

    i try optimize it over myadminphp but INNO database gives me this Table does not support optimize, doing recreate +
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    Why?

    If you don't know what you are doing, my advice is to leave well alone.
     
  7. Lexy

    Lexy Active Member

    ok thanks
     
  8. MattW

    MattW Well-Known Member

    Optimize table doesn't work the same on an InnoDB table as a MyISAM

    Code:
    For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE, which rebuilds the table to update index statistics and free unused space in the clustered index. Beginning with MySQL 5.1.27, this is displayed in the output of OPTIMIZE TABLE when you run it on an InnoDB table, as shown here:
    
    mysql> OPTIMIZE TABLE foo;
    +----------+----------+----------+-------------------------------------------------------------------+
    | Table    | Op       | Msg_type | Msg_text                                                          |
    +----------+----------+----------+-------------------------------------------------------------------+
    | test.foo | optimize | note     | Table does not support optimize, doing recreate + analyze instead |
    | test.foo | optimize | status   | OK                                                                |
    +----------+----------+----------+-------------------------------------------------------------------+
     
    Lexy likes this.

Share This Page