|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
"Load Data Infile ... Repair with KeyCache" --WAY SLOW!
From: mos (mos99
fastmail.fm)
Date: Wed Mar 02 2005 - 10:01:05 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I have a 50g CSV file that I am trying to import into an empty MyISAM
table. It appears to go fine except after 10 hours it hasn't completed. A
"Show Process List" shows Info="load data infile ..." and State="Repair
with keycache". The table has a few hundred million rows of data. I assume
it is using "Repair with keycache" to rebuild the indexes after the data
has been loaded.
From what I've read "Repair with keycache" is going to take a huge amount
of time to complete. How do I disable "Repair with keycache" and use
"Repair with sort" instead (which should be faster, right?)? I'm using
MySQL 4.1.10 on Win XP and 1gb ram.
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]