mysql 过亿行数据导入

windows下

LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/UserBehavior.csv' 
INTO TABLE tianchi
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\n' 
IGNORE 1 ROWS;

注意：直接在MySQL的客户端运行查询会报延时故障。

Linux下

LOAD DATA INFILE '/xx.csv' 
INTO TABLE wori
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\n' 
IGNORE 1 ROWS;

注意：更改了my.cnf内的配置项，将限制路径取消
又因为放在/tmp/路径下始终存在error13，所以放在根目录下。