You can write a shell script to kill these threads one by one. On Mon, Jun 30, 2008 at 9:43 AM, Marcin Polewski <[EMAIL PROTECTED]> 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