From owner-freebsd-stable@FreeBSD.ORG Wed Jun 9 06:30:48 2004 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4F08016A4CE for ; Wed, 9 Jun 2004 06:30:48 +0000 (GMT) Received: from xraided.net (xraided.net [66.88.26.15]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2F96E43D60 for ; Wed, 9 Jun 2004 06:30:48 +0000 (GMT) (envelope-from kyle@xraided.net) Received: from [66.88.29.118] (account kyle HELO kyle) by xraided.net (CommuniGate Pro SMTP 4.1.8) with ESMTP id 1730731 for freebsd-stable@freebsd.org; Tue, 08 Jun 2004 23:30:46 -0700 From: "Kyle Mott" To: Date: Tue, 8 Jun 2004 23:30:43 -0700 Message-ID: <000301c44deb$4a78f1b0$1414a8c0@kyle> MIME-Version: 1.0 X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.1 Subject: Mysql Problems X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Jun 2004 06:30:48 -0000 I've now done buildworld twice, to no avail; for some reason, every 1-3 minutes a new mysql process is started, for which looks like no apparent reason. Mysql on this machine is used very rarely, though it does get checked by Nagios regularly. I've had a tough time finding any logs for mysql, which ended up being in /var/db/mysql but they didn't tell me anything of relevance (that I can see). I built mysql with linuxthreads, and I'm using my-small.cnf, not sure if they could be contributing to the odd behavior. I've also tried rebuilding the port (/usr/ports/databases/mysql40-server/) several times, which didn't seem to make a difference. Right now, after being up for 15 minutes, there's 55 mysql processes (when there's normally < 15). When I run 'top', it says the state for most of the mysql processes is 'pause', and they are taking very little resources (thank god). The only other thing I have done is move /var/db to /usr/db, and then 'ln -s /usr/db /var/db', but everything else seems to be fine (locate, pgsql, nut, etc.). I thought permissions might have been wrong, because /var/db/mysql was 0700, so I made it 0755, which didn't change anything. Any suggestions? I have 2 other systems that I need to update fairly soon, but I'm afraid to if this is going to happen. :< -Kyle Mott