| Optimizing MySQL and PHP |
 |
2025-02-08 |
 |
 |
22 |
 |
|
HEAP
- • Not transaction-capable
- • Stored in memory (so data lost on shutdown)
- • Hash indexes (great for indexed lookups, not for range queries)
- • Btree indexes in 4.1
Dynamic
- • Not transaction-capable
- • Migrates between memory and disk
- • New in 4.1
Cluster
