Ask Question Sign In Sign Up

What is difference between InnoDB and MyISAM?

Member

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

What is difference between InnoDB and MyISAM?

Facebook Twitter LinkedIn Telegram Whatsapp

2 answers

Member

by lucinda.runolfsdottir , 3 years ago

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

Member

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

Related Threads:

What is the difference between DISTINCT and GROUP BY?
What is the difference between class and an object?
What is difference between xhr.status and xhr.readyState?
Explain the difference between HTTP and HTTPS.
What is the basic difference between overloading and overriding?
Explain the difference between HTML, CSS, and JavaScript.