Comparison of mysql Storage engine MYISAM and innodb
MyISAM is suitable for some applications that require a large number of queries, but it is not very good for a large number of writes. Even if you just need to update one field, the entire table will be locked, and no other process, even the read process, will be able to operate until the read operation is complete. In addition, MyISAM is extremely fast for calculations like SELECT COUNT (*).
The trend of InnoDB will be a very complex storage engine, which will be slower than MyISAM for some small applications. It supports "row locks", so when there are more writes, it will be better. In addition, he supports more advanced applications, such as transactions.
