Date: Thu, 03 Jan 2008 22:52:39 +0100 From: Kris Kennaway <kris@FreeBSD.org> To: Gergely CZUCZY <phoemix@harmless.hu> Cc: Jeff Roberson <jroberson@chesapeake.net>, freebsd-performance@freebsd.org Subject: Re: mysql scaling questions Message-ID: <477D5927.4030100@FreeBSD.org> In-Reply-To: <20071230132451.GA61295@harmless.hu> 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> <20071230132451.GA61295@harmless.hu>
next in thread | previous in thread | raw e-mail | index | archive | help
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 need at least innodb_thread_concurrency = 0 to disable some mysql >> brain-death). Maybe tuning is required for myisam also. >> >> * Also make sure you are using identical config settings on the two systems. > 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 use your config file I see a large performance loss when I run locally even with innodb. Kris
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?477D5927.4030100>