***BOGO*** mysql multiple processes

[Saravanan <suzuki_babu@xxxxxxxxx>]

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 error log  error log didnt show any error.

[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=royale@xxxxxxxxxx