List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:November 4 2003 11:51pm
Subject:Re: mysql memory usage
View as plain text  
On Tue, Nov 04, 2003 at 10:09:01AM -0000, Alexis Guia wrote:
> 
> Hi,
> 
> 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
-- 
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)
Thread
mysql memory usageBenjamin KRIEF3 Nov
  • RE: mysql memory usageAlexis Guia4 Nov
    • Re: mysql memory usageJeremy Zawodny5 Nov
      • RE: mysql memory usageAlexis Guia5 Nov
        • Re: mysql memory usageMatt W6 Nov
          • Re: mysql memory usageJeremy Zawodny6 Nov
        • Re: mysql memory usageJeremy Zawodny6 Nov