From owner-freebsd-questions@FreeBSD.ORG Wed Jun 13 18:43:25 2012 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (unknown [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9D406106578B for ; Wed, 13 Jun 2012 18:43:25 +0000 (UTC) (envelope-from simon@optinet.com) Received: from cobra.acceleratedweb.net (cobra-gw.acceleratedweb.net [207.99.79.37]) by mx1.freebsd.org (Postfix) with SMTP id 27A318FC14 for ; Wed, 13 Jun 2012 18:43:25 +0000 (UTC) Received: (qmail 16876 invoked by uid 110); 13 Jun 2012 18:43:24 -0000 Received: from ool-4571afe7.dyn.optonline.net (HELO desktop1) (simon@optinet.com@69.113.175.231) by cobra.acceleratedweb.net with SMTP; 13 Jun 2012 18:43:24 -0000 From: "Simon" To: "Chuck Swiger" Date: Wed, 13 Jun 2012 14:43:29 -0400 Priority: Normal X-Mailer: PMMail 2000 Professional (2.20.2717) For Windows 2000 (5.1.2600;3) In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <20120613184325.9D406106578B@hub.freebsd.org> Cc: "freebsd-questions@freebsd.org" Subject: Re: FreeBSD 8.3 + MySQL 5.0.95 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 13 Jun 2012 18:43:25 -0000 Possible but extremely unlikely, I always had issues whenever I tried to build MySQL server myself. The hardware where this is running has been very stable. I don't have any issues whatsoever making world, etc... There is no segfault which is what usually happens when you have memory issues. And why would MySQL community server run stable if it was somehow my hardware? Bottom line, if this was hardware issue, the server would have paniced long ago. I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. -Simon On Wed, 13 Jun 2012 11:36:48 -0700, Chuck Swiger wrote: >On Jun 13, 2012, at 11:34 AM, Simon wrote: >> I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. >> >> It runs fine until it dies silently. Does anyone run a heavy loaded MySQL >> under such setup? how can I troubleshoot this? >> >> I could never compile a stable MySQL server from the ports and always >> relied on MySQL community server binaries but there is no binary for >> latest 5.0.xx >This sounds like marginal hardware which is failing under load. Make >sure you can run something like memtest86 or prime95 overnight without >errors.... >Regards, >-- >-Chuck