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