Date: Sun, 3 Oct 2010 14:27:46 +0100 From: Steven Williamson <steven43126@gmail.com> To: Jeremy Chadwick <freebsd@jdc.parodius.com> Cc: Rumen Telbizov <telbizov@gmail.com>, Steven Hartland <killing@multiplay.co.uk>, freebsd-stable@freebsd.org Subject: Re: MySQL performance concern Message-ID: <AANLkTimyOwLeyMOiohMGzD628aZR16YvYyn21jqPmxYb@mail.gmail.com> In-Reply-To: <20101002223005.GA78136@icarus.home.lan> References: <AANLkTikGHByF0dJ-hj6zPoRhV6YoHGSrW3g0audama3M@mail.gmail.com> <ACD11509724249559BD89DDD26F67C62@multiplay.co.uk> <AANLkTi=WmvuDEkzbLZQ8BRLpCZtq8R8jKgjPUZmFc4fy@mail.gmail.com> <20101002223005.GA78136@icarus.home.lan>
next in thread | previous in thread | raw e-mail | index | archive | help
The tunings between your Linux and FreeBSD instances differ severely, > and some of the variables don't even exist any longer (example: > table_cache is now known as table_open_cache as of MySQL 5.1.3, and > probably key_buffer vs. key_buffer_size too). > > Can you please rule out MySQL tunings being responsible for the problem? > > Quick and dirty performance comparison ruling out MySQL tuning, install sysbench. This will give you a quick overview of how the OS / Hardware is performing. For a decent comparison there are too many variables here, the hardware is vastly different. Would be nice to see the same Linux install on the new hardware and the benchmarks for that if you have time. P.S Performance tuning can be a very time consuming business, an almost unending task. Best method is not to see if system x is faster than system y. But to state exactly what performance you require. If you only need 600 inserts per min for now and the next year, tune to that and your good to go. Otherwise you can end up spending days to get that extra 2 or 3 inserts per min which you really didn't need :) Regards Steven Williamson
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?AANLkTimyOwLeyMOiohMGzD628aZR16YvYyn21jqPmxYb>