List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:June 2 1999 1:54pm
Subject:Re: Q> how much are there mysql process ?
View as plain text  
"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

Thread
Q> how much are there mysql process ?Kim Sung-Jin2 Jun
  • Re: Q> how much are there mysql process ?Christian Mack2 Jun