From owner-freebsd-performance@FreeBSD.ORG Sun Dec 30 13:35:59 2007 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 06C8516A419 for ; Sun, 30 Dec 2007 13:35:59 +0000 (UTC) (envelope-from kris@FreeBSD.org) Received: from weak.local (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 1AA7713C43E; Sun, 30 Dec 2007 13:35:57 +0000 (UTC) (envelope-from kris@FreeBSD.org) Message-ID: <47779EBC.5020900@FreeBSD.org> Date: Sun, 30 Dec 2007 14:35:56 +0100 From: Kris Kennaway User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031) MIME-Version: 1.0 To: Gergely CZUCZY 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> In-Reply-To: <20071230132451.GA61295@harmless.hu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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: Sun, 30 Dec 2007 13:35:59 -0000 Gergely CZUCZY wrote: >> I appreciate that you might be constrained by local requirements, but it's really not meaningful to compare different mysql versions if >> your goal is to study OS performance. > It'd be a PITA to install the both versions. Maybe now, that the ports freeze is over, i can > do something. But honestly, every mysql version was faster on linux, than eny on FreeBSD, > even the .22 one was faster. We start work on Jan02, I will see what can I do. Regardless, we need a stable baseline to compare to. >> * What database engine are you using? I have only tested with innodb but maybe you are using myisam? Please provide your exact >> sysbench command lines. > MyISAM, of course. InnoDB is not any good with replication, and we need backup. OK. I tested briefly and InnoDB is almost 20 times faster on my tests with default myisam settings. myisam runs into the usual serious mysql scaling problems at concurrency > 8 threads (contention within the mysql application, not a FreeBSD issue). Still waiting for your sysbench command lines :) >> * 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. OK, I will take your word for it. >> * With the above, please compare read-only mode also (I think Jeff already asked you about this but I didnt see a reply). That will >> allow us to calibrate what is going on. > http://phoemix.harmless.hu/mysql/ro-all.png > The graph is mistitled as Read-write, but it's a readonly test. OK. Kris