Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 14 Jun 2012 10:07:21 -0400
From:      "Simon" <simon@optinet.com>
To:        "Paul Macdonald" <paul@ifdnrg.com>
Cc:        "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org>
Subject:   Re: FreeBSD 8.3 + MySQL 5.0.95
Message-ID:  <20120614140720.251AA106564A@hub.freebsd.org>
In-Reply-To: <4FD99B0A.6050105@ifdnrg.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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








Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20120614140720.251AA106564A>