Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.