From owner-freebsd-isp@FreeBSD.ORG  Tue Jun 24 17:13:23 2003
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
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 47B9F37B401
	for <freebsd-isp@freebsd.org>; Tue, 24 Jun 2003 17:13:23 -0700 (PDT)
Received: from ginsberg.uol.com.br (ginsberg.uol.com.br [200.221.29.48])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3335C43FE0
	for <freebsd-isp@freebsd.org>; Tue, 24 Jun 2003 17:13:21 -0700 (PDT)
	(envelope-from antonio.torres@newspace.net.br)
Received: from thinkpad.newspace.net.br ([200.221.55.15])
	by ginsberg.uol.com.br (8.9.1/8.9.1) with ESMTP id VAA26023
	for <freebsd-isp@freebsd.org>; Tue, 24 Jun 2003 21:13:18 -0300 (BRT)
Message-Id: <5.2.1.1.0.20030624210536.00aa4738@mail.newspace.net.br>
X-Sender: antonio@mail.newspace.net.br
X-Mailer: QUALCOMM Windows Eudora Version 5.2.1
Date: Tue, 24 Jun 2003 21:13:15 -0300
To: freebsd-isp@freebsd.org
From: Antonio Torres <antonio.torres@newspace.net.br>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
Subject: Fwd: Re: MySQL / apache tuning
X-BeenThere: freebsd-isp@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Internet Services Providers <freebsd-isp.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-isp>
List-Post: <mailto:freebsd-isp@freebsd.org>
List-Help: <mailto:freebsd-isp-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 25 Jun 2003 00:13:23 -0000

The Apache childs....
Is possible to try Apache2 ?????

Apache 2 is less "memory hungry" than Apache 1.3.... even using PHP....

You can limit the number of connections "per IP" (using ipfw) to the web 
server.... (in theory, can be done on httpd.conf, but ipfw is more.... 
imperative. :)

Also You can try "PHP accelerators" (like ZEND)... even the freeware 
version can improve Your PHP performance in, about, 25%...


[]s
Antonio Torres
antonio.torres@newspace.net.br


>Delivered-To: freebsd-isp@freebsd.org
>Date: Tue, 24 Jun 2003 18:09:11 -0600 (MDT)
>From: Ralph Forsythe <rf-list@centerone.com>
>To: Kevin Lyons <klyons@corserv.com>
>Cc: freebsd-isp@freebsd.org
>Subject: Re: MySQL / apache tuning
>X-BeenThere: freebsd-isp@freebsd.org
>X-Mailman-Version: 2.1.1
>List-Id: Internet Services Providers <freebsd-isp.freebsd.org>
>List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
>         <mailto:freebsd-isp-request@freebsd.org?subject=unsubscribe>
>List-Archive: <http://lists.freebsd.org/pipermail/freebsd-isp>
>List-Post: <mailto:freebsd-isp@freebsd.org>
>List-Help: <mailto:freebsd-isp-request@freebsd.org?subject=help>
>List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
>         <mailto:freebsd-isp-request@freebsd.org?subject=subscribe>
>Sender: owner-freebsd-isp@freebsd.org
>
>Not my server, not my app, and not an option. :)
>
>It's not running too slow at the moment actually (could be a little faster
>tho), but the memory usage is just outrageous.  Ways to "trim the fat" so
>to speak on mysql would be good, with apache I've been finding some things
>to try.  I did read up on mysql.com's site about my.cnf tuning, however
>they don't really go into the ramifications of changing variables.  I
>don't want to just follow an example, I want to actually base the numbers
>off something useful.
>
>Thanks,
>-rf
>
>On Tue, 24 Jun 2003, Kevin Lyons wrote:
>
> > mysql is not your problem.  throw php away and write the app in c.
>
>
>_______________________________________________
>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"