From owner-freebsd-questions@FreeBSD.ORG Fri Mar 11 21:45:04 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id AA6E516A4CE for ; Fri, 11 Mar 2005 21:45:04 +0000 (GMT) Received: from dreadlock.phreakout.net (dreadlock.phreakout.net [208.51.56.115]) by mx1.FreeBSD.org (Postfix) with SMTP id EED1F43D39 for ; Fri, 11 Mar 2005 21:45:03 +0000 (GMT) (envelope-from bob@phreakout.net) Received: (qmail 1230 invoked from network); 11 Mar 2005 21:53:00 -0000 Received: from 24-52-230-137.kntnny.adelphia.net (HELO ?192.168.0.113?) (24.52.230.137) by dreadlock.phreakout.net with SMTP; 11 Mar 2005 21:53:00 -0000 Message-ID: <42321144.6030705@phreakout.net> Date: Fri, 11 Mar 2005 16:44:36 -0500 From: Bob Ababurko User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: FreeBSD-questions@FreeBSD.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: which hardware for db/app X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Mar 2005 21:45:04 -0000 Hello- I have a chance of migrating hardware for our web/app/db configuration. Currently, I am running web and php on two loadbalanced Sun Ultra2(2x300Mhz, 512MB RAM) running FreeBSD 5.3 with a SUN Ultra60 with the same procs and RAM as the web,(2x300Mhz, 512MB RAM). I am having issues with the db running slowly at this time and do not really know where to start to determine the cause or fix since I do not know much about mysql. I did have some issues with the db and ran isamchk to fix errors on a few of the tables but since then it ha been running slow. Can someone possibly show me to a resource that may be abe to help me determine the issues that I am having as well as some possible tweeks for mysql 3.23.58 server, which is what is running. On the web/php side, we have apache 1.3.31 and php4-4.3.8_2. I also have hardware that I am gooing to posibly migrate these servers to: I have a dual AMD 2800+(2200Mhz) and an AMD 2200+(1500Mhz). I am wondering what I should use for what here. I am not sure if O should use the dual amd for the apache/php or the mysql. If anyone has any ideas on what would be the optimal setup with the given hardware then please let me hear it. I would appreciate the input. thanks, Bob