I often noticed that people complain about the LOAD DATA performance when loading the table with large number of rows of data. Even today I saw a case where the LOAD DATA on a simple 3 column table with about 5 million rows taking ~15 minutes of time. This is because the server did not had any tuning in regards to bulk insertion.
Consider the following simple MyISAM table on Redhat Linux 32-bit.
| [Copy to clipboard][-]View Code | |
1 2 3 4 5 6 |
CREATE TABLE load1 ( `col1` varchar(100) NOT NULL DEFAULT '', `col2` int(11) DEFAULT NULL, `col3` char(1) DEFAULT NULL, PRIMARY KEY (`col1`) ) TYPE=MyISAM; |
The table has a string key column. Here is the data file( …
[Read more]