Skip to content

Instantly share code, notes, and snippets.

@Veve2

Veve2/fastload.sql

Last active October 24, 2022 09:36
Show Gist options
  • Save Veve2/2df6f8edf4e4b771fa2acbe863fb389a to your computer and use it in GitHub Desktop.
Save Veve2/2df6f8edf4e4b771fa2acbe863fb389a to your computer and use it in GitHub Desktop.
Download ZIP
Fast LOAD DATA INFILE with MySQL
Raw
fastload.sql
SET FOREIGN_KEY_CHECKS = 0;
SET UNIQUE_CHECKS = 0;
SET SESSION tx_isolation='READ-UNCOMMITTED';
SET sql_log_bin = 0;
#LOAD DATA LOCAL INFILE....
SET UNIQUE_CHECKS = 1;
SET FOREIGN_KEY_CHECKS = 1;
SET SESSION tx_isolation='READ-REPEATABLE';
@Veve2
Copy link
Author

Veve2 commented Jan 5, 2017

From http://stackoverflow.com/a/39251799/4074148

@Veve2
Copy link
Author

Veve2 commented Jan 5, 2017

Additional infos : http://derwiki.tumblr.com/post/24490758395/loading-half-a-billion-rows-into-mysql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment