Hi,
This formula shows up in a few places (this is from
<http://dev.mysql.com/books/hpmysql-excerpts/ch06.html>):
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
My question is, once one of the buffers (e.g., sort_buffer) is needed
by a thread, does the thread hold onto it in case it needs it again,
or does the thread free it as soon as it can? I'm using 4.1.13.
I'm trying to figure out an optimum value for max_connections. If the
threads don't release their memory, then I really do have to account
for the fact that each thread over time will probably be holding each
of those buffers. If threads give up the memory as soon as the, e.g.,
sort, is finished, then I only have to figure out how many threads are
likely to need a sort_buffer at any given time.
I looked through the manual, various online documentation, and the
source, but haven't been able to determine an answer.
Thanks,
--
Pete Harlan
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
