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

[王旭 <wangxu@xxxxxxxxxxxxx>]

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
> 
>