it will lock the table,read and write are blocked during the process. -----原始邮件----- 发件人: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] 发送时间: 2007年11月19日 15:24 收件人: MySql 主题: Alter table
Hi Everybody, I would like to know that, while changing storage engine from one type to another locks that table or not. alter table <table-name> engine=myisam; alter table <table-name> engine=innodb; During the process of changing storage engine from one type to another. Whether it will work fine for an online system. Thanks, -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt. Ltd, 201,202, Ashoka Bhoopal Chambers, S P Road, Secunderabad 500003. Ph. No. - 040-39188771 Url: www.ed-ventures-online.com
