Date: Fri, 7 May 2010 19:54:25 +0200 From: =?iso-8859-1?Q?Eirik_=D8verby?= <ltning@anduin.net> To: Jason J. W. Williams <jasonjwwilliams@gmail.com> Cc: freebsd-current@freebsd.org Subject: Re: ZFS Stability & MySQL (Comments Requested) Message-ID: <AD390CF2-241E-496E-97A3-934BB53C1A3E@anduin.net> In-Reply-To: <u2q3b949f091004290731rd83bd474g9b7b2cacf5120b8@mail.gmail.com> References: <u2q3b949f091004290731rd83bd474g9b7b2cacf5120b8@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi, just chirping in; we've upgraded a bunch of old 6.x servers to 8.0 with = ZFS. This is a pair of HP DL385 G1s (dual opteron, old stuff) with = SmartArray controllers, which had absolutely horrible performance in = both 6.0 and 8.0. The drive array gave us ~25 mbyte/s sustained, which = is obviously abysmal for U320/15k SCSI drives backed by hardware RAID = and cache. We ended up splitting the hardware RAID into single drives, and using = ZFS/RaidZ. We suddenly got around 45 mbye/s (still bad) per channel, = adding up nicely when benchmarking the RaidZ volume. MySQL now performs much better than before, and we've enabled = compression (gzip-2) and fixed block sizes. Compression ratio is about = 1.7:1, transaction latency on the database (as seen from application) = has gone down by about 65% on average. We see anything between 300 and 2000 queries/second throughout the day, = and our active dataset is about 500GB. The servers have 8GB of memory. /Eirik On Apr 29, 2010, at 4:31 PM, Jason J. W. Williams wrote: > Hi Y'all, >=20 > I've written before that we're considering moving to FreeBSD 8 from > OpenSolaris and are heavily reliant on ZFS. Has anyone used FreeBSDs > ZFS implementation for a high reliability environment like a database? > If so, what are your experiences? >=20 > Basically, I'm curious how stable the implementation is and whether > it's ready for a critical production environment. Also, any gotchas > particularly with running it with MySQL or anything else that utilizes > a lot of memory. On Solaris, we cap the max ARC size to keep it from > grabbing all the system RAM and competing with MySQL. >=20 > Any thoughts or comments are greatly appreciated. >=20 > -J > _______________________________________________ > freebsd-current@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to = "freebsd-current-unsubscribe@freebsd.org" >=20
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?AD390CF2-241E-496E-97A3-934BB53C1A3E>