From owner-freebsd-questions@FreeBSD.ORG Thu Jun 14 14:07:20 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 251AA106564A for ; Thu, 14 Jun 2012 14:07:20 +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 B46488FC14 for ; Thu, 14 Jun 2012 14:07:19 +0000 (UTC) Received: (qmail 93461 invoked by uid 110); 14 Jun 2012 14:07:18 -0000 Received: from ool-4571afe7.dyn.optonline.net (HELO desktop1) (simon@optinet.com@69.113.175.231) by cobra.acceleratedweb.net with SMTP; 14 Jun 2012 14:07:18 -0000 From: "Simon" To: "Paul Macdonald" Date: Thu, 14 Jun 2012 10:07:21 -0400 Priority: Normal X-Mailer: PMMail 2000 Professional (2.20.2717) For Windows 2000 (5.1.2600;3) In-Reply-To: <4FD99B0A.6050105@ifdnrg.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <20120614140720.251AA106564A@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: Thu, 14 Jun 2012 14:07:20 -0000 On Thu, 14 Jun 2012 09:04:26 +0100, Paul Macdonald wrote: >On 13/06/2012 19:34, Simon wrote: >> Hi, >> >> 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 >> >> Thank you! >> Simon >> >Its not clear if you upgraded mysql or just did a vanilla fresh install, >but assuming the former, >i take it you ran the mysql_upgrade script post upgrade? >/usr/ports/databases/mysqlXX-scripts No, I did not run the mysql_upgrade because this was a minor upgrade. I was running 5.0.88 Community Server binary install built by mysql developers rock solid for long time. Then I decided to upgrade to latest 5.0.x but there is no such build for FreeBSD by the MySQL developers. So I decided to give the ports version a shot. I compiled and installed databases/mysql50-server with BUILD_STATIC The latest mysql50-server under FBSD 8.3 is 5.0.95 BTW, I'm doing this on FreeBSD 8.3-p3 AMD64 PS I just had it die on a different machine that is less loaded and uses less memory. -Simon