#写的不好轻喷
The InnoDB engine is the default after acquisition by Oracle
MyISAM
- Default storage engine prior to Mysql5.5.5
-
- Support for large files, usually considered to be 256TB
- Suitable for read and write-less applications
- The maximum number of indexes per MyISAM table is 64, which can be changed by compilation
- Blob and text types can be indexed
- Support Full-Text indexing
- Only table locks are supported
- Non-transactional engine
-
- Transactional operations are not supported
- The. frm file stores table definitions,. MyD data files,. Myi Index File
-
- We create a table in Fandb that MyISAM engine stores, and in/var/lib/mysql/fandb you can find the table definition file frm data file myd
InnoDB
- Currently MySQL's default storage engine
-
- Transactional engine
- Support for row and foreign keys
- Maximum performance design for large volumes of data
- The. Ibdata1 automatically expands the data file. IB_LOGFILE0/1 log files
- Only InnoDB supports foreign keys
Memory
- Storage engine that stores data in memory
- Fast
- Blob and text columns are not supported
- Non-transactional engine
NDB
- Clustered storage engine for MySQL cluster
- Provides high availability at the data level
- Complex query performance, such as multi-table queries, is relatively less of an advantage
- is still being perfected.
About MySQL storage engine