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
