Re: [CentOS] only one mysql process in pstree

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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
-- 
Ralph Angenendt......ra@xxxxxxxxxxxx | .."Text processing has made it possible
Bayerischer Rundfunk...80300 München | ....to right-justify any idea, even one
Programmbereich.Bayern 3, Jugend und | .which cannot be justified on any other
Multimedia.........Tl:089.5900.16023 | ..........grounds." -- J. Finnegan, USC

Attachment: pgpG1zN32tv65.pgp
Description: PGP signature

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux