Hi
Recently we performed an 'alter table' on a dev box to change from
myisam to innodb, and it resulted in considerable speed improvement. in
the lab setting.
Unfortunately when we repeated on the live server, whilst we got a 200%
performance boost (estimate) again, we failed to notice that
In article [EMAIL PROTECTED],
James Green [EMAIL PROTECTED] writes:
Unfortunately when we repeated on the live server, whilst we got a
200% performance boost (estimate) again, we failed to notice that
innodb is in DISABLED state, and yet alter table returned ok.
It's one of the ugliest
You can determine table type with
SHOW CREATE TABLE table_name
or
SHOW TABLE STATUS LIKE 'table_name';
From the manual http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html, If
a storage engine is specified that is not available, MySQL uses MyISAM
instead. That applies to ALTER as well as to