Dreamer，Dreaming

MySQL的Load Data Infile速度还可以- -

在我这个破机器上导入了245万记录（约500M），不到两分钟，还可以接受，下面是执行结果：
mysql> load data infile "data_1.txt" into table data_1 fields terminated by "," enclosed by '"';
Query OK, 393299 rows affected (12.27 sec)
Records: 393299  Deleted: 0  Skipped: 0  Warnings: 16638
mysql> load data infile "data_2.txt" into table data_1 fields terminated by "," enclosed by '"';
Query OK, 962620 rows affected (30.47 sec)
Records: 962620  Deleted: 0  Skipped: 0  Warnings: 17636
mysql> load data infile "data_3.txt" into table data_1 fields terminated by "," enclosed by '"';
Query OK, 1003226 rows affected (34.89 sec)
Records: 1003226  Deleted: 0  Skipped: 0  Warnings: 16926
mysql> load data infile "data_4.txt" into table data_1 fields terminated by "," enclosed by '"';
Query OK, 93305 rows affected (3.28 sec)
Records: 93305  Deleted: 0  Skipped: 0  Warnings: 123
补记：
昨晚为了给这个表加上一个PK，用了select into，执行速度也还行：
mysql> INSERT INTO test ( Date,Time,Code,StrikePrice,Expiry,Type,Price,Volume,Va
lue,Buyer,Seller,Conditions,Underlying,StockPrice,ImpVolDFS,ImpVolCBA,AorE,Inter
estRate,Moneyness,Delta,DTM ) select * from data_1 order by date,time;
Query OK, 2452450 rows affected (10 min 5.55 sec)
Records: 2452450  Duplicates: 0  Warnings: 0
执行完毕，数据表文件的大小有876M，缩减了几个CHAR列的宽度，现在数据表文件大小是337M。

- 作者： 覃健祥 2005年04月6日, 星期三 21:20 加入博采