what is difference between myisam and innodb?
The most commonly used storage engine in MySQL are MyISAM and InnoDB. ... The main difference between MyISAM and INNODB are : MyISAM does not support transactions by tables while InnoDB supports. There are no possibility of row-level locking, relational integrity in MyISAM but with InnoDB this is possible.