Googling "myisam vs innodb" gives a lot of pretty informative results, including (http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB http://tag1consulting

Googling "myisam vs innodb" gives a lot of pretty informative results, including (http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB). The big turn-off for me with MyISAM is that I can run a script to create some tables and setup for FK dependancies, and it will happily run it without errors, but won't enforce the constraints I created. Terrible behavior. I need foreign keys, transactions, row locking, etc... Of course I now happily use PostgreSQL:)