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]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
