lists.zerezo.com
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
***BOGO*** Re: multiple mysqld process? is this correct?
- Date: Mon, 26 May 2008 15:13:53 +0800
- From: 王旭 <wangxu@xxxxxxxxxxxxx>
- Subject: ***BOGO*** Re: multiple mysqld process? is this correct?
There maybe some problem.
Do the follow:
one,Stop all mysql server.
two, execute "ps aux | grep mysql".
If there are any mysql process ,i think you should kill them.
This problem often occur when mysql start with mysql already started.
So, Check your way of mysql's beginning is right.
----- Original Message -----
From: "Saravanan" <suzuki_babu@xxxxxxxxx>
To: <mysql-return-213018-wangxu=itec.com.cn@xxxxxxxxxxxxxxx>; "mysql" <mysql@xxxxxxxxxxxxxxx>; <wangxu@xxxxxxxxxxxxx>
Sent: Monday, May 26, 2008 2:50 PM
Subject: 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