Date: Sun, 30 Dec 2007 14:24:51 +0100 From: Gergely CZUCZY <phoemix@harmless.hu> To: Kris Kennaway <kris@FreeBSD.org> Cc: Jeff Roberson <jroberson@chesapeake.net>, freebsd-performance@freebsd.org Subject: Re: mysql scaling questions Message-ID: <20071230132451.GA61295@harmless.hu> In-Reply-To: <47779AA7.2060801@FreeBSD.org> 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> <47779AA7.2060801@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
--yrj/dFKFPuw6o+aM Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, Dec 30, 2007 at 02:18:31PM +0100, Kris Kennaway wrote: > 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.=20 > >>>>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 hav= e not tested writes with that many threads. I notice mysql=20 > >>goes much faster with a fresh table too. So can you blow away and recr= eate the sysbench tables and then do read-only? If that is=20 > >>much slower we'll know there is some configuration problem or similar. > >It will all be available here: > >http://phoemix.harmless.hu/mysql/ >=20 > Hi, >=20 > Sorry for the late reply, I was on vacation. I have a couple of comments= about this: >=20 > * You are using some very old mysql versions and trying to compare betwee= n diferent versions. New minor releases in the 5.0 series had=20 > 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=20 > 5.0.51 but there was a big improvement in every release up to .45. In ad= dition, versions older than (I think) .37 have serious=20 > performance bugs). >=20 > I appreciate that you might be constrained by local requirements, but it'= s really not meaningful to compare different mysql versions if=20 > your goal is to study OS performance. It'd be a PITA to install the both versions. Maybe now, that the ports free= ze is over, i can do something. But honestly, every mysql version was faster on linux, than e= ny on FreeBSD, even the .22 one was faster. We start work on Jan02, I will see what can I = do. >=20 > * What database engine are you using? I have only tested with innodb but= maybe you are using myisam? Please provide your exact=20 > sysbench command lines. MyISAM, of course. InnoDB is not any good with replication, and we need bac= kup. > * Compare to my config file here: >=20 > http://people.freebsd.org/~kris/scaling/my.cnf >=20 > The default mysql config has very poor performance for innodb (you need a= t least innodb_thread_concurrency =3D 0 to disable some mysql=20 > brain-death). Maybe tuning is required for myisam also. >=20 > * Also make sure you are using identical config settings on the two syste= ms. http://phoemix.harmless.hu/mysql/ verify yourself. Only the paths are updated, but the main parameters are just the same. > * With the above, please compare read-only mode also (I think Jeff alread= y asked you about this but I didnt see a reply). That will=20 > allow us to calibrate what is going on. http://phoemix.harmless.hu/mysql/ro-all.png The graph is mistitled as Read-write, but it's a readonly test. Sincerely, Gergely Czuczy mailto: gergely.czuczy@harmless.hu --=20 Weenies test. Geniuses solve problems that arise. --yrj/dFKFPuw6o+aM Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) owGFV8+PHEcVNokSiZaCFA5wLa1AayczvTOzP+JMNGvWu8TZJIut7MKScLCqu6u7 i+2ualdVz2z7wBEhwQEhDkgGFIkTBwQH/g4O/AVIXPgHuPO9qu6ZMVJkS7Znuqte fe+97/teza/fev3Oa2//429//8m7v/rNi6/95RunyTt165wqxjU3S6nG08lkOj6a zt4/HB+N35/l9w8ns6P8KEnupwePVr/fOdXKCeXGV10j5syJW7fXVFyqD1hacmOF W7QuH9+PhnVn0jbaSie1mjOpKqnE+t2V4crmwoy/r1KdSVXM2bNWO5GNGyOV40kl ouixYpetGrEzkbL9yYjNJpP3GHdsMptP78/3p08u2LsToB6xT4y07BOhFF/xjq0M Is2jY/ZImEJUHTv94oenX3y+eX5MkbkLkSfTTeTpbD6bzfcPEJnKgcgfizxnn+lE GKvVVoR1iKkPQgFGX33esf/nK4+dHMwnR/PDQzp2ckjHXsgbwa64Si3fDnN8fILV +/PDI4a109nedO9VJ+PPOcu02nWosHSCtSpDMo6rjLlS4KGw1KKYnbtd6x8themY 5bVgib4dsZV05RCKs6zlVaK1Y6lWuSxaw/3ufsGH0uCExofZX3F8wTJndFUJg+if nZyfsZorXogaNGBW586vIjQ1R862NWIR+f0ewcoQ5pSnJUjCrMNxougY2g3CsVwb 9qER4uHlmQ/xqVTtbbyYTXo4V6XoP2VGIi1WdywTOW8rx5xmmczBQQKy5BXqMGTR /ydjEYdysZ1NGnSwAxi7s0HMdjY4xY6HsoPCtli2iPAdK9YZhaM89Irg+tU5kkhs 1gP4VFArCiSY8PSGkLoSGYOAtVYZ79Cr3ZqIU2oEVHo1Yn07w360jSqEBVRBbW6g 01SMUD5ZVcy0SlExOTRsHbsrAZvoYYTvq3T3AoyTyuoRvWOdbokUMu88GbDTCJ6N tQLjfAwgtAJHlagmAuzS2Q8YO2clXy4iguj8QpGFhtoQx5UEkStEKSmijWkPFstU oFX2WTW0stDYU7dpyXKOMGbAgbpZxCG/AAiN/Zd6DTmp9Ip5R6DqGJEaYAF/Qi86 mwiV9pvtUEAFrWyyoxzyAFPaAYuHYRGbYIhdVPQGLaDNlDyISU15SR2sMRqH1Aw9 t7KWFTe+xOcOeWA/x98EIlhyvKJUKJSXb+lcM9/ba0otankbw2drgLVx2e75+uxF xwHWR3I0fLzUBvolflGeFSVsRFN1I9R2xT2NljwNsu17hLOBuG1wtM7xqSZ1WuiQ J7p1nn3zIfw77HPUlijdWq9JStdbhq6y0DX6ahG+r6rpaB04gsANbUyEWwnIXJEC ewH2O4DoB2LFaqmA34hKcIvmSOVzOYwn4JmReFLyLMDxJ2+E3AiDzMEp4judTkRA PytQVQnwDzCSATraSgc4ChwvooNDdhdeKTNSQ89Cvh2RBp0qBvzKb8MmHBOw0PfD KUt8yYgNVG7OElkwWYMDy+B6yEZ42H1+3jA1Qyjqh2JILcr83BxtKoniCuoouA2Q 6Ii6ucfi/fdC+6gquu0puo04aQtLeg5vzhlvGghBBhUgfypPLYvSUVVAWnJYDOqM JR2rdMphFwJzw3jkduRzg8AXkV1XVZPNcLKUvK2227zpyv+xQuYBDg43rNA4BLIh D3Ft1rHHl9sZxBHmUublwZ6cX53QOgmYpBniRKJhBBv2XPAu6S3R50dLGm2c9Ra7 iJ57iaITZsS88UXQO1GYKlrE7GFLrqrgVSSY0KaX0Pue9iaEb97CR6EvxOiOHvYj aRRhf2BuPJvhhdjaHLNrtM1x47xD07aPuZrMvErJFIKhIgWys3MGSug42ojwml5l HO5FDBKqQNe8Kqmjnt4P1uJeGzX5LxmnVEpnCTUTGq99ybqXRF13EsMKEZ4EhhJ5 ZSZCx8QtT13AsXZR8gySG93yMEcvuvPLk4tRcJMWl0OMLJx59pCqT4wh0y+07vGQ P8lgSUG1KxHUivm3iG7ahjJH0qc9s8ABTPLgsSyXG8cMqAbXFBqOFg+zVZti72c3 uCnuWfAaWcJC41Tlwy5cFtaXg9Dy/oASTfNEaDRMaVtdZLJ9Le9SAT1mvogGXwnv nobp9hTh0tZAEGnHFvtnbBLuINZbvrfRrZmXkA7HGeZVeQ+2EHjtWj+5pR1UmXkI oVsYI1bHG4bQ/N66orzcYDRTweD4OsnhVkNEJMa6labuOpC6RkNfOYiGC0Ln213l MXvsWUf6Qw6Wzo7aBowV2WiwSMCDGaKluBhBE34R+2lr3fq61Df+OlwXBA2kJZy9 CbQcnGZzHak1WEqFWLtkuMLzitYsItwF7I0IY2Ez3DyeYP3OC4+HkUmVvyKhkSJD XeE7GPat9yuiUUI30iBUxCk0FZfuw68smNFjxIobVUTEvMLwpqQQtcQ1zVVEJFyY KTF/ZVpbr+2vX2tRo0TRpQQdMU66URStfws8b9PnXYQSV07PcZ30j+PUP/7eFqAo Go8puWvMNJqtPih+UijZ0vC1ulqK4Qpjg61yyAi9+cWD19+4Q78Nh9+Vb7/2Rnfn yz+9uXjyz9/+58VHk39f/vXHt7/78kfNH+788eDNb774+nf+/K9fPvr2w6fXz35+ +63v/vd/ =L0K7 -----END PGP SIGNATURE----- --yrj/dFKFPuw6o+aM--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071230132451.GA61295>