Date: Sat, 1 Dec 2007 12:22:34 -1000 (HST) From: Jeff Roberson <jroberson@chesapeake.net> To: Gergely CZUCZY <phoemix@harmless.hu> Cc: freebsd-performance@freebsd.org, Mike Tancsa <mike@sentex.net> Subject: Re: mysql scaling questions Message-ID: <20071201122122.S884@192.168.1.107> In-Reply-To: <20071201211012.GA55519@harmless.hu> References: <20071129101729.GA57985@harmless.hu> <20071130143023.I884@192.168.1.107> <20071201163334.GA21709@harmless.hu> <200712012055.lB1Kt5IQ005728@lava.sentex.ca> <20071201205609.GA54238@harmless.hu> <200712012108.lB1L8qAd005766@lava.sentex.ca> <20071201211012.GA55519@harmless.hu>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sat, 1 Dec 2007, Gergely CZUCZY wrote: > On Sat, Dec 01, 2007 at 04:06:55PM -0500, Mike Tancsa wrote: >> At 03:56 PM 12/1/2007, Gergely CZUCZY wrote: >>> I don't quite understand the question. It's the very same box, with >>> a dualboot configuration. >> >> Fire up the 3ware controller's RAID management software and make sure the same write caching strategy is set for FreeBSD and Linux. The >> driver my default to different values. >> >> i.e. under "controller settings" make sure "write cache" and "queuing" are the same values for linux and freebsd. > Let's get back to this on monday. I'm at home now, and the > box is at me workplace, still running a test (i can't reboot it). Also, can you verify with a read-only test to see where it's at? I have not tested writes with that many threads. I notice mysql goes much faster with a fresh table too. So can you blow away and recreate the sysbench tables and then do read-only? If that is much slower we'll know there is some configuration problem or similar. Thanks, Jeff > > Sincerely, > > Gergely Czuczy > mailto: gergely.czuczy@harmless.hu > > -- > Weenies test. Geniuses solve problems that arise. >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071201122122.S884>