From owner-freebsd-questions@FreeBSD.ORG Sat Feb 28 21:35:01 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 97E5516A4CE for ; Sat, 28 Feb 2004 21:35:01 -0800 (PST) Received: from watcher.puryear-it.com (unknown [69.2.39.107]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6481B43D2D for ; Sat, 28 Feb 2004 21:35:01 -0800 (PST) (envelope-from dap99@i-55.com) Received: from localhost (unknown [127.0.0.1]) by watcher.puryear-it.com (Postfix) with ESMTP id 0D30934D35 for ; Sat, 28 Feb 2004 23:29:03 -0600 (CST) Received: from watcher.puryear-it.com ([127.0.0.1]) by localhost (watcher.puryear-it.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23356-03 for ; Sat, 28 Feb 2004 23:29:01 -0600 (CST) Received: from yourqqh4336axf (localhost [127.0.0.1]) by watcher.puryear-it.com (Postfix) with SMTP id 509CA34D1E for ; Sat, 28 Feb 2004 23:29:01 -0600 (CST) Message-ID: <055201c3fe85$b3cda490$6401a8c0@yourqqh4336axf> From: "dap" To: Date: Sat, 28 Feb 2004 23:33:46 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 X-Virus-Scanned: by amavisd-new Subject: MySQL and FreeBSD 4.x.. problems, problems with server X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 29 Feb 2004 05:35:01 -0000 This has happened with enough servers at different locations that I have to believe there is a relationship here. I have servers running the latest release of MySQL. I've run the servers on FreeBSD 4.4., 4.7, and 4.8. I am not using the threaded version. On all three versions, on different servers at different sites, I have seen MySQL just go wacky after a while. Two types of symptoms: 1. mysqld just decides to consume as much of the CPU as possible. 2. new connections to mysql fail It will usually take 1-3 weeks between occurances. I have seen posts relating to this off and on. Is there a known problem with running mysqld on FreeBSD 4.x? What about 5.x? Is it better? I was talking to another FreeBSD admin the other day and he commented on the same thing: "mysqld on our FreeBSD 4.7 boxes just lose it sometimes." Honestly, I am thinking of converting out MySQL db servers from FreeBSD to Linux for this reason, and only this reason. Otherwise, I love FreeBSD, but this is just no good. I would blame myself, but I can't when I get wind that others are having the same problem. Yes, this is a mysql problem probably, and not a FreeBSD problem. However, I'm hoping to get some help or hope here as well as with the mysql people. :)