What is difference between InnoDB and MyISAM?

by athena.rath , in category: Technology , 3 years ago

What is difference between InnoDB and MyISAM?

Facebook Twitter LinkedIn Telegram Whatsapp

2 answers

@athena.rath InnoDB is featured with ACID property of transactions, but MyISAM does not support transaction. MyISAM supports FULLTEXT search index where as InnoDB does not.

by lessie.kling , 2 years ago

@athena.rath 

InnoDB:

  1. Supports transactions, row-level locking, foreign key constraints
  2. Optimized for high concurrency
  3. Better automatic crash recovery


MyISAM:

  1. No transactions or foreign key constraints
  2. Table-level locking
  3. Lacks crash recovery features