-1

This question already has an answer here:

Does it really matter if the default storage engine is InnoDB? My default storage engine is MyISAM

marked as duplicate by ypercubeᵀᴹ, a_horse_with_no_name, Vérace, RolandoMySQLDBA innodb Jun 11 '15 at 16:14

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 1
    This could easily be investigated by Googling. If you have more specific questions, get back to us. Voting to close. – Vérace Jun 11 '15 at 15:07
  • 1
    I'm voting to close this question as off-topic because this could be solved by Googling. If you need more specific information or have a problem with what you learn by Googling, then get back to us. MyISAM is being deprecated - even for system tables in 5.7. Lose it ASAP. – Vérace Jun 11 '15 at 15:08
  • When I searched for this question the similar one did not show up. No problem to close. I read the answers to the prior question, and it is much more thoroughly answered here. Appreciate it. – EGB Jun 11 '15 at 19:25
  • Don't hesitate to get back to us if you're still unclear. Check out the forum tour and the "help us to help you" blog, both at the bottom left of the page. These forums are a great resource and you will get all the more out of them if you follow the guidelines - p.s. welcome to the forum :-) – Vérace Jun 11 '15 at 19:47
0

Yes, there are many differences. The biggest for me is that InnoDB supports foreign keys MyISAM does not.

Some will argue that MyIsam is faster for reads, but if you want to take advantage of compression for example you need Innodb.

My default position is to start with InnoDB whenever possible, then if you cannot use this for example when using spatial features then use MyISAM.

The most concise post on this can be found over at Percona.

https://www.percona.com/blog/2009/01/12/should-you-move-from-myisam-to-innodb/

Hope this is of use

Not the answer you're looking for? Browse other questions tagged or ask your own question.