Since I can't get the book until this evening ... In most sample my.cnf files online I see the following setup: [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer=16M write_buffer = 16M
If these are per thread -- aren't they a bit high? thanks. erin --- Kishore Jalleda <[EMAIL PROTECTED]> wrote: > Yes you are right, these are Thread specific > settings, leave them at > 1M or 2M, atleast that's what I set on our > productions systems, else > you risk at running out of memory under high loads, > and it works > great, the other parameters as cited in the book > High performance > Mysql , by Jeremy Zawodny says this > > min_memory_needed = global_buffers + (thread_buffers > * max_connections) > > where thread_buffers includes the following: > > sort_buffer > > myisam_sort_buffer > > read_buffer > > join_buffer > > read_rnd_buffer > > and global_buffers includes: > > key_buffer > > innodb_buffer_pool > > innodb_log_buffer > > innodb_additional_mem_pool > > net_buffer > > > Hope thsi helps .... > Kishore Jalleda > > On 6/23/05, erin oneill <[EMAIL PROTECTED]> wrote: > > I'm working on fine tuning the Server Parameters > for a > > machine (with 2 GB of RAM). The database has a > fair > > number of tables. Many of them are full of blobs. > The > > version of our production MySQL is: > > 4.0.20-pc-linux-i686. > > > > In trying to decide on some of the buffer > variables > > I've seen some very desparate choices with a > couple of > > them. They are: > > read_buff_size, sort_buffer_size, > > read_rnd_buffer_size. > > > > Many people have these set rather high (like > 128M+). > > But I read somewhere that these settings are PER > > CONNECTION and not for the server itself. If that > is > > so - shouldn't they be more like 8M, 8M & 6M ?? > > > > Are there other variables that are PER CONNECTION > and > > not for the whole server that I need to re-think? > > > > thanks, > > erin > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > __________________________________ Discover Yahoo! Get on-the-go sports scores, stock quotes, news and more. Check it out! http://discover.yahoo.com/mobile.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
