Date: Sun, 30 Dec 2007 14:35:56 +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: <47779EBC.5020900@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: >> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?47779EBC.5020900>