My SQL Storage Engine InnoDB VS MyISAM

techsivam 

*************************** 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.

 

 

Published by techsivam

I born in Coimbatore,Tamil Nadu ,India. Now work as a Software Developer. I like to read books,Music,Business,Politics,Friends,Social Servic

Leave a comment