From owner-freebsd-database Wed Jan 10 9:15:59 2001 Delivered-To: freebsd-database@freebsd.org Received: from picalon.gun.de (picalon.gun.de [192.109.159.1]) by hub.freebsd.org (Postfix) with ESMTP id 44B9937B400; Wed, 10 Jan 2001 09:15:28 -0800 (PST) Received: (from uucp@localhost) by picalon.gun.de (8.9.3/8.9.3) id SAA26023; Wed, 10 Jan 2001 18:15:16 +0100 (MET) >Received: (from andreas@localhost) by klemm.gtn.com (8.11.1/8.11.1) id f0AH1ev03728; Wed, 10 Jan 2001 18:01:41 +0100 (CET) (envelope-from andreas) Date: Wed, 10 Jan 2001 18:01:40 +0100 From: Andreas Klemm To: Lauri Laupmaa Cc: database@freebsd.org, databases@freebsd.org, smp@freebsd.org Subject: Re: mysql (smp) performance Message-ID: <20010110180139.A3584@titan.klemm.gtn.com> References: <3A5C7393.40EB4D13@inspiral.net> Mime-Version: 1.0 Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3A5C7393.40EB4D13@inspiral.net>; from mauri@inspiral.net on Wed, Jan 10, 2001 at 04:37:08PM +0200 X-Operating-System: FreeBSD 4.2-STABLE SMP X-Disclaimer: A free society is one where it is safe to be unpopular Content-Type: text/plain; charset=us-ascii Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, Jan 10, 2001 at 04:37:08PM +0200, Lauri Laupmaa wrote: > I have used 4.x-STABLE systems, both on SMP and singleproc and linux > 2.1/2.2 kernels. Which kernel profile ? GENERIC ? Modified ? Ralf Engelschall wrote a paper how to fine tune FreeBSD kernel for high performance load sharing webservers ... Certainly there are things that could be tuned when using databases. Did you already ask on the mysql mailinglist, what they recommend to fine tune to increase performance in general for mysql ? Perhaps they already have some experience with FreeBSD ? Already searched the archives (www.google.com) ? I looked for: mysql performance tuning And got some links: http://www.tryc.on.ca/archives/mysql/December1999/0009.html What disks are you using SCSI or IDE ? What driver settings in the kernel ... Some kernel options might give a difference. Maybe the Linux machines have some performance knobs turned on, in certain areas FreeBSD is more restrictive in turning on such knobs per default, with the sake to support more (crappy) hardware. Andreas /// -- Andreas Klemm - Powered by FreeBSD 4.2 SMP Need a magic printfilter today ? -> http://www.apsfilter.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message