Mysql database engine analysis

mysql Analysis of the characteristics of database engine ：

1、InnoDB Storage engine
InnoDB Is the preferred engine for transactional databases , Support transaction security （ACID）, Other storage engines are non transactional security tables , Support row locking and foreign keys ,MySQL5.5 In the future, it will be used by default InnoDB Storage engine .
InnoDB characteristic ： Support transaction processing , Support foreign keys , Support for crash recovery and concurrency control . If you need to have a high requirement for transaction integrity （ Such as banks ）, Concurrent control is required （ Like selling tickets ）, Then choose InnoDB There are great advantages .
If frequent updates are needed 、 Delete the database of operation , You can also choose InnoDB, Because it supports transaction commit （commit） And rollback （rollback）.

2、MyISAM Storage engine
MyISAM Has a higher insert 、 Query speed , Transaction is not supported , Foreign key not supported
MyISAM be based on ISAM Storage engine , And expand it . It's in Web、 One of the most commonly used storage engines in data warehousing and other application environments .MyISAM Has a higher insert 、 Query speed , Transaction is not supported , Foreign key not supported .
MyISAM characteristic ： Insert data fast , Low space and memory usage . If the table is mainly used to insert new records and read records , So choose MyISAM It can achieve high processing efficiency . If the integrity of the application 、 Concurrency requirements are relatively low , You can also use

3、MEMORY Storage engine
MEMORY The storage engine stores the data in the table in memory , Provides quick access to queries and references to other table data .
MEMORY characteristic ： All the data is in memory , Data processing speed is fast , But the security is not high . If you need fast reading and writing speed , Low security requirements for data , You can choose MEMOEY.
It has requirements for the size of the table , Can't build too large a table . therefore , This kind of database is only used in relatively small database tables .

=================== Gorgeous split line =================

If you don't understand , The following sentence is clear to you ：
1、InnoDB Storage engine
The requirements for transaction integrity are relatively high

2、MyISAM Storage engine
MyISAM Has a higher insert 、 Query speed , Transaction is not supported , Foreign key not supported

3、MEMORY Storage engine
For fast reading , Data in memory , The watch can't be too big