List:General Discussion« Previous MessageNext Message »
From:Dathan Vance Pattishall Date:September 30 2003 5:10pm
Subject:What are the effects of key_buffer on a dedicated slave
View as plain text  
I haven't notice a gain from increasing the key_buffer on a dedicated
slave. Let's take 3.23.5x for instance. Since there is only 1 thread for
replication, a Serialized committal of data, I wouldn't imagine that
key_buffer at higher levels say around 50% of system memory would give a
performance boost. In fact raising sort_buffer, read_buffer,
read_rnd_buffer would be more of a win to reduce lock times so committal
of the data happens faster.
 
Is this observation wrong? Does raising key_buffer on a slave to around
50% of the memory available make a difference?
 
 
 
- 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