Mysql匯入大表檔案時注意修改引數

Mysql匯入大表檔案時注意修改引數

---

set global max_allowed_packet=100000000; 
set global net_buffer_length=100000; 
SET GLOBAL interactive_timeout=28800000;
SET GLOBAL wait_timeout=28800000;




SET GLOBAL myisam_max_sort_file_size=268435456000;
SET GLOBAL global  myisam_sort_buffer_size=134217728;