On Thu, Sep 11, 2003 at 09:29:27AM -0700, Mark Kaufer wrote: > I've looked and looked but really can't find an answer to this question. > In my my.cnf file, these are some of the things that are specified in > [mysqld]: > > set-variable = key_buffer=256M > set-variable = table_cache=64 > set-variable = sort_buffer=512K > set-variable = max_connections=1000 > set-variable = thread_concurrency=10 > set-variable = innodb_buffer_pool_size=40M > set-variable = innodb_additional_mem_pool_size=40M > > On FreeBSD, I only have one process running which makes this information > pretty straight forward. On my linux boxes, there are many different > processes running (on one box, there is 31).
No, it's the same on all boxes. You have many threads. The difference is in how each OS presents them. As an interesting exercise, build your MySQL using LinuxThreads and notice the difference. > Does this mean that *each* of those 31 processes attempts to allocate the > above amount of resources, or that the above resources are being shared > between the 31 processes? The sort buffer is per-connection, all the others you list are global (shared) chunks of memory. There's a section in the MySQL manual that describes how MySQL uses memory. http://www.mysql.com/doc/en/Memory_use.html Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 156,095,869 queries (450/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
