difference between innodb and myisam

1MYISAM:
2
3MYISAM supports Table-level Locking
4MyISAM designed for need of speed
5MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS
6MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI)
7MYISAM not supports transaction. You cannot commit and rollback with MYISAM. Once you issue a command it’s done.
8MYISAM supports fulltext search
9You can use MyISAM, if the table is more static with lots of select and less update and delete.
10
11INNODB:
12
13InnoDB supports Row-level Locking
14InnoDB designed for maximum performance when processing high volume of data
15InnoDB support foreign keys hence we call MySQL with InnoDB is RDBMS
16InnoDB stores its tables and indexes in a tablespace
17InnoDB supports transaction. You can commit and rollback with InnoDB