Date: Sun, 30 Dec 2007 14:18:31 +0100 From: Kris Kennaway <kris@FreeBSD.org> To: Gergely CZUCZY <phoemix@harmless.hu> Cc: Jeff Roberson <jroberson@chesapeake.net>, freebsd-performance@freebsd.org Subject: Re: mysql scaling questions Message-ID: <47779AA7.2060801@FreeBSD.org> In-Reply-To: <20071204130810.GA77186@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> <20071201122122.S884@192.168.1.107> <20071204130810.GA77186@harmless.hu>
next in thread | previous in thread | raw e-mail | index | archive | help
Gergely CZUCZY wrote: > On Sat, Dec 01, 2007 at 12:22:34PM -1000, Jeff Roberson wrote: >> 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. > It will all be available here: > http://phoemix.harmless.hu/mysql/ Hi, Sorry for the late reply, I was on vacation. I have a couple of comments about this: * You are using some very old mysql versions and trying to compare between diferent versions. New minor releases in the 5.0 series had very different performance, and you really need to be using at least 5.0.45 (I didn't notice a performance change between 5.0.45 and 5.0.51 but there was a big improvement in every release up to .45. In addition, versions older than (I think) .37 have serious performance bugs). I appreciate that you might be constrained by local requirements, but it's really not meaningful to compare different mysql versions if your goal is to study OS performance. * What database engine are you using? I have only tested with innodb but maybe you are using myisam? Please provide your exact sysbench command lines. * Compare to my config file here: http://people.freebsd.org/~kris/scaling/my.cnf The default mysql config has very poor performance for innodb (you need at least innodb_thread_concurrency = 0 to disable some mysql brain-death). Maybe tuning is required for myisam also. * Also make sure you are using identical config settings on the two systems. * With the above, please compare read-only mode also (I think Jeff already asked you about this but I didnt see a reply). That will allow us to calibrate what is going on. Kris
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?47779AA7.2060801>