-->-----Original Message-----
-->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, September 30, 2003 10:23 AM
-->To: Dathan Vance Pattishall
-->Cc: [EMAIL PROTECTED]
-->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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
