2 messages in com.mysql.lists.mysqlQ> how much are there mysql process ?
FromSent OnAttachments
Sung-Jin,Kim01 Jun 1999 19:19 
Christian Mack02 Jun 1999 06:53 
Subject:Q> how much are there mysql process ?
From:Sung-Jin,Kim (sjk@www.free114.com)
Date:06/01/1999 07:19:44 PM
List:com.mysql.lists.mysql

Hi.. all forks.

I examined the number of mysql process with ps command.

the result is below.

[sjkim@server2 sjkim]$ ps -aex | grep mys 444 ? S 0:00 sh ./safe_mysqld 455 ? S N 0:32 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 457 ? S N 0:51 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 458 ? S N 0:11 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 1075 ? S N 0:03 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 1231 p4 S 0:00 mysql i114 1232 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 3707 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 3755 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 3845 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 3852 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 3892 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 3944 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 3946 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 3952 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 3994 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 3996 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 4001 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 4010 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 4034 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 4035 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 4094 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 4119 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 4131 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 4142 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 4157 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 4219 ? S N 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/u 21968 p4 T 0:00 mysql i114 3844 p2 S 0:00 mysql test

There are so many mysqld processes!!!! why? as long as i know, mysql is multi-threaded server. but, It seems to be multi-process server.

is there any other compile options? or, I've mistakensomething?

Thanks.