MySQL 5 is 25% slower then 4.1

[Chenzhou Cui <suppressed>]

Dear  MySQL fans,

I have a 260 GB huge file with 1045175762 rows. Two weeks ago, I wrote a 
Java program to read the huge plain text file into MySQL 4.1.12.  300 
million of rows could be loaded in one day.

Last Thursday, I updated the MySQL to 5.0.16 and then run the same 
program. Only 225 million of rows can be loaded in one day.

In additional to the version difference, the MySQL 4.1.12 was compiled 
from SRPM packages from RedHat Updates, while the MySQL 5.0.16 is 
installed directly using the MySQL binary RPM packages for Redhat AS 4.

Any information and suggestion are welcome.

Regards,
Chenzhou CUI


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed