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 |
'Knowledge > MySQL' 카테고리의 다른 글
| Mysql 8 vs PostgreSQL 10 간단 비교 (2) | 2019.01.02 |
|---|---|
| reset root password (0) | 2015.01.19 |
| mysql parameter 튜닝했던 기록 (0) | 2015.01.14 |
