lists.zerezo.com



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

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



yes I can connect to the server. And it is not showing any error with that. It is updating and inserting too.

Saravanan



--- On Mon, 5/26/08, 王旭 <wangxu@xxxxxxxxxxxxx> wrote:

> From: 王旭 <wangxu@xxxxxxxxxxxxx>
> Subject: Re: multiple mysqld process? is this correct?
> To: mysql-return-213018-wangxu=itec.com.cn@xxxxxxxxxxxxxxx, suzuki_babu@xxxxxxxxx, "mysql" <mysql@xxxxxxxxxxxxxxx>
> Date: Monday, May 26, 2008, 12:30 PM
> Can you accessing database with command line tool now?
> 
> ----- Original Message ----- 
> From: "Saravanan" <suzuki_babu@xxxxxxxxx>
> To: "mysql" <mysql@xxxxxxxxxxxxxxx>
> Sent: Monday, May 26, 2008 1:30 PM
> Subject: multiple mysqld process? is this correct?
> 
> 
> > 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
> > 26397 mysqld    16   0 2130m 1.2g 3908 S    1 30.0  
> 0:00.19 mysqld
> > 26514 mysqld    15   0 2130m 1.2g 3908 S    1 30.0  
> 0:00.06 mysqld
> > 26526 mysqld    15   0 2130m 1.2g 3908 S    1 30.0  
> 0:00.06 mysqld
> > 23411 mysqld    17   0 2130m 1.2g 3908 S    1 30.0  
> 0:00.79 mysqld
> > 26065 root      16   0  2172 1012  760 R    1  0.0  
> 0:00.27 top
> > 26289 mysqld    16   0 2130m 1.2g 3908 S    1 30.0  
> 0:00.35 mysqld
> > 26304 mysqld    16   0 2130m 1.2g 3908 S    1 30.0  
> 0:00.13 mysqld
> > 26340 mysqld    16   0 2130m 1.2g 3908 S    0 30.0  
> 0:00.19 mysqld
> > 26432 mysqld    16   0 2130m 1.2g 3908 S    0 30.0  
> 0:00.07 mysqld
> > 26493 mysqld    16   0 2130m 1.2g 3908 S    0 30.0  
> 0:00.06 mysqld
> > 26494 mysqld    16   0 2130m 1.2g 3908 S    0 30.0  
> 0:00.09 mysqld
> > 26508 mysqld    16   0 2130m 1.2g 3908 S    0 30.0  
> 0:00.04 mysqld
> > 26515 mysqld    16   0 2130m 1.2g 3908 S    0 30.0  
> 0:00.01 mysqld
> > 26517 mysqld    16   0 2130m 1.2g 3908 S    0 30.0  
> 0:00.06 mysqld
> > 26525 mysqld    15   0 2130m 1.2g 3908 S    0 30.0  
> 0:00.02 mysqld
> > 26529 mysqld    15   0 2130m 1.2g 3908 D    0 30.0  
> 0:00.03 mysqld
> > 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
> > 
> > the server is running in 32 bit centos only.
> > 
> > and following is the netstat output
> > 
> > [data]# tail hp.com.err
> > but it should contain at least 475 error messages.
> > Check that the above file is the right version for
> this program!
> > 080526  1:10:30 [ERROR] Aborting
> > 
> > 080526 01:10:30  mysqld ended
> > 
> > 080526 01:13:28  mysqld started
> > 080526  1:13:30  InnoDB: Started; log sequence number
> 28 2316892628
> > 080526  1:13:30 [Note]
> /usr/local/mysql-5.0.51b/libexec/mysqld: ready for
> connections.
> > Version: '5.0.51b-log'  socket:
> '/tmp/mysql.sock'  port: 3306  Source distribution
> > [data]# netstat -ntlp | grep mysql
> > tcp        0      0 0.0.0.0:3306               
> 0.0.0.0:*                   LISTEN      23410/mysqld
> > 
> > thanks,
> > Saravanan
> > 
> > 
> >      
> > 
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:   
> http://lists.mysql.com/mysql?unsub=wangxu@xxxxxxxxxxx
> > 
> >




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