Basically commenting on http://www.mysqlperformanceblog.com/2006/05/17/mysql-server- memory-usage
When computing maximum memory usage for a thread I have one source that says:
read_buffer_size + read_rnd_buffer_size + sort_buffer_size + thread_stack + join_buffer_size
another that says:
sort_buffer_size + myisam_sort_buffer_size + read_buffer_size + join_buffer_size + read_rnd_buffer_size
yet another:
thread_stack + net_buffer_length X 2 + record_buffer and/or record_rnd_buffer + sort_buffer_size
Regardless, all attest the importance of keeping per thread memory allocation reasonable; hoverver, there is no way to even generically estimate what it could/should be?
When computing maximum memory usage for a thread I have one source that says:
read_buffer_size + read_rnd_buffer_size + sort_buffer_size + thread_stack + join_buffer_size
another that says:
sort_buffer_size + myisam_sort_buffer_size + read_buffer_size + join_buffer_size + read_rnd_buffer_size
yet another:
thread_stack + net_buffer_length X 2 + record_buffer and/or record_rnd_buffer + sort_buffer_size
Regardless, all attest the importance of keeping per thread memory allocation reasonable; hoverver, there is no way to even generically estimate what it could/should be?
Comment