Re[2]: key_buffer_size and memory used by mysqld

2006-03-11 Thread Denis Solovyov
KJ> This would clear your doubt about which memory is shared by all KJ> threads and which memory is used by individual threads .. KJ> min_memory_needed_by_mysql  = (global_buffers + KJ> ((thread_buffers )* max_connections))) OK, so when I see in `ps aux` that every thread uses 3.4% (twenty M

Re: key_buffer_size and memory used by mysqld

2006-03-09 Thread Kishore Jalleda
This would clear your doubt about which memory is shared by all threads and which memory is used by individual threads .. min_memory_needed_by_mysql = (global_buffers + ((thread_buffers )* max_connections))) where thread_buffers includes the following: sort_buffer myisam_sort_buffer read_bu

key_buffer_size and memory used by mysqld

2006-03-09 Thread Denis Solovyov
Please explain to me how mysqld's "key buffer" uses memory under Linux (kernel 2.4, glibc 2.3, mysql 4.1). I'd want to know for sure if every mysqld thread (forked upon an incoming connection) uses its own memory for key buffer (key_buffer_size) or key buffer is common for all mysql t