mysql load 速度_MySQL的load data命令性能小测试

以下环境为:

软件:

主机:winxp sp3

虚拟机软件:wmware ws 7.1

虚拟机系统:rhel5.1+MySQL5.157

主机硬件:

cpu:酷睿2 T8100

内存:3G

mysql> desc t;

+-----------------+---------------------+------+-----+---------+-------+

| Field           | Type                | Null | Key | Default | Extra |

+-----------------+---------------------+------+-----+---------+-------+

| TABLE_CATALOG   | varchar(512)        | YES  |     | NULL    |       |

| TABLE_SCHEMA    | varchar(64)         | NO   |     | NULL    |       |

| TABLE_NAME      | varchar(64)         | NO   |     | NULL    |       |

| TABLE_TYPE      | varchar(64)         | NO   |     | NULL    |       |

| ENGINE          | varchar(64)         | YES  |     | NULL    |       |

| VERSION         | bigint(21) unsigned | YES  |     |