myisam: alter table tbl_name disable keys; loading the data alter table tbl_name enable keys; innodb: set unique_checks=0 关闭唯一性校验 set autocommit=0 关闭自动提交