Date: Wed, 12 Oct 2005 14:34:50 -0700 From: Justin Bastedo <justin.bastedo@gmail.com> To: NMH <drumslayer2@yahoo.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: <8a5255240510121434k6c2c1028x646120b245343a0f@mail.gmail.com> In-Reply-To: <20051012201622.49704.qmail@web32905.mail.mud.yahoo.com> References: <20051012201622.49704.qmail@web32905.mail.mud.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?8a5255240510121434k6c2c1028x646120b245343a0f>