From owner-freebsd-performance@FreeBSD.ORG Thu Jan 3 22:08:05 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 181F216A419; Thu, 3 Jan 2008 22:08:05 +0000 (UTC) (envelope-from gergely.czuczy@harmless.hu) Received: from marvin.harmless.hu (marvin.harmless.hu [195.56.55.204]) by mx1.freebsd.org (Postfix) with ESMTP id 8DDAA13C465; Thu, 3 Jan 2008 22:08:04 +0000 (UTC) (envelope-from gergely.czuczy@harmless.hu) Received: from localhost (marvin-mail [192.168.0.2]) by marvin.harmless.hu (Postfix) with ESMTP id 941487C18B3; Thu, 3 Jan 2008 23:08:01 +0100 (CET) X-Virus-Scanned: by amavisd-new-2.4.2 (20060627) (Debian) at harmless.hu Received: from marvin.harmless.hu ([192.168.0.2]) by localhost (marvin.harmless.hu [192.168.0.2]) (amavisd-new, port 10024) with ESMTP id o3m8ORb3S2Ye; Thu, 3 Jan 2008 23:08:01 +0100 (CET) Received: from marvin.harmless.hu (localhost [127.0.0.1]) by marvin.harmless.hu (Postfix) with ESMTP id BD3A17C18B7; Thu, 3 Jan 2008 23:07:58 +0100 (CET) Date: Thu, 3 Jan 2008 23:07:58 +0100 From: Gergely CZUCZY To: Kris Kennaway Message-ID: <20080103220757.GA86719@harmless.hu> 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> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=x-unknown; protocol="application/pgp-signature"; boundary="sdtB3X0nJg68CQEu" Content-Disposition: inline In-Reply-To: <477D5927.4030100@FreeBSD.org> User-Agent: mutt-ng/devel-r804 (FreeBSD) Cc: Jeff Roberson , freebsd-performance@freebsd.org Subject: Re: mysql scaling questions X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 03 Jan 2008 22:08:05 -0000 --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--