-->From: Jeremy Zawodny [mailto:Jeremy@stripped]
-->Sent: Tuesday, September 30, 2003 10:23 AM
-->To: Dathan Vance Pattishall
-->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
-->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
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.