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).
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?
Linux reports the threads of a process as processes. You really only have one process, with 31 threads. (Probably because a bunch of clients have connected.) So your resources are shared among the threads of the server process.
If anyone could straighten me out here, I would truly appreciate it!
Cheers,
Mark
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
