***BOGO*** Re: mysql multiple processes

["Krishna Chandra Prajapati" <prajapatikc@xxxxxxxxx>]

Please tell me th OS and mysql installation ( rpm or source)

On Tue, May 27, 2008 at 12:31 AM, Saravanan <suzuki_babu@xxxxxxxxx> 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
> 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=prajapatikc@xxxxxxxxx
>
>


-- 
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road, Secunderabad.
Pin Code: 500003
Office Number: 040-66489771
Mob: 9912924044
URL: ed-ventures-online.com
Email-id: prajapatikc@xxxxxxxxx