Mysql storage engine Introduction
# Not easy to write
The default INNODB engine is used after ORACLE is acquired.
MyISAM
- Default storage engine before Mysql5.5.5
-
- Supports large files, usually 256 TB
- Suitable for read-write-less application scenarios
- The maximum number of indexes in each MyISAM table is 64, which can be changed through compilation.
- BLOB and TEXT types can be indexed
- Full-text index supported
- Only table locks are supported.
- Non-transactional Engine
-
- Transaction operations are not supported
- . Frm file storage table definition,. MYD data file,. MYI index file
-
- Create a MyISAM engine storage table in FANDB, and find the table definition file frm data file MYD in/var/lib/mysql/fandb.
InnoDB
- Currently, the default storage engine of Mysql
-
- Transaction Engine
- Supports row locks and Foreign keys
- Designed for the maximum performance of massive data volumes
- . Ibdata1 automatically extends data files. Ib_logfile0/1 Log File
- Only InnoDB supports foreign keys
Memory
- Store data to the memory storage engine
- Fast
- BLOB and TEXT columns are not supported.
- Non-transactional Engine
NDB
- Cluster Storage engine for Mysql Cluster
- High Availability at the data layer
- For example, multi-table queries and other complex queries are not advantageous in performance
- Still improving