Re: multiple mysqld process? is this correct?

[Saravanan <suzuki_babu@xxxxxxxxx>]

Hi jorg,

wont this(running as multiple process) create any big problem with production datas? But it didnt show any error or warnings in mysql err log file. 

compiled in one machine with the following config details


hostname = dizz.hp.com
uname -m = i686
uname -r = 2.6.9-42.0.10.EL
uname -s = Linux
uname -v = #1 Tue Feb 27 09:24:42 EST 2007

/usr/bin/uname -p = unknown
/bin/uname -X     = unknown

/bin/arch              = i686  
/usr/bin/arch -k       = unknown


but my uname show different values. So this time I compiled within the same machine where we are going to install. following are the correct config details

hostname = hp1.hp.com
uname -m = i686
uname -r = 2.6.9-42.0.10.ELsmp
uname -s = Linux
uname -v = #1 SMP Tue Feb 27 10:11:19 EST 2007

/usr/bin/uname -p = unknown
/bin/uname -X     = unknown

/bin/arch              = i686
/usr/bin/arch -k       = unknown

Not yet checked the server with the new compilations.

Thanks,
Saravanan


--- On Mon, 5/26/08, Joerg Bruehe <joerg@xxxxxxxxx> wrote:

> From: Joerg Bruehe <joerg@xxxxxxxxx>
> Subject: Re: multiple mysqld process? is this correct?
> To: suzuki_babu@xxxxxxxxx
> Cc: "mysql" <mysql@xxxxxxxxxxxxxxx>
> Date: Monday, May 26, 2008, 7:30 PM
> 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=suzuki_babu@xxxxxxxxx

Thank you,
Saravanan




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