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]