innoDB & myISAM

innoDB: ACID transaction, forein key, buffer pool, row lock

 

MyISAM: fast read low write, no transaction, table stored in 3 files — structure/index/data, table lock