Mysql efficient method of data guide to explain _mysql

Data: A db,2000 table, 2000 Tabular data, 30 column per record, and an average of 4.3w records per sheet, totalling 86,388,670 records.

Machine: Linux 64bit 8G memory 4 core Intelx3320@2.5ghz

Basic ideas:

Copy Code code as follows:

Mysql-utest-pxxxx-s-E "source Xxxx.sql"

Put the LOAD statement in the Xxxx.sql

Load Syntax:

Copy Code code as follows:

Load data [low_priority] [local] infile ' file_name.txt ' [replace | ignore]

If the serial import data is slow, consider parallelism, but there may be a conflict, workaround:

Empty table before load

Copy Code code as follows:

TRUNCATE table xxxx or delete from table xxxx;

Or use the Replace or ignore keyword.