Three methods to modify the Database Engine

Three ways to modify the Database Engine 1. directly alter tableSql code alter table youTable ENGINE = InnoDB; this method is the easiest, but it takes a long time for Big Data Tables, because MySQL needs to perform row-by-row replication from the old TABLE to the new TABLE. MySQL locks the entire table regardless of the engine used to operate the alter table operation. Www.2cto.com 2. Use dump and source to first dump the desired TABLE, then modify the dump file, remove drop table, modify the create table code, and execute source. In this way, the engine cannot be modified online, and the database must be deprecated or synchronized after being modified online. 3. use the create and SELECTSql code create table myTableCopy LIKE myTable; alter table myTableCopy ENGINE = InnoDB; insert into myTableCopy SELECT * FROM myTable WHERE id BETWEEN x AND y; in this way, when the table data volume is large, you can import data in batches according to the range without locking myTable.