Mysql InnoDB + MyIsam bulk insert statements

mysql-innodb-bulk-inserts.sql

LOCK TABLES `table_name` WRITE;
SET autocommit=0;
SET foreign_key_checks=0;
SET unique_checks=0;


/*....
INSERT ... ON DUPLICATE KEY UPDATE
INSERT IGNORE INTO 
....*/


SET unique_checks=1;
SET foreign_key_checks=1;
COMMIT;
SET autocommit=1;
UNLOCK TABLES;

mysql-myisam-bulk-inserts.sql

LOCK TABLES `table_name` WRITE;
/*!40000 ALTER TABLE `table_name` DISABLE KEYS */;


/*....
INSERT INTO ... ON DUPLICATE KEY UPDATE
INSERT IGNORE INTO 
....*/


/*!40000 ALTER TABLE `table_name` ENABLE KEYS */;
UNLOCK TABLES;