My SQL Storage Engine InnoDB VS MyISAM

8 08 2014
*************************** InnoDB  ***************************
      Engine: InnoDB
     Support: DEFAULT
     Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
          XA: YES
  Savepoints: YES
*************************** MyISAM    ***************************
      Engine: MRG_MYISAM
     Support: YES
     Comment: Collection of identical MyISAM tables
Transactions: NO
          XA: NO
  Savepoints: NO

InnoDB  :

The default storage engine in MySQL 5.7. Supports ACID, row level locking , Mostly used for Write/Update/Delete Operations.

MyISAM   :

Table level locking

supports for Fast Read from DB.




%d bloggers like this: