***BOGO*** Re: multiple mysqld process? is this correct?

[Joerg Bruehe <joerg@xxxxxxxxx>]

Hi


Saravanan wrote:
> Hi all,
>
> I started the sql server with 5.0.51b but i suddenly noticed that mysqld is running with multiple process in top
>
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
> 26423 mysqld    17   0 2130m 1.2g 3908 R   58 30.0   0:11.86 mysqld
> 25843 mysqld    15   0 2130m 1.2g 3908 D   42 30.0   0:19.32 mysqld
> 26505 mysqld    16   0 2130m 1.2g 3908 S    2 30.0   0:00.05 mysqld
> [[ ... 15 other "mysqld" lines deleted ... ]]
> 26547 mysqld    15   0 2130m 1.2g 3908 S    0 30.0   0:00.01 mysqld
>     1 root      16   0  2288  548  472 S    0  0.0   0:27.28 init
>     2 root      RT   0     0    0    0 S    0  0.0   0:01.68 migration/0
>
>
> is this correct or false? pls let me know asap
>
> [[...]]

This is dependent on how your Linux kernel handles threading, and which 
MySQL package you installed.

The MySQL server runs multithreaded, and in older Linux versions such 
threads were displayed by "ps" like independent processes.
Only in newer versions, and when "NPTL" is used (not the older 
"linuxthread"), will the several threads be shown as a single process.


HTH,
Jörg

--
Joerg Bruehe,  MySQL Build Team,  joerg@xxxxxxxxx
Sun Microsystems GmbH,   Sonnenallee 1,   D-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering     Muenchen: HRB161028


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx