| MYSQL Storage Engine | MyISAM | Heap | BDB | InnoDB |
| Transactions | No | No | Yes | Yes |
| Lock granularity | Table | Table | Page (8 KB) | Row |
| Storage | Split files | In-memory | Single file per table | Tablespace(s) |
| Isolation levels | None | None | Read committed | All |
| Portable format | Yes | N/A | No | Yes |
| Referential integrity | No | No | No | Yes |
| Primary key with data | No | No | Yes | Yes |
| MySQL caches data records | No | Yes | Yes | Yes |
| Availability | All versions | All versions | MySQL-Max | All Versions |
229
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
