MySQL Forums
Forum List  »  InnoDB

Re: Innodb v/s Myisam
Posted by: Rick James
Date: September 10, 2011 11:03AM

"It depends".
It depends on how big the data is -- because of caching differences, and size differences.
It depends on the INDEXes (as Greg found) -- because of various differences in how indexes act.
It depends on concurrency -- MyISAM's table locking; InnoDB's better use of multiple cores; etc
It depends on the query -- some SELECTs inherently work faster in one engine (or the other).

MySQL 5.5 / 5.6 / Percona -- these have improved InnoDB some, leading to "InnoDB is faster" is the answer more often.

There are still specific examples where MyISAM is faster.

Both are plenty fast for most users most of the time.

If your data is smaller than RAM (and you have tuned MySQL correctly), the they are both likely to be so fast you shouldn't care.

Options: ReplyQuote


Subject
Views
Written By
Posted
2740
July 20, 2011 01:28AM
1067
July 20, 2011 02:11PM
1180
September 08, 2011 01:01PM
Re: Innodb v/s Myisam
1073
September 10, 2011 11:03AM


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.