Hi All,
I have used MySQL 5.1.29 and I would like to ask a question related to InnoDB
and row_format=COMPACT and OPTIMIZE
Why when trying to run OPTMIZE on InnoDB table with row_format=compact
it displays "Table does not support optimize, doing recreate + analyze instead"
?
+----------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+----------------------+----------+----------+-------------------------------------------------------------------+
| table1 | optimize | note | Table does not support optimize, doing
recreate + analyze instead |
| table1 | optimize | status | OK
|
+----------------------+----------+----------+-------------------------------------------------------------------+
Thanks for your help,
Mariella
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
