MySQL Forums
Forum List  »  Performance

Re: mysql 5.5.9 dreadfully slow
Posted by: nick rulez
Date: February 21, 2011 07:44PM

Rick, you were right. I was comparing apples with pears. :)
My create table didn't specify the engine.
So in mysql 5.1 the stored procedure ran on a myisam table.
I just read on the manual that in the last version the new default engine is innodb.

show engines query confirms it.

I made a last test:

MYSQL 5.1

call date_random('1910-01-01',curdate(),500000);
-- myisam 26 seconds
-- innodb 14 minutes and 30 seconds

MYSQL 5.5
call date_random('1910-01-01',curdate(),500000);
-- myisam table 20 seconds
-- innodb 7 minutes and 46 seconds

So last version is faster with both engines. I don't know why this time it took just 7 minutes instead of 25 but now everything makes sense.

Thanks for your great kindness and sorry for making you waste time on something so silly.

Nicola

Options: ReplyQuote


Subject
Views
Written By
Posted
3835
February 20, 2011 11:33AM
1605
February 21, 2011 01:39PM
2713
February 21, 2011 04:21PM
2350
February 21, 2011 05:51PM
Re: mysql 5.5.9 dreadfully slow
2572
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.