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)
begin
declare i int default 0;
while i < number do
    begin
    insert into people (`dob`)  values ( low + interval rand()* datediff(upp,low) day  );
    set i = i + 1;
    end;
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


Subject
Views
Written By
Posted
mysql 5.5.9 dreadfully slow
3924
February 20, 2011 11:33AM
1658
February 21, 2011 01:39PM
2839
February 21, 2011 04:21PM
2459
February 21, 2011 05:51PM
2664
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.