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 misfeatures of MySQL that it doesn't always complain loudly, but instead tries to silently do what it thinks is right. > We therefore conclude that the alter table command failed siliently > (really bad bug that), however we cannot explain the performance > boost. Probably the ALTER TABLE got silently changed to OPTIMIZE TABLE. > Clearly before shutting anything down or fixing things, we would like > to know if these tables are safely still myisam. Yes. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
