要学会使用语音记… >>
<< Eclipse "Help Conte…
Converting MyISA…

Author Zhou Renjian Create@ 2004-02-16 20:55
whizz Note icon
Converting MyISAM Tables to InnoDB

InnoDB does not have a special optimization for separate index creation. Therefore it does not pay to export and import the table and create indexes afterwards. The fastest way to alter a table to InnoDB is to do the inserts directly to an InnoDB table, that is, use ALTER TABLE ... TYPE=INNODB, or create an empty InnoDB table with identical definitions and insert the rows with INSERT INTO ... SELECT * FROM ....

To get better control over the insertion process, it may be good to insert big tables in pieces:

INSERT INTO newtable SELECT * FROM oldtable
本记录所在类别:
本记录相关记录: