From: Date: December 5 2005 4:26pm Subject: Re: MySQL 5 is 25% slower then 4.1 List-Archive: http://lists.mysql.com/mysql/192521 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Are you doing single insert statements, multiple insert statements or LOAD DATA INFILE statements? On 12/4/05, Chenzhou Cui 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=3Dgary.richardson@g= mail.com > >