| Feature | InnoDB | MyISAM |
|---|---|---|
| Storage limits | 64TB | 256TB |
| Transactions | Yes | No |
| Locking granularity | Row | Table |
| MVCC | Yes | No |
| Geospatial data type support | Yes | Yes |
| Geospatial indexing support | No | Yes |
| B-tree indexes | Yes | Yes |
| T-tree indexes | No | No |
| Hash indexes | No | No |
| Full-text search indexes | Yes | Yes |
| Clustered indexes | Yes | No |
| Data caches | Yes | No |
| Index caches | Yes | Yes |
| Compressed data | Yes | Yes |
| Encrypted data | Yes | Yes |
| Cluster database support | No | No |
| Replication support | Yes | Yes |
| Foreign key support | Yes | No |
| Backup / point-in-time recovery | Yes | Yes |
| Query cache support | Yes | Yes |
| Update statistics for data dictionary | Yes | Yes |
등록된 댓글이 없습니다.
