MySQL Forums
Forum List  »  Performance

mysql 5.5.9 dreadfully slow
Posted by: nick rulez
Date: February 20, 2011 11:33AM

Hi. I'm trying for the first time mysql 5.5.9 on my notebook packard bell easynote tm86 and I'm very disappointed.

This in an example:

create table people(
id int not null auto_increment primary key,
`dob` date

delimiter //
drop procedure if exists date_random //
create procedure date_random(in low date,in upp date,in number int)
declare i int default 0;
while i < number do
    insert into people (`dob`)  values ( low + interval rand()* datediff(upp,low) day  );
    set i = i + 1;
end while;
end //
delimiter ;

call date_random('1910-01-01',curdate(),500000);

This sp on mysql 5.1.36 takes about 25 seconds.
On mysql 5.5.9 the same procedure takes 25 minutes and 26 seconds.
I was trying even some slow query that I had to see if they run better in the last version. Unluckily they are even slower.

Has anyone had the same problem?
Thanks for any opinion.

Edited 1 time(s). Last edit at 02/20/2011 07:27PM by nick rulez.

Options: ReplyQuote

Written By
mysql 5.5.9 dreadfully slow
February 20, 2011 11:33AM
February 21, 2011 01:39PM
February 21, 2011 04:21PM
February 21, 2011 05:51PM
February 21, 2011 07:44PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.