MENU
MyISAM
MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions.ISAM storage |
256TB |
| Transactions | No |
| Locking granularity | Table |
| MVCC | No |
| Geospatial data type support | Yes |
| Geospatial indexing support | Yes |
| B-tree indexes | Yes |
| T-tree indexes | No |
| Hash indexes | No |
| Full-text search indexes | Yes |
| Clustered indexes | No |
| Data caches | No |
| Index caches | Yes |
| Compressed data | Yes |
| Encrypted data | Yes |
| Cluster database support | No |
| Replication support | Yes |
| Foreign key support | No |
| Backup/ Point-in-time recovery | Yes |
| Query cache support | Yes |
| Update statistics for data dictionary | Yes |