From owner-freebsd-isp@FreeBSD.ORG Tue Jun 24 16:33:06 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 6E09237B401 for ; Tue, 24 Jun 2003 16:33:06 -0700 (PDT) Received: from corserv.corserv.com (user153.net516.tx.sprint-hsd.net [65.40.201.153]) by mx1.FreeBSD.org (Postfix) with ESMTP id ACBA643F93 for ; Tue, 24 Jun 2003 16:33:01 -0700 (PDT) (envelope-from klyons@corserv.com) Received: from corserv.com (cygni.corserv.com [192.168.1.2]) by corserv.corserv.com (8.11.6/8.11.6) with ESMTP id h5P0kXP64740; Tue, 24 Jun 2003 19:46:33 -0500 (CDT) (envelope-from klyons@corserv.com) Message-ID: <3EF8E401.4B132581@corserv.com> Date: Tue, 24 Jun 2003 18:51:29 -0500 From: Kevin Lyons X-Mailer: Mozilla 4.72 [en]C-CCK-MCD NSCPCD472 (Win95; U) X-Accept-Language: en MIME-Version: 1.0 To: Ralph Forsythe References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit cc: freebsd-isp@freebsd.org Subject: Re: 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 23:33:06 -0000 mysql is not your problem. throw php away and write the app in c. Ralph Forsythe wrote: > > 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 > > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org"