From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.43) id 1EAm4I-0004C8-BC for garchives@archives.gentoo.org; Thu, 01 Sep 2005 10:13:15 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.4/8.13.4) with SMTP id j81A9wWt019172; Thu, 1 Sep 2005 10:09:58 GMT Received: from mail.pnpitalia.it (85-18-21-122.ip.fastwebnet.it [85.18.21.122]) by robin.gentoo.org (8.13.4/8.13.4) with ESMTP id j81A6QHD023795 for ; Thu, 1 Sep 2005 10:06:26 GMT Received: from localhost (localhost [127.0.0.1]) by mail.pnpitalia.it (Postfix) with ESMTP id 84C027AD6F8 for ; Thu, 1 Sep 2005 12:08:52 +0200 (CEST) Received: from mail.pnpitalia.it ([127.0.0.1]) by localhost (db [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24001-03 for ; Thu, 1 Sep 2005 12:08:52 +0200 (CEST) Received: from [192.168.4.153] (host-4-153.pnpitalia.it [192.168.4.153]) by mail.pnpitalia.it (Postfix) with ESMTP id 1730A7AD6F6 for ; Thu, 1 Sep 2005 12:08:52 +0200 (CEST) Message-ID: <4316D205.1070108@pnpitalia.it> Date: Thu, 01 Sep 2005 12:03:49 +0200 From: Bastian Balthazar Bux User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] Trouble with mysql References: <1125521529.11373.9.camel@baby.espersunited.com> <43162307.7030701@igoe.me.uk> <1125525169.11368.17.camel@baby.espersunited.com> <4316376D.10806@iriswick.game-host.org> <1125535194.9939.1.camel@baby.espersunited.com> In-Reply-To: <1125535194.9939.1.camel@baby.espersunited.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at db X-Archives-Salt: 9a4f0c21-2f18-4b5e-bd14-a363db4e1d2c X-Archives-Hash: cbd62b9cb5c8e9786e3b9df525ffd1b8 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