When you issue this "null" ALTER TABLE, is the entire table locked during the build? i.e. Is the only way to defragment to effectively take the table offline during the rebuild? Is there a method to estimate time to do this rebuild? thanks, Jon
----- Original Message ----- From: "Per Andreas Buer" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, September 19, 2003 6:17 PM Subject: Re: innodb and fragmentation > Hello Heikki, > > "Heikki Tuuri" <[EMAIL PROTECTED]> writes: > > > I think a 'null' alter table operation: > > > > ALTER TABLE innodbtable TYPE=INNODB; > > > > does the defragmentation with just one build of the table. And I think it > > also preserves FOREIGN KEY constraints. > > > > Please test it! > > It did the job just fine. Thanks. > > -- > Per Andreas Buer > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
