lists.zerezo.com
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
***BOGO*** Re: multiple mysqld process? is this correct?
- Date: Sun, 25 May 2008 23:50:12 -0700 (PDT)
- From: Saravanan <suzuki_babu@xxxxxxxxx>
- Subject: ***BOGO*** Re: multiple mysqld process? is this correct?
Hi,
I have stopped the new version 5.0.51b and started with the old version. But i had taken the ps output previously
check the following
[root@hp-1 data]# ps aux | grep mysql
502 14888 0.0 0.0 6372 2020 pts/3 S+ May25 0:00 /usr/local/mysql/bin/mysql -uroot -p --protocol=tcp --port=3306
root 23379 0.0 0.0 6016 1092 pts/4 S 01:13 0:00 /bin/sh /usr/local/mysql-5.0.51b/bin/mysqld_safe --defaults-file=/hp/mysql/my2.cnf
mysqld 23410 0.0 39.3 2181204 1632220 pts/4 S 01:13 0:01 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 23411 0.1 39.3 2181204 1632220 pts/4 S 01:13 0:01 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 23412 0.0 39.3 2181204 1632220 pts/4 S 01:13 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 23413 0.0 39.3 2181204 1632220 pts/4 S 01:13 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 23414 0.1 39.3 2177104 1631308 pts/4 S 01:13 0:02 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 23415 0.0 39.3 2177104 1631308 pts/4 S 01:13 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 23417 0.0 39.3 2177104 1631308 pts/4 S 01:13 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 23418 0.0 39.3 2177104 1631308 pts/4 S 01:13 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 23419 0.0 39.3 2177104 1631308 pts/4 S 01:13 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 23420 0.0 39.3 2177104 1631308 pts/4 S 01:13 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
502 23501 0.0 0.0 7840 1824 pts/0 S+ 01:13 0:00 /usr/local/mysql-5.0.51b/bin/mysql -uroot -p --protocol=tcp --port=3306
mysqld 23524 0.0 39.3 2177104 1631308 pts/4 S 01:13 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 27180 0.0 39.3 2177104 1631308 pts/4 S 01:28 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29773 10.4 39.3 2177104 1631308 pts/4 S 01:37 0:07 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29794 0.3 39.3 2177104 1631308 pts/4 S 01:37 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29843 0.4 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29850 0.3 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29869 0.3 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29901 0.5 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29907 0.6 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29915 0.2 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29917 0.3 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29919 0.4 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29931 0.4 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29939 0.2 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29943 0.3 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29946 0.3 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29951 0.3 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29971 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29972 0.3 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29974 0.5 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29976 0.4 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29983 0.2 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29985 0.3 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29991 0.3 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 29993 0.2 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30000 0.2 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30002 0.1 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30003 0.1 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30004 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30007 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30008 0.2 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30009 0.2 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30012 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30013 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30014 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30015 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30016 0.3 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30019 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30022 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30023 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30025 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30026 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30027 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30028 0.0 39.3 2177104 1631308 pts/4 hpS 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30029 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
root 30031 0.0 0.0 3652 660 pts/4 S+ 01:38 0:00 grep mysql
mysqld 30032 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
mysqld 30033 0.0 39.3 2177104 1631308 pts/4 S 01:38 0:00 /usr/local/mysql-5.0.51b/libexec/mysqld --defaults-file=/hp/mysql/my2.cnf --basedir=/usr/local/mysql-5.0.51b/ --datadir=/hp/mysql/data --user=mysqld --pid-file=/hp/mysql/mysqld.pid --skip-external-locking --port=3306
Thanks,
Saravanan
--- On Mon, 5/26/08, Saravanan <suzuki_babu@xxxxxxxxx> wrote:
> From: Saravanan <suzuki_babu@xxxxxxxxx>
> Subject: Re: multiple mysqld process? is this correct?
> To: mysql-return-213018-wangxu=itec.com.cn@xxxxxxxxxxxxxxx, "mysql" <mysql@xxxxxxxxxxxxxxx>, wangxu@xxxxxxxxxxxxx
> Date: Monday, May 26, 2008, 12:32 PM
> 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=suzuki_babu@xxxxxxxxx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx