From owner-freebsd-database@FreeBSD.ORG Wed Oct 12 22:12:42 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5E6BE16A443 for ; Wed, 12 Oct 2005 22:12:42 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: from web32913.mail.mud.yahoo.com (web32913.mail.mud.yahoo.com [68.142.206.60]) by mx1.FreeBSD.org (Postfix) with SMTP id A1C7C43D49 for ; Wed, 12 Oct 2005 22:12:41 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: (qmail 24238 invoked by uid 60001); 12 Oct 2005 22:12:41 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=MmVeEIfEG+z/7jGckhkhYvMJlkNogInInEyhl7tI41LGg+OL4Tj1puaoQ7ju5iMuYZCrrP4IFGHcC/Kw44vACiWuaegXXHJT8aLfLBBM/qsmb0puZRc7p8ub781meaft1FPOQVL0r9SwFe4k5/6tJhP5XvBlGmE1jLYofYlNo/g= ; Message-ID: <20051012221241.24236.qmail@web32913.mail.mud.yahoo.com> Received: from [67.112.21.27] by web32913.mail.mud.yahoo.com via HTTP; Wed, 12 Oct 2005 15:12:41 PDT Date: Wed, 12 Oct 2005 15:12:41 -0700 (PDT) From: NMH To: Justin Bastedo In-Reply-To: <8a5255240510121434k6c2c1028x646120b245343a0f@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Cc: FreeBSD-DataBase , questions Subject: Re: Mysql server not able to stay running on anything but Linux? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 12 Oct 2005 22:12:42 -0000 --- Justin Bastedo wrote: > 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:24:01 > 49 processes: 1 running, 48 sleeping > CPU states: 0.5% user, 0.0% nice, 0.5% system, > 0.0% interrupt, 99.0% idle > 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 you. > > 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 Hi Justin Right now here are our stats.. As you can see.. we beat it up pretty good. [MYSQL] Uptime: 174044 Threads: 396 Questions: 140154383 Slow queries: 16 Opens: 2622 Flush tables: 1 Open tables: 1189 Queries per second avg: 805.281 [FREEBSD TOP] (BSD 4.11-STABLE) last pid: 40914; load averages: 0.65, 0.69, 0.74 436 processes: 5 running, 431 sleeping CPU states: 0.5% user, 22.1% nice, 8.1% system, 0.4% interrupt, 69.4% idle Mem: 483M Active, 3046M Inact, 291M Wired, 136M Cache Buf, 6070K Free Swap: 8192M Total, 68K Used, 8192M Free NMH The Large Print Giveth And The Small Print Taketh Away -- Anon __________________________________ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs