Skip to content

Instantly share code, notes, and snippets.

@lgaa

lgaa/mysql-innodb-bulk-inserts.sql

Forked from kbsali/mysql-innodb-bulk-inserts.sql
Created August 23, 2017 15:09
Show Gist options
  • Save lgaa/f73f8982ccd5f87bc8e40c09a53cc64b to your computer and use it in GitHub Desktop.
Save lgaa/f73f8982ccd5f87bc8e40c09a53cc64b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @kbsali kbsali revised this gist Nov 22, 2013. 2 changed files with 4 additions and 4 deletions.
    2 changes: 1 addition & 1 deletion mysql-innodb-bulk-inserts.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    LOCK TABLES `locations` WRITE;
    LOCK TABLES `table_name` WRITE;
    SET autocommit=0;
    SET foreign_key_checks=0;
    SET unique_checks=0;
    6 changes: 3 additions & 3 deletions mysql-myisam-bulk-inserts.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,5 @@
    LOCK TABLES `locations` WRITE;
    /*!40000 ALTER TABLE `locations` DISABLE KEYS */;
    LOCK TABLES `table_name` WRITE;
    /*!40000 ALTER TABLE `table_name` DISABLE KEYS */;


    /*....
    @@ -8,5 +8,5 @@ INSERT IGNORE INTO
    ....*/


    /*!40000 ALTER TABLE `locations` ENABLE KEYS */;
    /*!40000 ALTER TABLE `table_name` ENABLE KEYS */;
    UNLOCK TABLES;
  2. @kbsali kbsali revised this gist Nov 22, 2013. 2 changed files with 14 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions mysql-innodb-bulk-inserts.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -4,10 +4,10 @@ SET foreign_key_checks=0;
    SET unique_checks=0;


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


    SET unique_checks=1;
    12 changes: 12 additions & 0 deletions mysql-myisam-bulk-inserts.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,12 @@
    LOCK TABLES `locations` WRITE;
    /*!40000 ALTER TABLE `locations` DISABLE KEYS */;


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


    /*!40000 ALTER TABLE `locations` ENABLE KEYS */;
    UNLOCK TABLES;
  3. @kbsali kbsali created this gist Nov 22, 2013.
    17 changes: 17 additions & 0 deletions mysql-innodb-bulk-inserts.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,17 @@
    LOCK TABLES `locations` 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;