How to insert data into Mysql more quickly

1. SQL statement. insert is followed by 1000 values for one-time submission. 2. use the connection pool to keep the persistent connection inserted; 3. replace the storage engine of Mysql with Inforbright, convert the data into text, and import data in batches. there are no other better ways to use the queue to keep the maximum insert speed. Recently, there are GB of files to be stored for analysis every day, and we look forward to guiding the password.

[Code] [SQL] Code view source print?1LOAD DATA INFILE'F: \ a \ data.txt' IGNORE INTO TABLE Music. albumCHARACTER SETUtf8 FIELDS TERMINATEDBY ',' Lines terminatedBy '\ R \ N'(Album_id, album_name, singer_name, publish_time, song_count );