Date: Fri, 4 Jan 2008 14:30:28 +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: <20080104133028.GA89602@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
--envbJBWh7q8WU6mo 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 brain-death= ). =20 > >>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 locally even wi= th=20 > 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 thre= ads in the test, or so. That's a Linux-2.6.12 and MySQL 5.0.22, so it should be qu= ite unoptimized compared to any recent version of anything. As it seems, you were right. These adjustments made a very slight performan= ce boost, around 5%. But it's still lagging behind. Again, this is MyISAM, not innodb. The "tc4" and "tc16" strings mean the th= read_concurrency is either set to 4 or 16. Your config had 16, but I've googled for it, and = 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 th= is version on linux also, and do a comparision with that one, too. Sincerely, Gergely Czuczy mailto: gergely.czuczy@harmless.hu --=20 Weenies test. Geniuses solve problems that arise. --envbJBWh7q8WU6mo Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) owGNVU1vHEUQNYkQUiMO4QyiZAkFnJ3ZD9sbe9E6ODZYxrESZIeQ5BD1ztTMdDLT Pe7u8WZySA5cckACccgFIc5IIHEACYkfwAVx4cJv4IIQ/ACqZnbthAtIljXbH6/q vXpV/elLZxfOnPvl2+9uX/j4s8+f++aFXycXisp7nQaFtMdKB/1erx+srQ97g2AY 9FeGUf9iNFm+uJb0J/HKzsOVv7aM9qh9cFiXOAKP9323zKXSb0GUSevQjyufBGti fm5budI45ZXRI1A6VxpP9g6t1C5BG7yjIxMrnY7gqDIe46C0Sns5yVGIqxoOs6oD 70kNveUODHq9NZAe+r3R6mC0vH5tHy70KO0O7FnlYA+1llNZw9QS0khswA7aFPMa tm5d37p182R9POjR5sbGEmyZopQWwRsoaoiMTlQKicoRMrQNxMZG8y/zvhx1uyWa MscwsYgTF4fGpt2H9yh210WS+KXdog4jnZzeO8wQYkxklXuK4I7yeZBMOjhGW0Np jIUSbWJsIXWEQB+kljbxBN6oTQUaMR4L5p2jdH62d8dnFmV8h+CiylrUUQ3j5W3o MZdYOVYQnClwFnZiqVJBjNJnY/FmCHMN9mU9If6VpuyBRLR4VCmLcZNGURNQATJ3 JjzltASbtACFvEcRKlKPs2QVK9eAxFRgRXrMqZIzPG04MBo86eGnBlztxsJj4Rrc ubqZwULdD8lNRY7OhVnVbbLvslQqqTkSGS1PQriqqa6MVhIjx+EZqCpjSSbqwKTy zW5BrOmIlQV6tM05uFu5dpO4YTi3w80ZCW1YYkhk5GeE5kfnfJ6Gc7ALsggBbmSo 6btySLXiNJ9x0y6JgCAhl2TIZ6qdG+dg2l62labfpBxRw2NamioSKWvza8seigPT aTKaUZ2HodK1lv1PLVuLhmxbIXbPH5NIKrUNFuMey7xCB4k1xdM8QiE2dXuizFmi /x3PTgOOFZY6pXiLFI/91KBwTAmtfz2U1sRVxOOC7UHm6JAwKsogstJlyMUzFeWw PgQ2/1jI2JEsovEUOt8Bsiw5lYaG9OfpOFxRurofDMJh2B+ApKv79cH7V2A17IWD QYfOgvLgMlPlMVAXHFVjoTxJq03pVaEeYCyidkLE3FZS19QfEedKfnScqEl41Wfk E1bINYBIvu40XTElicCqNPOcFTriHrP9CsJwZM6YTdGMAZfzqVNrjAWZY2IM02p5 i9XXQ7hMvlZMznmV5+SnNGWLTpAyiDmDlAzPBqH60N9+vXuwud+ZmboxEOcBiz5a WWwUoa/+cJHgbNOiBcpZk9KY+PeAEYSIinYt9zQrssKS94chd489HW0xrbU92Pgr NSbNZyNFMR+KOxbNcLLo6GaETrgqTamIdGw2LygF2QTZunbdLQ3aa74t7Qq3KE9s 6aiDWxfPG4Kzb+t8UiQN79LEvnywzXBc/dV+CzdlET3JT+spUyLWys0vCrqYs4Ua x7Y3YsOObUyhGvApCdKmajSS8oZGpThQ1NuWnp6OECeP0IMqelALmki5NyMK1yyH UbP89lN9I0QQcM/fQNSKbM/eDukt04qmC1Xe5MSWmoUmfOHa0JwMCfH40tnnF/ip nr/z58789sfClzd+ePLz4PpXn7z20aOdnx5/8OTuj79fWvji1Udnlr5+8fuXP+wO b/95rfNKtLf09z8= =k3X4 -----END PGP SIGNATURE----- --envbJBWh7q8WU6mo--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080104133028.GA89602>