|
ndexes |
No
|
No
|
Yes
|
No
|
No
|
| Datacaches
|
No
|
N/A
|
Yes
|
No
|
Yes
|
| Indexcaches
|
Yes
|
N/A
|
Yes
|
No
|
Yes
|
| Compresseddata
|
Yes[d]
|
No
|
Yes[e]
|
Yes
|
No
|
| Encrypteddata[f]
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
| Clusterdatabase support
|
No
|
No
|
No
|
No
|
Yes
|
| Replicationsupport[g]
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
| Foreignkey support
|
No
|
No
|
Yes
|
No
|
No
|
| Backup/ point-in-time recovery[h]
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
| Querycache support
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
| Updatestatistics for data dictionary
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
| [a]InnoDB support for geospatial indexing is available in MySQL5.7.5 and higher.
[b]InnoDB utilizes hash indexes internally for its AdaptiveHash Index feature.
[c]InnoDB support for FULLTEXT indexes is available in MySQL5.6.4 and higher.
[d]Compressed MyISAM tables are supported only when using thecompressed row format. Tables using the compressed row formatwith MyISAM are read only.
[e]Compressed InnoDB tables require the InnoDB Barracuda fileformat.
[f]Implemented in the server (via encryption functions), ratherthan in the storage engine.
[g]Implemented in the server, rather than in the storageengine.
[h]Implemented in the server, rather than in the storageengine.
|