Optimizing MySQL and PHP |
|
2024-11-25 |
|
|
20 |
|
|
- • Not transaction-capable
- • Table-level locking
- • Fast appends (great for logging)
- • Can be compressed
The MERGE table type allows you to treat several MyISAM tables as a
single table: great for chunking logs into manageable pieces (so parts can be
compressed).