load data infile效率测试

测试用例40w条记录 插入到mysql5.0.95库中
1.远程客户端文件方式，用时23.42sec
注意登录时指定--local-infile
belinda@ubuntu:~$ mysql --local-infile -h 192.168.195.1 -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.96-community-nt MySQL Community Edition (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use temp
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> load data local infile '/home/belinda/work/datagen41.txt' ignore into table t_lable_group454 fields terminated by ',' enclosed by '"' lines terminated by '\r\n';
Query OK, 400000 rows affected, 65535 warnings (23.42 sec)
Records: 400000 Deleted: 0 Skipped: 0 Warnings: 256487
2.本地文件方式

C:\Users\linda>mysql --local-infile -h 192.168.195.1 -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.0.96-community-nt MySQL Community Edition (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use temp;
Database changed
mysql> load data infile 'E:/datagen41.txt' ignore into table t_lable_group454 fi
elds terminated by ',' enclosed by '"' lines terminated by '\r\n';
Query OK, 400000 rows affected, 65535 warnings (30.21 sec)
Records: 400000 Deleted: 0 Skipped: 0 Warnings: 256487