Re: [gentoo-user] Trouble with mysql

[Bastian Balthazar Bux <BastianBalthazarBux@pnpitalia.it>]

Michael Sullivan wrote:
> On Wed, 2005-08-31 at 18:04 -0500, Paul Maszy wrote:
> 
>>    You shouldnt have restarted. 
>>
>>    mysql is already starting on boot up. It showing that many mysql
>>daemons is normal and ok. 
>>
[snip]
> 
> 
> I ran /etc/init.d/mysql stop and it stopped without error - all of them.
> I ran /etc/init.d/mysql start and it started again - now there are a
> whole lot of them in the ps listing, but I can connect with the mysql
> client.  It seems to be fixed for now..
> 
> 
Just in case doubts are still there look at the output of "ps fax" that
show a tree of processes:

breakall # ps fax | grep mysql
30560 pts/0    S+     0:00          \_ grep mysql
 7504 ?        Ss     0:00 /bin/sh /usr/bin/mysqld_safe [...]
 7542 ?        S      0:00  \_ /usr/sbin/mysqld --defaul[...]ck
 7543 ?        S      0:00      \_ /usr/sbin/mysqld --de[...]d.sock
 7544 ?        S      0:00          \_ /usr/sbin/mysqld [...]ysqld.sock
 7545 ?        S      0:00          \_ /usr/sbin/mysqld [...]ysqld.sock
[.....................................................................]
 7565 ?        S      0:00          \_ /usr/sbin/mysqld [...]ysqld.sock
 7583 ?        S      0:02          \_ /usr/sbin/mysqld [...]ysqld.sock

there is "mysqld_safe" that is a shell script, it's only a wrapper
around "mysqld" the real daemon.
mysql is a threaded application, and ps show all it's threads.

Just a hint, try to *avoid* "kill -9" and use a simply "kill" or "pkill"
if it's possible.

ah maybe that on other system you can't see all the threads with "ps",
that's nothing to worry about, probably that box is using "nptl" .

Ciao
-- 
gentoo-user@gentoo.org mailing list