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.