Question: 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?

Answer: 
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](http://mysqldump.azundris.com/archives/76-An-InnoDB-tutorial.html) which includes things you should be aware of. 

Also [in the MySQL Documentation](http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html). 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.
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