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 ?

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.