Re: myisam data (row) buffer

[Gabriel Tataranu]

> No, MyISAM does not cache data records, only index

This blows. Please somebody, implement a row cache.

> records (which is really what you are talking
> about anyway). You should increase the

Guess again.

> key_buffer_size variable to increase the amount of
> memory used for MyISAM index blocks.

The index buffer is already big enough. The problem is that real-world applications cannot have indexed queries for every query so increasing the key buffer size doesn't help.
Before sugesting that all the queries should use indexes to get the data, stop for a minute and remember that indexes are useful ONLY in some cases.
Also InnoDB is not the answer in this case since InnoDB doesn't implement compressed and merge tables.