| Optimizing MySQL and PHP |
 |
2026-01-20 |
 |
 |

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