I was able to speed it up somewhat by increasing the Key_buffer_size to
512M and its down to 4 hours to load 30 million rows. Still I find that's
pretty slow. Is there anything else I can do to speed it up? TIA
Mike
At 10:50 PM 7/28/2006, mos wrote:
I ran a file monitor and it appears MySQL ha
solved soon, I may have to abandon MySQL and use
another database. :(
Mike
- Original Message - From: "mos" <[EMAIL PROTECTED]>
To:
Sent: Saturday, July 29, 2006 4:50 AM
Subject: Re: Way too slow Load Data Infile
I ran a file monitor and it appears MySQL has been
Hi Mike,
Try the following:
ALTER TABLE tblname DISABLE KEYS;
LOAD DATA INFILE ...
ALTER TABLE tblname ENABLE KEYS;
hth, Cor
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
To:
Sent: Saturday, July 29, 2006 4:50 AM
Subject: Re: Way too slow Load Data Infil
I ran a file monitor and it appears MySQL has been updating the table's
index for the past several hours as part of the Load Data Infile process.
Is there any way to speed this up? I'm using MySIAM tables in v4.1.10. Here
are the settings I'm using. Is there anything in there that will speed up
I executed a "Load Data Infile" 24 hours ago and its still running. Yikes!
I have 6 of these tables to load and at this rate it will take forever. Can
someone please run through my Status variables and let me know if there is
a way I can optimize it? (These values are current with the Load Data
