title: MySQL - InnoDB vs MyISAM
body: <p>I read the following article yesterday (<a href="http://blogs.sitepoint.com/2010/11/19/mysql-mistakes-php-developers/" rel="noreferrer">http://blogs.sitepoint.com/2010/11/19/mysql-mistakes-php-developers/</a>) and it wrote the following:</p>
  <blockquote>
  <p>MySQL has a number of database engines but you’re most likely to encounter MyISAM and InnoDB.</p>
  <p>MyISAM is used by default. However, unless you’re creating a very simple or experimental database, it’s almost certainly the wrong choice! MyISAM doesn’t support foreign key constraints or transactions which are essential for data integrity. In addition, the whole table is locked whenever a record is inserted or updated: it causes a detrimental effect on performance as usage grows.</p>
  <p>The solution is simple: use InnoDB.</p>
  </blockquote>
  <p>I've always used MyISAM because it was the default. What do you think?</p>
  <p>If I were to upgrade to InnoDB, in phpMyAdmin, can I just edit each table and change it to innoDB or is there a more complex process to perform?</p>
  <p>Thanks!</p>