MySQL Storage Engine Architecture Indicates that an engine is available mysql> SHOW ENGINES\G Table 13.1. Storage Engine Features Feature MyISAM Memory InnoDB Archive NDB Storage limits 256TB RAM 64TB None 384EB Transactions No No Yes No Yes Locking granularity Table Table Row Row Row MVCC No No Yes No No Geospatial data type support Yes No Yes Yes Yes Geospatial indexing support Yes No No No No B-tree indexes Yes Yes Yes No Yes Hash indexes No Yes No No Yes Full-text search indexes Yes No No No No Clustered indexes No No Yes No No Data caches No N/A Yes No Yes Index caches Yes N/A Yes No Yes Compressed data Yes [ a ] No Yes [ b ] Yes No Encrypted data [ c ] Yes Yes Yes Yes Yes Cluster database support No No No No Yes Replication support [ d ] Yes Yes Yes Yes Yes Foreign key support No No Yes No No Backup / point-in-time recovery [ e ] Yes Yes Yes Yes Yes Query cache support Yes Yes Yes Yes Yes Update statistics for data dictionary Yes Yes Yes Ye...
