On Tue, Nov 04, 2003 at 10:09:01AM -0000, Alexis Guia wrote:
> I think that MyISAM uses the key buffer only if needed. The same happens
> with almost all the other buffers (read buffer, sort buffer, etc.).
True, but there's a subtle difference between "uses" and "allocates."
If you tell MySQL that it has 16GB for a key_buffer, it'll allocate
16GB even if it only ever uses 28KB. The same is true of several
(probably all?) other buffers.
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 51 days, processed 1,925,645,484 queries (428/sec. avg)