ä¸é¢ä¸äºæ¹æ³å¯ä»¥å å¿«
mysqlæ°æ®åºå¯¼å
¥æ°æ®çé度ï¼
1ãæå¿«çå½ç¶æ¯ç´æ¥ copy æ°æ®åºè¡¨çæ°æ®æ件ï¼çæ¬åå¹³å°æ好è¦ç¸åæç¸ä¼¼ï¼ï¼
2ã 设置 innodb_flush_log_at_trx_commit = 0 ï¼ç¸å¯¹äº innodb_flush_log_at_trx_commit = 1 å¯ä»¥ååææ¾çæå导å
¥é度ï¼
3ã ä½¿ç¨ load data local infile æéææ¾ï¼
4ã ä¿®æ¹åæ° bulk_insert_buffer_sizeï¼ è°å¤§æ¹éæå
¥çç¼åï¼
5ã å并å¤æ¡ insert 为ä¸æ¡: insert into t values(a,b,c), (d,e,f) ,,,
6ãæå¨ä½¿ç¨äºç©ï¼
温馨提示:答案为网友推荐,仅供参考