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 ?
17 Oct 2021 at 03:03 PM
0pnshow more
LarsLars
Hi,

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.
19 Oct 2021 at 09:14 AM
0pnshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook & Twitter
2021 AnswerTabsTermsContact us