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

["Moon's Father" <yueliangdao0608@xxxxxxxxx>]

Maybe you compile mysql with statistic.

On Tue, May 27, 2008 at 12:58 PM, Krishna Chandra Prajapati <
prajapatikc@xxxxxxxxx> wrote:

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



-- 
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn