From owner-freebsd-isp@FreeBSD.ORG Tue Jun 24 14:34:33 2003 Return-Path: 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 8BA2A37B401 for ; Tue, 24 Jun 2003 14:34:33 -0700 (PDT) Received: from blue.centerone.com (blue.centerone.com [204.133.183.111]) by mx1.FreeBSD.org (Postfix) with ESMTP id 06B9F43FE0 for ; Tue, 24 Jun 2003 14:34:33 -0700 (PDT) (envelope-from rf-list@centerone.com) Received: from localhost (rf-list@localhost) by blue.centerone.com (8.9.3/8.9.3) with ESMTP id PAA09273 for ; Tue, 24 Jun 2003 15:51:08 -0600 Date: Tue, 24 Jun 2003 15:51:08 -0600 (MDT) From: Ralph Forsythe To: freebsd-isp@freebsd.org Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Subject: MySQL / apache tuning X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 24 Jun 2003 21:34:33 -0000 I need some pointers on tuning a server. System has 1gb of RAM, running MySQL 3.23.57 and Apache 1.3.27. The web site has at any given moment, at least 200 people browsing online forums (UBB - uses PHP), which are entirely mysql-driven. I don't have the option of separating the DB out onto another box. What would some of you recommend for values to properly tune MySQL for this environment? Any special ways to make Apache run with as little memory and as much speed as possible? I am noticing that the box is using swap space, so obviously some changes need to be made. The forum in question has over 18,000 members, tens of thousands of posts, and is updated 24/7 - so I'm thinking a table optimization wouldn't hurt, but I'm looking for ways to tune the mysql process itself. What environment variables should I be looking to change to get this as fast and small as possible? (Yes I know RTFM, I'm looking more for some answers along the lines of "I've tried this with the same type of application and got best results with 'x'". Basically I want to get this under the 1gb mark with lots of room to spare (if possible), and increase the overall speed in the process. Thanks! - Ralph