Re: MyISAM error 127

2005-05-04 Thread TheRefUmp
Hi, Thanks for the reply. Are u suggesting that I shutdown MySQL? I thought that a FLUSH table command would take care of things. Stupid me! gerald_clark [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: Hi, We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for our

MyISAM error 127

2005-05-02 Thread TheRefUmp
Hi, We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for our data warehouse. I have a group of tables (9/2004 through 2/2005) that average about 95 million rows (215 byte rows). Using PERL and piping to mysql LOAD DATA is the way we've been loading. That all worked as

Re: MyISAM error 127

2005-05-02 Thread gerald_clark
[EMAIL PROTECTED] wrote: Hi, We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for our data warehouse. I have a group of tables (9/2004 through 2/2005) that average about 95 million rows (215 byte rows). Using PERL and piping to mysql LOAD DATA is the way we've been loading.