"Sung-Jin,Kim" wrote:
>
> 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.
>
> from Sung-Jin,KIM
Hi Sung-Jin
These are not processes, but threads.
This is a problem from ps not distinguishing between processes and threads.
You will always get one thread per currently running connection.
So in your example there are one mysql process and 24 threads (== connections to this
mysqld)
Tschau
Christian
