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

This article mainly introduces the two most common MYSQL storage engines INNODB and MYISAM, the content of the article is carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively large, the following with the author to understand the two most common MYSQL storage engines INNODB and MYISAM bar.

Data size is an important factor in which storage engine you choose, and large size datasets tend to choose InnoDB because of its support for transaction processing and failover. The size of the database determines how long it takes to recover from a failure. InnoDB can use transaction logs for data recovery, which is faster. Whereas MyISAM can take hours or even days to do these things, InnoDB takes just minutes.

Your habit of manipulating database tables can also be a big performance factor. For example, COUNT() can be very fast in MyISAM tables, but painful in InnoDB tables. Primary key queries are fairly fast under InnoDB, but be careful if our primary key is too long it can cause performance problems. Large numbers of inserts statements are faster under MyISAM, but updates are faster under InnoDB--especially when concurrency is high.

So, which one are you going to use? As a rule of thumb, MyISAM may be more suitable for smaller applications or projects. Of course, MyISAM can have great success in large environments, but not always. If you are planning to use a large data volume project and need transaction processing or foreign key support, then you really should go straight to InnoDB. But remember that InnoDB tables require more memory and storage, and converting 100GB MyISAM tables to InnoDB tables may give you a very bad experience.

After reading the above two most common MYSQL storage engines INNODB and MYISAM, many readers must have a certain understanding, if you need to obtain more industry knowledge information, you can continue to pay attention to our industry information column.

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.