Mysql 8.0 InnoDB Storage Engine Features
Feature Support
|
기능 |
지원 |
|
B-tree indexes |
Yes |
|
Backup/point-in-time recovery (Implemented in the server,rather than in the storage engine.) |
Yes |
|
Cluster database support |
No |
|
Clustered indexes |
Yes |
|
Compressed data |
Yes |
|
Data caches |
Yes |
|
Encrypted data |
Yes (Implemented in the server via encryption functions; In MySQL 5.7 and later, data-at-rest tablespace encryption is supported.) |
|
Foreign key support |
Yes |
|
Full-text search indexes |
Yes (InnoDB support for FULLTEXT indexes is available in MySQL 5.6 and later.) |
|
Geospatial data type support |
Yes |
|
Geospatial indexing support |
Yes (InnoDB support for geospatial indexing is available in MySQL 5.7 and later.) |
|
Hash indexes |
No (InnoDB utilizes hash indexes internally for its Adaptive Hash Index feature.) |
|
Index caches |
Yes |
|
Locking granularity |
Row |
|
MVCC |
Yes |
|
Replication support (Implemented in the server, rather than in the storage engine.) |
Yes |
|
Storage limits |
64TB |
|
T-tree indexes |
No |
|
Transactions |
Yes |
|
Update statistics for data dictionary |
Yes |