From owner-freebsd-isp Mon Dec 9 9: 0:28 2002 Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 651AD37B401 for ; Mon, 9 Dec 2002 09:00:26 -0800 (PST) Received: from cobra.acceleratedweb.net (cobra-gw.acceleratedweb.net [207.99.79.37]) by mx1.FreeBSD.org (Postfix) with SMTP id 79B0443EEA for ; Mon, 9 Dec 2002 09:00:25 -0800 (PST) (envelope-from simon@optinet.com) Received: (qmail 37173 invoked by uid 106); 9 Dec 2002 17:04:40 -0000 Received: from 24-90-121-13.nyc.rr.com (HELO station1) (24.90.121.13) by cobra.acceleratedweb.net with SMTP; 9 Dec 2002 17:04:40 -0000 From: "Simon" To: "FreeBSD ISP" , "Walter Hop" Date: Mon, 09 Dec 2002 12:01:58 -0500 Reply-To: "Simon" X-Mailer: PMMail 2000 Professional (2.10.2010) For Windows 2000 (5.0.2195;2) In-Reply-To: <3487689390.20021209163011@slik.org> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: Loaded mysql box: best hardware? Message-Id: <20021209170025.79B0443EEA@mx1.FreeBSD.org> Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org If I were you, I would upgrade to dual Xeon 2.4-8Ghz board and get RAID if you don't already have one. While you may think MySQL will cache everything in RAM, it still has to read and write to the drives. Check your HD IO to make sure it's not causing any bottleneck. Also, while dual setup may not benefit MySQL right now, when FBSD 5.x comes out, it should greatly. When you use top, mysqld uses most CPU? or do your PHP scripts? how many queries a sec are you doing? Also, you can try optimizing your queries. Finally, make sure you always keep persistent connection to mysqld. -Simon On Mon, 9 Dec 2002 16:30:11 +0100, Walter Hop wrote: >Hi all, > >I currently maintain a fairly loaded FreeBSD box (dual P3/866), running= a >busy MySQL 3.23 database with its Apache/PHP web interface. It has SCSI= >disks and enough RAM to keep the whole MySQL database paged in, and the= >bottleneck is now really the CPU's. The scripts are fairly optimized (u= se >their own caching) so I am now looking at hardware. The machine itself = is >keeping up nicely for now (loads from 1 to 4), but system usage will >probably double, so I have to make a plan now for the increased load ne= xt >year. > >My question is: given that I now have a dual 866MHz box, is there any >performance to be gained from upgrading to, for instance, a faster dual= >system? What setup is generally preferred for loaded database boxes? > >Last month I read a doc that argues that MySQL is not able to profit fr= om >an SMP setup using the FreeBSD 4.x userland threads - saved it here: >http://www.skydancer.nl/dl/etc/20021119.freebsd.mysql.problems.mht - >Considering this, would an expensive dual box still be worth the money,= or >would it be more effective to switch to a single-CPU system with the >fastest clock instead? > >I want to prepare for when the machine REALLY gets abused, and I'd like= >input from people who have experience in this field, anything will help= . :) >What choice did you make for your high-end database servers? > >(If absolutely necessary I would consider installing another OS on the >server if it would use the hardware more effectively, but seeing that >FreeBSD 5.x is at the horizon, I'd rather throw money at the problem th= an >spend the time on switching to L*n*x or S*l*r*s/x86...) > >Thanks in advance for your input 8) >walter > >-- > Walter Hop | +31 6 2445 2020 | http://www.skydancer.nl/ > > >To Unsubscribe: send mail to majordomo@FreeBSD.org >with "unsubscribe freebsd-isp" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message