MyISAM和InnoDB批量插入1万数据速度比较

创建测试表

CREATE TABLE testBinlog(id int PRIMARY KEY auto_increment ,name CHAR(16));//MySQL默认存储引擎为InnoDB

CREATE TABLE testMyISAM(id int PRIMARY KEY AUTO_INCREMENT, name CHAR(16))ENGINE = MyISAM;
CREATE TABLE testBinlog(id int PRIMARY