Date: Wed, 12 Oct 2005 15:12:41 -0700 (PDT) From: NMH <drumslayer2@yahoo.com> To: Justin Bastedo <justin.bastedo@gmail.com> Cc: FreeBSD-DataBase <freebsd-database@freebsd.org>, questions <freebsd-questions@freebsd.org> Subject: Re: Mysql server not able to stay running on anything but Linux? Message-ID: <20051012221241.24236.qmail@web32913.mail.mud.yahoo.com> In-Reply-To: <8a5255240510121434k6c2c1028x646120b245343a0f@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--- Justin Bastedo <justin.bastedo@gmail.com> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20051012221241.24236.qmail>