title: What's the difference between MyISAM and InnoDB?
body: <p>I understand that this question has been asked before, but most of the time it is asked in relation to a specific database or table. I cannot find an answer on this site that describes the two engines and their differences without respect to someones specific database. </p>
  
  <p>I want to be able to make more informed decisions in the future with respect to designing a table or database, so am looking for a comprehensive answer on the differences between the two storage engines.</p>
  
  <p>What's the difference between <a href="http://en.wikipedia.org/wiki/MyISAM" rel="noreferrer">MyISAM</a> and <a href="http://en.wikipedia.org/wiki/InnoDB" rel="noreferrer">InnoDB</a>, and what should I be looking for when trying to decide between one or the other?</p>