mysql database import data speed:

1, the fastest of course, is to copy the database table data files directly (version and platform preferably to be the same or similar);

2, set innodb_flush_log_at_trx_commit = 0, as opposed to innodb_flush_log_at_trx_commit = 0, compared to innodb_flush_log_at_trx_commit = 1 can be very obvious to improve the speed of import;

3, use load data local infile to speed up the speed of the obvious;

4, change the parameter bulk_insert_buffer_size, adjusting the cache for large volume insertion;

5, merge multiple inserts into one: insert into t values(a,b,c), (d,e,f) ,,,,

6, manually use things;