Is faster InnoDB or MyISAM MySQL engine ? What's the difference ?

What is the difference between InnoDB and MyISAM engine in MySQL table ? Which one is faster ?
give a positive ratinggive a negative rating
17 Oct 2021 at 03:03 PM

There are multiple differences between InnoDB and MyISAM engine. Each of them has some advantages, so whether is better InnoDB or MyISAM depends on your needs. The main differences are:

MyISAM engine
  • Can do "only" full table-level locking
  • Does not support transactions
  • Key buffer is only for indexes
  • Is generally faster for SELECT

InnoDB engine
  • Is newer than MyISAM
  • Has row-level locking (allows multi processing on single table)
  • Supports transactions, foreign keys and relationship constraints
  • Supports large buffer pool for both data and indexes
  • Is generally faster for INSERT, UPDATE, DELETE

When you mostly read data (using SELECT) probably MyISAM engine will work faster. If you do many inserts, updates or deletions, you should get better performance by using InnoDB.
give a positive ratinggive a negative rating
19 Oct 2021 at 09:14 AM
Share on FacebookShare on TwitterShare on LinkedInSend email
2024 AnswerTabsTermsContact us