Home / server / Questions / 125515
In Process
Dscoduc
Asked: 2010-03-24 12:51:35 +0800 CST

MySQL Table does not support optimize

  • 772

My Wordpress tables appear to be in need of optimization so I looked into the commmand OPTIMIZE TABLE . When I run the command I get the following results:

Table does not support optimize, doing recreate + analyze instead

The tables are built using the Wordpress 2.91 installer and haven't been modified at all.

  1. Is this normal?
  2. How can I optimize my database to keep things working correctly?
mysql wordpress

4 Answers

  1. Have you found the MySQL documentation? It's extensive and useful.

    When you run OPTIMIZE TABLE against InnoDB tables it outputs the Table does not support optimize, doing recreate + analyze instead message.

    From the documentation:

    OPTIMIZE TABLE is mapped to ALTER TABLE, which rebuilds the table to update index statistics and free unused space in the clustered index.

    MySQL 5.1 OPTIMIZE TABLE syntax

    • 5

  2. You can optimize an InnoDB table by doing 

    ALTER TABLE tablename ENGINE='InnoDB';

    This will create a copy of the original table drop the original table and put the new table in it's place.

    There is some additional information here which includes things you should be aware of.

    Also in the MySQL Documentation. See the comment by Dathan Pattishall on May 25 2004 4:41pm about half way down the page.

    Although this should be safe to do you should make and test a backup first.

    • 5

  3. it is possible

    use a wp database plugin like http://wordpress.org/extend/plugins/wp-dbmanager/

    & activate the plugin

    & go to the page & click on optimize database it will optimize your database

    No need of entering any sql logins. It fetches from wp-config.php

    • 2

  4. OPTIMIZE does work for InnoDB. At least it does now. This is 5.6 documentation:

    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.

    Read : Optimize Table

    • 2