How many types of mysql storage engines are there?

mysql storage engine

Answer: There are two commonly used ones, one is innodb and the other is myisam. The main difference between the two is

1) myisam does not support transaction processing, while innoDB supports transaction processing

2) myisam does not support foreign keys, innoDB supports foreign keys

3) myisam supports full-text retrieval, while innoDB supports full-text retrieval in MySQL5.6 Full-text search is only supported after the version

4) The storage form of data is different. Mysiam tables are stored in three files: structure, index, and data. InnoDB storage stores the structure as one file, and the index and data as one. File

5) Myisam has better performance than innoDB in querying and adding data, and innoDB has higher performance in batch deletion.

6) myisam supports table locks, while innoDB supports row locks

The above is the detailed content of How many types of mysql storage engines are there?. For more information, please follow other related articles on the PHP Chinese website!