***BOGO*** Re: Wrong PID

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

You can write a shell script to kill these threads one by one.

On Mon, Jun 30, 2008 at 9:43 AM, Marcin Polewski <marcin.polewski@xxxxxxxxx>
wrote:

> On my machine, I start the following command:
> /bin/sh /usr/local/bin/mysqld_safe
> --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
> --datadir=/var/db/mysql --pid-file=/var/db/mysql/zigzu.bixbots.com.pid
>
> For some reason my PID file does not contain the parent PID, instead it
> contains one the children's PID. So when I attempt to stop MySQL, it stops
> only one of the child mysqld processes and not all of them.
>
> For example, when mysqld_safe starts up, the following PIDs are running:
>
> 23349 mysqld_safe
> + 23378    mysqld
> + 23379    mysqld
> + 23380    mysqld
> + 23381    mysqld
> + 23382    mysqld
> + 23383    mysqld
> + 23385    mysqld
> + 23386    mysqld
> + 23387    mysqld
> + 23388    mysqld
> + 23389    mysqld
> + 23390    mysqld
> + 23391    mysqld
> + 23392    mysqld
> + 23431    mysqld
> + 23445    mysqld
> + 23567    mysqld
> + 24078    mysqld
>
> But the PID file will contain 23383 which is not the parent process.
>
> How can I resolve this?
>
> Thanks,
> --Marcin
>



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