0

what are the main technical reasons to use innodb type of tables most of the time, rather than myiasm. I searched for it, but not satisfied / confused. some are saying it depends on the requirement. can anyone explain how it depends on the requirement and where it differs in performance?

Pramod
  • 2,828
  • 6
  • 31
  • 40
  • http://stackoverflow.com/questions/20148/myisam-versus-innodb – Rupam Apr 04 '14 at 11:49
  • @Rupam - the question you linked is outdated at this point, InnoDB has caught up with missing features present in MyISAM. The main reason you want to use InnoDB is because it's a transactional engine. If you don't know why that's important, you have some googling to do (google for transactions in databases). – N.B. Apr 04 '14 at 11:57

2 Answers2

0

There's a whole wikipedia page just for this discussion :-)

http://en.wikipedia.org/wiki/Comparison_of_MySQL_database_engines

Leo
  • 6,480
  • 4
  • 37
  • 52
  • Thank you @Leo. I visited the above link but cant get last two columns exactly i.e. Transactional & Under active development, will you please explore that – Pramod Apr 04 '14 at 12:26
0

InnoDB is a right choice if you are using MySQL v5.6 as InnoDB supports full text search (FTS)

You can refer my existing answer from here https://dba.stackexchange.com/questions/1/what-are-the-main-differences-between-innodb-and-myisam/46663#46663

Community
  • 1
  • 1
Mahesh Patil
  • 1,529
  • 1
  • 11
  • 22