Date: Fri, 4 Jan 2008 20:35:46 +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: <20080104193546.GA34364@harmless.hu> In-Reply-To: <477E89F4.1080605@FreeBSD.org> References: <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> <20071230132451.GA61295@harmless.hu> <477D5927.4030100@FreeBSD.org> <20080104133028.GA89602@harmless.hu> <477E89F4.1080605@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
--82I3+IH0IqGh5yIs Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Jan 04, 2008 at 08:33:08PM +0100, Kris Kennaway wrote: > Gergely CZUCZY wrote: > >On Thu, Jan 03, 2008 at 10:52:39PM +0100, Kris Kennaway wrote: > >>Gergely CZUCZY wrote: > >> > >>>>* 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 ne= ed at least innodb_thread_concurrency =3D 0 to disable some=20 > >>>>mysql brain-death). Maybe tuning is required for myisam also. > >>>> > >>>>* Also make sure you are using identical config settings on the two s= ystems. > >>>http://phoemix.harmless.hu/mysql/ verify yourself. Only the paths are > >>>updated, but the main parameters are just the same. > >>You are not in fact using the same config parameters as I am. When I u= se your config file I see a large performance loss when I run=20 > >>locally even with innodb. > >So, the updated config is here: > >http://phoemix.harmless.hu/mysql/my.cnf.kris > >I've migrated the values from your config. > >And the plot is here: > >http://phoemix.harmless.hu/mysql/rw-kris.png > >I"ve also plotted a current production system, which crashes around 96 t= hreads in > >the test, or so. That's a Linux-2.6.12 and MySQL 5.0.22, so it should be= quite unoptimized > >compared to any recent version of anything. > >As it seems, you were right. These adjustments made a very slight perfor= mance boost, around > >5%. But it's still lagging behind. > >Again, this is MyISAM, not innodb. The "tc4" and "tc16" strings mean the= thread_concurrency > >is either set to 4 or 16. Your config had 16, but I've googled for it, a= nd some resources > >suggested setting that to CPUs*2, and that's 4 in my case. > >I've updated the MySQL version on FreeBSD to 5.0.51, and will try to get= this version > >on linux also, and do a comparision with that one, too. > >Sincerely, > >Gergely Czuczy > >mailto: gergely.czuczy@harmless.hu >=20 > OK. The caching problem with myisam is unrelated to the other config cha= nges then. I have to finish my test, sorry for not being able to give more results. The boss decided to put back this box to the serverfarm, and since we're not using FreeBSD, just I'm a bsd-guy, I won't be able to do anything farth= er on on this topic. I hope I did something useful with this tests of my at all. And thank you all for helping with all the ideas, especially to you, Kris. Sincerely, Gergely Czuczy mailto: gergely.czuczy@harmless.hu --=20 Weenies test. Geniuses solve problems that arise. --82I3+IH0IqGh5yIs Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) owGVVkGLHEUU3hjMoUEk4N3HgqwmM70zu7PLZmRWk43GNVk3sgkh8RBqul93l+mu 6lRV72znEPAiEkQSQT2IGLyLHjx48Dd49iIevAvqH/C9qp7NRpEoLEtPV9X33vve 977q+88cX3jq5I/ffvfO6Q8//vzY19H709NV45zK+5Uw+1L1h4PBsL86Wl0f9Tf6 o1E6HCaj1bUsW0+yLL1w996DLa0cKte/0tY4BocHbrkuhVQvQ1IIY9FNGpf1N6L5 vvPS1tpKJ7Uag1SlVHi4dsUIZTM0/ddUolOp8jHcbrTDtF8bqZyYlhhFuwpeN7IH bwoFg1EPVgaDDRAOBhvj1dXxYOPyDpweUNo9uGikhYuolJiJFmaGkMbRJlxAk2PZ wtaNq1s3rj96v0nIV4qmQ159hDwcjNdWxqtnnoi8ufmv2Jv+3+bmKdjSVS0MgtNQ tZBolckcMlkiFGi6zYfbC+fq8fJyjbouMc4M4tSmsTb58t1blMOyTQQxmC9XbZyo 7PGzVwqEFDPRlI4i2dvlPFghLOyjaaHW2kCNJtOmEipBoAfqidLpFF5sdQMKJxGm zEGJwrpu7aYrDIr0JsEljTGokhYmq+dhwDWl0nKfwOoKJyuDLpcQf2pIGP0UhSte igF2RDslHhpFFQARavB2Iw3F4zSqloAqEKXV8eN1nYKz9BIqcYuiNMQkZ8qMNtYD pSQlSbzMyyUNOlqwoBU44sTNNNhJ1FqHle2w5zwXGit5EJNyqxKtjYtm2ae+zITJ rOVYJOoyi2FXUZ8Zr6ZyLCcQoJo6FSTZHkwb59crKpo2GVGhQ+N3wruNDYtUI4Yc rndVKM08QyYS11U03zcv6CiWhW0QFZF5rUBFz80ksp4R85i0tokFBAGlIH0+1vJS WwuzcNg0at6yUhODVCDu08pMuqLrvc91T/d8Ul2p80jUwkMJP5HQoNiYVcz7t5f2 iSmZGw/I4PuibNBCZnR1tB6fwFkV9tQlk/V/wppZn0PGtcp92EUKyxrzUBxaQNC0 g9rotEnYqMB6sfSIJ5kUkBhhC+RG6oYSObMObhL5kbDEEsN6maF1PSAlk4DJV4Rb ohNwSarmoL8Sr8fDFRB0eqfde/sSrMWDeGWlR3tBOrCFbsoUpjR9ZIDSEdNK105W 8g6mjJ8ED0l54IRqaXISzpg0ajldnfFbV5B4Al3WoyLpveenZUZ8gZF54Tg1JMWI lCVZEYolwaasFW8RtuRdnWImUdDMVGuuLdTPAdZeiOEcyV1ykdbJsiSl5TmLd4qU RhrSyGkSWDnUMfrbabf3zu70OsF7cXEysOiS0aLnhp6G64sEaPz8Vij8BBMr/3Qg DkCgSFJFwzPP3IyY/+F6DNePDEQhUnoX5tPLLtc6LzvbkVzXJKLgbGBErKWTCXqN 2ibPqam0s7MUSkP4OFuXr9pT1D7hdelbPeIhZoMXNgy4DzWfGBZI6Pxhz/haQzy3 d54BWQ9rwwA4Yzod9YLe53SfRoHB7iBD09mSdeWVHA6lmpXsZSI9vp9hn69WSE3Q wVb3JDXU0JXV41+H19edJrnjKSXzKp0eU2C/Eid+5dUjgxVtBs/YvUguxP1LRMLK 4/mhi6AKkTs7p7wbReECCdrzoH3HuubQRwOxTzTzkoqjaJv6te9vy0wqaRmpGy2r DZHCTWMFTZFj+quHeZJsJ9r4DtIFSD7PqU3Z7FJM6I7w4WuSwFQktwKjU30wz8mi IX4zqjLQaZkmGpslcnmOFoy5a1gv2Pn2El1XQPdzP2/aHtnpTKslTuwwq1QfziX5 u3EF3a4mCs33GThdyyQUrWt27VQGIYYzjcWsKeet5P1EhOVxJ1Kos+TYdDiYo1C3 wsVI4mGOCixrxvCH+SWXSTwIsgS0NXHi/d7piE6FLxzCOiKP6G/i+A/KiPp91sY1 RCUxZBvT55eSVAj5hC6pSZ1KbNAmq5XG5YNXjj+9wF+X80/Tk0+tf7Pw5W7724Of j/3x+wn5/Pf339i4d+K5t35aeHj/qz9v3/x14dkvfvnoh08ffrJoPlPv/QU= =xk3a -----END PGP SIGNATURE----- --82I3+IH0IqGh5yIs--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080104193546.GA34364>