Date: Thu, 29 Apr 2010 16:48:09 +0200 From: Olivier Smedts <olivier@gid0.org> To: "Jason J. W. Williams" <jasonjwwilliams@gmail.com> Cc: freebsd-current@freebsd.org Subject: Re: ZFS Stability & MySQL (Comments Requested) Message-ID: <s2i367b2c981004290748y169b918eu402217cfa668b949@mail.gmail.com> In-Reply-To: <u2q3b949f091004290731rd83bd474g9b7b2cacf5120b8@mail.gmail.com> References: <u2q3b949f091004290731rd83bd474g9b7b2cacf5120b8@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
2010/4/29 Jason J. W. Williams <jasonjwwilliams@gmail.com>: > Hi Y'all, > > 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? > > 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. > > Any thoughts or comments are greatly appreciated. No experience with databases on ZFS but I think you should set the recordsize property to a proper (I mean, for your MySQL setup) value on the FS that will hold the data. Have a look at : http://www.solarisinternals.com/wiki/index.php/ZFS_for_Databases Cheers > > -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" > -- Olivier Smedts _ ASCII ribbon campaign ( ) e-mail: olivier@gid0.org - against HTML email & vCards X www: http://www.gid0.org - against proprietary attachments / \ "Il y a seulement 10 sortes de gens dans le monde : ceux qui comprennent le binaire, et ceux qui ne le comprennent pas."
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?s2i367b2c981004290748y169b918eu402217cfa668b949>