List:General Discussion« Previous MessageNext Message »
From:Dathan Vance Pattishall Date:September 30 2003 6:06pm
Subject:RE: What are the effects of key_buffer on a dedicated slave
View as plain text  


-->-----Original Message-----
-->From: Jeremy Zawodny [mailto:Jeremy@stripped]
-->Sent: Tuesday, September 30, 2003 10:23 AM
-->To: Dathan Vance Pattishall
-->Cc: mysql@stripped
-->Subject: Re: What are the effects of key_buffer on a dedicated slave
-->
-->That depends, of course.  If your key_buffer is already twice the
size
-->of all your MYI files, it won't make any difference.  Without knowing
-->the size of your index files, memory configuration, and the diversity
-->of key values needed in a short amount of time, it's impossible to
say.

The total size of this dedicated slave's INDEX files are 6.2G (100 index
files). I run a key buffer size around 1G on a box with about 4G of
memory. For this case what would you recommend? Do you use a formula to
determine memory configuration?
Based on the types of queries used, I usually will try small tweak to
the read and sort buffers. If the key_buffer should be twice the size of
the total INDEX file size then I will have to rethink the table schema.



- Dathan Vance Pattishall
  - Sr. Programmer and mySQL DBA for FriendFinder Inc.
  - http://friendfinder.com/go/p40688



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