From owner-freebsd-smp Wed Jan 10 9:16: 3 2001 Delivered-To: freebsd-smp@freebsd.org Received: from picalon.gun.de (picalon.gun.de [192.109.159.1]) by hub.freebsd.org (Postfix) with ESMTP id 5AAA037B401; Wed, 10 Jan 2001 09:15:28 -0800 (PST) Received: (from uucp@localhost) by picalon.gun.de (8.9.3/8.9.3) id SAA26032; Wed, 10 Jan 2001 18:15:17 +0100 (MET) >Received: (from andreas@localhost) by klemm.gtn.com (8.11.1/8.11.1) id f0AH5Hh03786; Wed, 10 Jan 2001 18:05:17 +0100 (CET) (envelope-from andreas) Date: Wed, 10 Jan 2001 18:05:17 +0100 From: Andreas Klemm To: Lauri Laupmaa Cc: database@freebsd.org, databases@freebsd.org, smp@freebsd.org Subject: Re: mysql (smp) performance Message-ID: <20010110180517.A3741@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-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org I found another interesting link for FreeBSD && mysql: http://www.bitmechanic.com/mail-archives/mysql/Nov1997/0425.html +------------------------------------------------------------------- > I've just got a brand new 200Mhz Pentium machine with two 4 gig SCSI > disks for me to use. Its only purpose in life is to be a mysql > server. I want this baby to scream. I'm planning on ccd-ing the two > disks together to get the benefits of having two spindles. What else > should I do? Does anyone have experience and advice with opening up > the server configuration options, like buffers and open files, etc? > > Thanks, > > Nat You want to rebuild a kernel with the following options maxusers 256 options CHILD_MAX=512 options OPEN_MAX=256 # this is with 256 MB RAM adjust these figures based on # how much RAM you have options "MAXDSIZE=(256*1024*1024)" options "DFLDSIZE=(128*1024*1024)" # set this otherwise the kernel only recognizes the first 64 MB options MAXMEM=262144 # 256 MB options NMBCLUSTERS=4096 options COPTFLAGS="-O2 -fexpensive-optimizations -m486 -fomit-frame-pointer" +------------------------------------------------------------------- Note: concerning COPTFLAGS, be careful ... -pipe -O is know to produce the "correctest" code.... First I'd try the other options. Be careful with the settings, if you don't have enough RAM ... 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-smp" in the body of the message