Re: MySQL 5 is 25% slower then 4.1

[Gary Richardson]

Are you doing single insert statements, multiple insert statements or
LOAD DATA INFILE statements?

On 12/4/05, Chenzhou Cui <ccz@stripped> wrote:
> 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/mysql?unsub=1
>
>