In Mysql InnoDB and MYISAM are two different storage engines. By deafult the storage engine is MYISAM.

Difference between InnoDB and MyISAM :

1. InnoDB supports transactions whereas MYISAM does not. It means we can commit or roll back a transaction in InnoDB but in MYISAM once we execute a command tats it..

2. InnoDB provides row -level locking of a table whereas MYISAM provides only table-level locking.

3. InnoDB supports foreign keys whereas MYISAM does not support foreign key references. Even if you specify foreign key to a table of type MYISAM it willbe simply ignored.

4. Usually we go for InnoDB when we design large size tables and MYISAM is suitable for small size tables

Advertisement