MySQL Storage engine selection

Generally speaking, there are innodb, in most cases, InnoDB can meet our daily needs, so after MySQL 5.5, InnoDB as the default storage engine. That is, in addition to some features InnoDB cannot provide, we will be able to choose other engines.

Transaction

If the transaction is to be used, then InnoDB is the second choice, at least for now. Because MyISAM does not support transactions, if you do not need transactions, mainly query, insert and other operations, then you can also use MyISAM.

Backup

In many cases, we are backing up the data while the application is still running, so if this is the case, the InnoDB comes in handy. Of course, if it is downtime backup, then do not have any problems, do not have to consider so many problems.

Crash recovery

If the system crashes, how can the data for high-speed recovery, which is a test for engineers, compared with MyISAM, innodb protection of the degree of better and faster recovery, so in this case, InnoDB is also the first choice.

Holding characteristics

Some applications may take advantage of some specific features or optimizations of the storage engine. If an application requires a variety of features, but these features cannot be fully provided by a single storage engine, it is necessary to consider the coordination of multiple engines, and consider some tradeoffs.

Read more and write fewer tables

If a table is only for reading data or most of the time it is read, use MyISAM, but as mentioned above, MyISAM is prone to collapse, if this is negligible, then use MyISAM.

Data compression

MyISAM in the table compression is very advantageous, compared with the compression before the table will save a lot of space, but the compressed table is read only, if this feature is placed in read-only scenarios, then this advantage is greatly displayed.

Large amount of data

If the amount of data increase to more than 10TB, then InnoDB and MyISAM Basic, if you want to spot, then have the consequences of conceit. So we have to use other solutions, Infobright is the MySQL Data Warehouse to provide the best way.

Source: http://blog.csdn.net/sinat_36246371/article/details/54016013