List:General Discussion« Previous MessageNext Message »
From:Dathan Vance Pattishall Date:September 30 2003 6:39pm
Subject:RE: What are the effects of key_buffer on a dedicated slave
View as plain text  
-->-----Original Message-----
-->From: Dan Nelson [mailto:dnelson@stripped]
-->Sent: Tuesday, September 30, 2003 11:35 AM
-->To: Dathan Vance Pattishall
-->Cc: mysql@stripped
-->Subject: Re: What are the effects of key_buffer on a dedicated slave
-->
-->A better question to ask might be "what is my current index hit
ratio,
-->and is it low enough that I need to bump key_buffer"?

Okay yes, this makes sense.


-->from increasing key_buffer.  If key_reads is very close to
-->key_blocks_used, you might want to shrink key_buffer because mysql
has


This is fantastic. I totally over looked this fact. Thanks for the
insight.

-->never had to throw away a cached index block.  Note that the more
-->memory you allocate to key_buffer, the less memory the OS has
available
-->to cache the table data istelf.
-->



Thread
What are the effects of key_buffer on a dedicated slaveDathan Vance Pattishall30 Sep
  • Re: What are the effects of key_buffer on a dedicated slaveJeremy Zawodny30 Sep
    • RE: What are the effects of key_buffer on a dedicated slaveDathan Vance Pattishall30 Sep
    • RE: What are the effects of key_buffer on a dedicated slave [also]Dathan Vance Pattishall30 Sep
      • Re: What are the effects of key_buffer on a dedicated slave [also]Jeremy Zawodny30 Sep
        • RE: What are the effects of key_buffer on a dedicated slave [also]Dathan Vance Pattishall30 Sep
          • Re: What are the effects of key_buffer on a dedicated slave [also]Jeremy Zawodny30 Sep
            • RE: What are the effects of key_buffer on a dedicated slave [also]Dathan Vance Pattishall30 Sep
              • Re: What are the effects of key_buffer on a dedicated slave [also]Jeremy Zawodny30 Sep
                • Re: What are the effects of key_buffer on a dedicated slave [also]William R. Mussatto30 Sep
                  • Re: What are the effects of key_buffer on a dedicated slave [also]Jeremy Zawodny1 Oct
  • Re: What are the effects of key_buffer on a dedicated slaveDan Nelson30 Sep
    • RE: What are the effects of key_buffer on a dedicated slaveDathan Vance Pattishall30 Sep