[CentOS] only one mysql process in pstree

Fri Jul 21 02:36:41 UTC 2006
Renjith Rajan <renjith at poornam.com>

Thanks Ralph ..I was not aware of this. Thank you very much for clearing my 
doubt.

On Thursday 20 July 2006 04:07 pm, Ralph Angenendt wrote:
> Renjith Rajan wrote:
> > Hi All,
> >
> >   I have two servers, one is centos 4.3 (new) and other is rh9 (old).
> > Both of them run mysql as the primary database server. I installed mysql
> > via the rpms available in mysql.com downloads.
> >
> >   Recently when i do "pstree", i noticed that RH9 server shows many mysql
> > children while centos shows only one. Here is the pstree result. (Both of
> > them runs the same version of mysql)
>
> Mysql uses threads and doesn't fork off several processes to do the
> work. Older kernels (or - the older threads version in Linux) show each
> thread as a new process with its own pid. Recent kernels and pstools
> just show the pid - so you're not able to see the threads mysql has
> spawned.
>
> You can see those threads with ps, using the "-m" option (show all
> threads):
>
> ps aux -m | grep mysql
>
> Regards,
>
> Ralph