Optimizing MySQL and PHP |
|
2024-11-25 |
|
|
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