Date: Thu, 3 Jan 2008 23:07:58 +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: <20080103220757.GA86719@harmless.hu> In-Reply-To: <477D5927.4030100@FreeBSD.org> References: <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> <20071230132451.GA61295@harmless.hu> <477D5927.4030100@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
--sdtB3X0nJg68CQEu Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Jan 03, 2008 at 10:52:39PM +0100, Kris Kennaway wrote: > Gergely CZUCZY wrote: >=20 > >>* 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 =3D 0 to disable some mysql=20 > >>brain-death). Maybe tuning is required for myisam also. > >> > >>* Also make sure you are using identical config settings on the two sys= tems. > >http://phoemix.harmless.hu/mysql/ verify yourself. Only the paths are > >updated, but the main parameters are just the same. >=20 > You are not in fact using the same config parameters as I am. When I use= your config file I see a large performance loss when I run=20 > locally even with innodb. Well, I nowhere said that I'm using the same config as you did. In fact, I = said I was using the config from the production system we've got, and what were the differences in the config between the FreeBSD and the Linux systems. As soon as I have the time, I will make a diff and make some adjustments and new results with the updated config. We will see where this gets :) Thanks for the note on this. Sincerely, Gergely Czuczy mailto: gergely.czuczy@harmless.hu --=20 Weenies test. Geniuses solve problems that arise. --sdtB3X0nJg68CQEu Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) owF1VL9vHEUUNonSrEjhNtUrkIKd2707nxPsi+4SY5PoSKIg+ZCVAIrmdt/uDp4f 65nZW28E1CkoEAUUCITokRKJNoIOJCRq/gIkJEpQChre7N7ZTkFz2ps3873v+943 89nF8yvnVn97+sN7Vz79/KtXvr/w02xdls6pLJTMzLkK+71eP9y69kZ/O9wMB0m8 kQ6ubfYHV/ub2/Htj99/vquVQ+XCaV3gEBweu24hGFfXIc6ZsehGpUvDrWC5b4/b QlvuuFZD4EpwhSe1qWHKpmjCt1SsE66yIRyV2mESFoYrx2YCg+C+gmleduBtpqA3 6MBGr7cFzEG/N7y6MRxsv3MPrvSIdQfuGG7hDirFKlZDZQhpGIzhNpoMRQ27D9/d ffjgZH200aPieLwOu1oWzCA4DbKGWKuUZ5BygZCjaSDG4+Ynd64YdrsF6kJglBrE mU0ibbLuJ4fUu2tjRvqyrqyjWKWn56Y5QoIpK4WjDvZILJvkzMIcTQ2F1gYKNKk2 kqkYgT7ILaWTGbxe6xIUYjIKvG6BzLpF7ZHLDbLkEcHFpTGo4hpGgz3oeS0Jt95B sFpi23YpeWZoYGGCzOVrEcA9Vs9IfamIO5CFBo9KbjBpSMiaYCQwYXV0qmgddmgB JDsk/JK88xy9h6VtQBIaLyc3lkIpF44KFrQCR264SoOt7ShwKG2Du/Q21yj5cURZ kgKtjfKy23DveqN4WvtOFDORRnBf0VQ9WkFCrG/vgcoiYRShDsxK11QliaUthkl0 aJp98GFp2yJpw2gZhgcLEUp7gyFlsVsIWm5d6jkLZ2ECTJKPBzkq+i4t0qQ8zZey NCETEBgIRnF8adZCWwtVe9iUquUiNNlH+nBO6xV3+WLkUXCAQnRoq9KVzyfx4gkR pGhMLsv/4Usk/YQSnkQwaZV5iFHgDwcTqGjD6cklbaNl66/RSRn7K+yHRiODCi/P ETJNKEwlRJ66V0Qm8NsTntKlpjCi9TaeQZyhqxDbpVt0fd7c32vO+/93uSqPF/gU iWDHUnKpY+NvzqhdExwu0TOvuBBt/FjTr4Fp4+jjzhI/YUkptL4SKKwo1pYuoG3N 9FiLpCzIRXCALayfU2uty+k6ZEiHhmtBMM2ZOrTNrfDHKSXY5pl7vvucBBt6aDpB cPLkPC7jx3VACRRODwmpWY7iZvnmmYwHQRj6uR+QO5xsc2hdRC+X4pQmb4SYN2Og +yxtO2xGLw5F98mN8xdW/MO8fNRXz/310cq33/34/O4X4/1/nt28cf2btT+/fFW/ uLjy9erOr09+/v3pH9nfr30wzH6ZvHj276X/AA== =7c/j -----END PGP SIGNATURE----- --sdtB3X0nJg68CQEu--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080103220757.GA86719>