How to Improve mysql insertion speed

How to Improve mysql insert speed 1. use the MyISAM type; 2. batch submit batch; 3. remove the index during insertion, and create an index after insertion. 4. the Uniqueness check of the storage engine is disabled; 5. turn off automatic transaction commit, and submit the transaction in batches; 6. use the insertdelayed method; 7. use loaddatainfile; 8. add key_buffer_siz

How to Improve mysql insert speed 1. use the MyISAM type; 2. batch submit batch; 3. remove the index during insertion, and create an index after insertion. 4. the Uniqueness check of the storage engine is disabled; 5. turn off automatic transaction commit, and submit the transaction in batches; 6. use the insert delayed method; 7. use load data infile; 8. add key_buffer_siz

How to Improve mysql insertion speed

1. Use the MyISAM type;

2. Submit batch in batches;

3. Remove the index during insertion, and create an index after insertion.

4. Disable the uniqueness check of the storage engine;

5. Automatic transaction submission and shutdown, and submit the transaction in batches;

6. Use the insert delayed method;

7. Use load data infile;

8. Increase the value of key_buffer_size to expand the key-high-speed buffer.