Search code examples
mysqlinnodbmyisam

What is InnoDB and MyISAM in MySQL?

What is InnoDB and MyISAM in MySQL ?

Solution

  • InnoDB and MYISAM, are storage engines for MySQL.

    These two differ on their locking implementation: InnoDB locks the particular row in the table, and MyISAM locks the entire MySQL table.

    You can specify the type by giving MYISAM OR InnoDB while creating a table in DB.