Re: mysqlimport get very slow for large files
Posted by:
Jun Zhang
Date: August 07, 2012 10:21AM
The size of the three files .frm, .MYD and .MYI doesn't change for an hour now, I guess indexes are being built. This is not home designed database, users requested it to be installed to speed up their statistical calcuations. The only concern is the performance after the database is installed, so indexes are important.
| 6 | root | localhost | homo_sapiens_variation_67_37 | Query | 8380 | Repair with keycache | LOAD DATA LOCAL INFILE '/extraspace/zhangj/homo_sapiens_variation_67_37/allele.txt' INTO TABLE `all |
I feel there is nothing much changed due to the few variables' change, except tomorrow morning I get the prompt back.
At this time, SELECT will not come back with result, or I didn't wait long enough for it.
Subject
Views
Written By
Posted
6325
August 03, 2012 09:44AM
4251
August 03, 2012 11:04AM
2315
August 03, 2012 03:06PM
1992
August 04, 2012 04:35AM
2004
August 07, 2012 08:12AM
1644
August 07, 2012 08:39AM
Re: mysqlimport get very slow for large files
2092
August 07, 2012 10:21AM
1578
August 05, 2012 08:58AM
1462
August 07, 2012 11:07AM
1878
August 08, 2012 08:34AM
1345
August 08, 2012 04:19PM
2989
August 09, 2012 04:15AM
1662
August 09, 2012 07:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.