Gentoo Archives: gentoo-user

From: Bastian Balthazar Bux <BastianBalthazarBux@×××××××××.it>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] Trouble with mysql
Date: Thu, 01 Sep 2005 10:13:15
Message-Id: 4316D205.1070108@pnpitalia.it
In Reply to: Re: [gentoo-user] Trouble with mysql by Michael Sullivan
1 Michael Sullivan wrote:
2 > On Wed, 2005-08-31 at 18:04 -0500, Paul Maszy wrote:
3 >
4 >> You shouldnt have restarted.
5 >>
6 >> mysql is already starting on boot up. It showing that many mysql
7 >>daemons is normal and ok.
8 >>
9 [snip]
10 >
11 >
12 > I ran /etc/init.d/mysql stop and it stopped without error - all of them.
13 > I ran /etc/init.d/mysql start and it started again - now there are a
14 > whole lot of them in the ps listing, but I can connect with the mysql
15 > client. It seems to be fixed for now..
16 >
17 >
18 Just in case doubts are still there look at the output of "ps fax" that
19 show a tree of processes:
20
21 breakall # ps fax | grep mysql
22 30560 pts/0 S+ 0:00 \_ grep mysql
23 7504 ? Ss 0:00 /bin/sh /usr/bin/mysqld_safe [...]
24 7542 ? S 0:00 \_ /usr/sbin/mysqld --defaul[...]ck
25 7543 ? S 0:00 \_ /usr/sbin/mysqld --de[...]d.sock
26 7544 ? S 0:00 \_ /usr/sbin/mysqld [...]ysqld.sock
27 7545 ? S 0:00 \_ /usr/sbin/mysqld [...]ysqld.sock
28 [.....................................................................]
29 7565 ? S 0:00 \_ /usr/sbin/mysqld [...]ysqld.sock
30 7583 ? S 0:02 \_ /usr/sbin/mysqld [...]ysqld.sock
31
32 there is "mysqld_safe" that is a shell script, it's only a wrapper
33 around "mysqld" the real daemon.
34 mysql is a threaded application, and ps show all it's threads.
35
36 Just a hint, try to *avoid* "kill -9" and use a simply "kill" or "pkill"
37 if it's possible.
38
39 ah maybe that on other system you can't see all the threads with "ps",
40 that's nothing to worry about, probably that box is using "nptl" .
41
42 Ciao
43 --
44 gentoo-user@g.o mailing list