From owner-freebsd-questions@FreeBSD.ORG Wed Oct 12 21:34:51 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org 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 4ECFB16A420 for ; Wed, 12 Oct 2005 21:34:51 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id D440B43D49 for ; Wed, 12 Oct 2005 21:34:50 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: by xproxy.gmail.com with SMTP id t12so138587wxc for ; Wed, 12 Oct 2005 14:34:50 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=IlhHSnYfcdEdvAnhJbxWSSxfzeygiu8ZxGjSRQbE6ZBRnZpkjQMJt7cVflAduShfXAeS+r1SBIDhYsmXwMlQsKZOrUf0EfSdGLdU6W5T1P12u12FBByOJEA26NcN/P9PUH+/EI+zcRA/p48qUjZ3tbAVDilScOtSi0E5xwHRpCg= Received: by 10.70.44.14 with SMTP id r14mr346198wxr; Wed, 12 Oct 2005 14:34:50 -0700 (PDT) Received: by 10.70.35.7 with HTTP; Wed, 12 Oct 2005 14:34:50 -0700 (PDT) Message-ID: <8a5255240510121434k6c2c1028x646120b245343a0f@mail.gmail.com> Date: Wed, 12 Oct 2005 14:34:50 -0700 From: Justin Bastedo To: NMH In-Reply-To: <20051012201622.49704.qmail@web32905.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20051012201622.49704.qmail@web32905.mail.mud.yahoo.com> Cc: FreeBSD-DataBase , questions Subject: Re: Mysql server not able to stay running on anything but Linux? 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, 12 Oct 2005 21:34:51 -0000 Here at my work we are running a mysql 5.0 server on FreeBSD 5.4 using the AMD Dual Core 64 chips. current load is as follows: [MYSQL] Uptime: 1338832 Threads: 2 Questions: 15846788 Slow queries: 0 Opens: 0 Flush tables: 16 Open tables: 58 Queries per second avg: 11.836 [FREEBSD TOP] last pid: 29924; load averages: 0.00, 0.00, 0.00 up 35+01:59:20 16:2= 4:01 49 processes: 1 running, 48 sleeping CPU states: 0.5% user, 0.0% nice, 0.5% system, 0.0% interrupt, 99.0% id= le Mem: 156M Active, 1250M Inact, 176M Wired, 214M Buf, 2086M Free Swap: 2048M Total, 44K Used, 2048M Free Versions: >mysql -V mysql Ver 14.12 Distrib 5.0.12-beta, for portbld-freebsd5.4 (amd64) using = 4.3 >uname -a FreeBSD db 5.4-RELEASE-p7 FreeBSD 5.4-RELEASE-p7 #0: Wed Sep 7 14:12:34 CDT 2005 user@db:/usr/obj/usr/src/sys/BLITZ4SMP amd64 Our queries per second avg has been going up consistently and we have yet to have any problems. We haven't had any crashing though I can't quite say how the thread level is comparing to yours. I agree i would look into upgrading to 5.4-STABLE and see how that treats y= ou. As far as my experience the only real advantages I've found that linux has over FreeBSD is the type of file systems. Some of the file systems they support may give better performance to particular types of table types, but that is more if you have a stable db server that is hitting a bottle neck. -- Justin Bastedo At Gmail Dot Com