1.myisam
alter table table_name disable keys loading data// insert alter table table_name enable keys
2.innodb
set unique_checks=0 //关闭唯一校验 set autocommit=1 //关闭自动提交