At 11:31 AM 9/13/2005, you wrote:
Hi all,
I found that load infile should not take this much time(6 hrs) to load 5.5
million queries. Some people are saying it should not even take more than
10mins. So I think I am doing something wrong in my my.cnf file. I am Using
MySQL 4.1.13 version and
Yes, there are indexes on the table. Do you mean to say index is the
culprit.
sujay
-Original Message-
From: Peter J Milanese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 4:58 PM
To: Sujay Koduri; mysql
Subject: Re: Major Difference in response times when using Load
Hi
I am INNODB tables only. (I have only one big table)
Autocommit I have already disabled.
And it doesn't have any foreign keys in it. Do I still need to set the
FOREIGN_KEY_CHECKS to '0'??
sujay
-Original Message-
From: Alan Williamson [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
Hi all,
I found that load infile should not take this much time(6 hrs) to load 5.5
million queries. Some people are saying it should not even take more than
10mins. So I think I am doing something wrong in my my.cnf file. I am Using
MySQL 4.1.13 version and 2.4.20 kernel on RH9. I am including