"Jon Hancock" <[EMAIL PROTECTED]> writes: > When you issue this "null" ALTER TABLE, is the entire table locked > during the build?
The table is read-only during the build. > i.e. Is the only way to defragment to effectively take the table > offline during the rebuild? Well. Not quite offline, but almost. > Is there a method to estimate time to do this rebuild? I usually go with "rows * 1/5000 seconds". But it varies with hardware and table complexity. My tables are not very complex. > 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] -- Per Andreas Buer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
