which is better myisam or innodb?
InnoDB is better option while you are dealing with larger database because it supports transactions, volume while MyISAM is suitable for small project. As InnoDB supports row-level locking which means inserting and updating is much faster as compared with MyISAM.