From owner-freebsd-questions@FreeBSD.ORG Sat Apr 14 19:42:13 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 508A616A404 for ; Sat, 14 Apr 2007 19:42:13 +0000 (UTC) (envelope-from corwin@aeternal.net) Received: from amber.aeternal.net (amber.aeternal.net [212.232.17.148]) by mx1.freebsd.org (Postfix) with ESMTP id 0F61B13C483 for ; Sat, 14 Apr 2007 19:42:13 +0000 (UTC) (envelope-from corwin@aeternal.net) Received: from localhost (localhost.aeternal.net [127.0.0.1]) by amber.aeternal.net (Postfix) with ESMTP id 6C29FB821 for ; Sat, 14 Apr 2007 21:42:10 +0200 (CEST) X-Virus-Scanned: by amavisd-new at aeternal.net Received: from amber.aeternal.net ([127.0.0.1]) by localhost (amber.aeternal.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id oOiwC9y-NYSb for ; Sat, 14 Apr 2007 21:42:09 +0200 (CEST) Received: from [127.0.0.1] (chello085216248040.chello.sk [85.216.248.40]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: corwin@aeternal.net) by amber.aeternal.net (Postfix) with ESMTP id 1EADDB81D for ; Sat, 14 Apr 2007 21:42:09 +0200 (CEST) Message-ID: <46212E90.9070308@aeternal.net> Date: Sat, 14 Apr 2007 21:42:08 +0200 From: Martin Hudec User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: <001301c77ec7$3e602af0$6501a8c0@GRANT> In-Reply-To: <001301c77ec7$3e602af0$6501a8c0@GRANT> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: Server Load X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: corwin@aeternal.net List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 14 Apr 2007 19:42:13 -0000 Grant Peel wrote: > Last week I enabled DEFLATE in apache. I have since disabled it, due to it (I think), sotting the serever load sky high. > Since disableing it, the server load has not decreased by much, but I have narrowed it down to Apache (2.2) or mysqld that is shooting the load up. > The high server loads started last Monday morning, and continued all week.(up and down through the days and nights). > > I was wondering if anyone knows of a way (or a utility) that can monitor apache and mysql at the domain level to help troublshoot where the root problem lies. > > FreeBSD 6.2 > Mysql 4.1.21 > php 4.4.4 As for mysql, you can use databases/mytop for monitoring the performance of mysql database. Also you can use mysql logging options to check (like log-slow-queries etc.). As for apache, there is pretty ExtendedStatus option and server-status location (see httpd.conf). Also sysutils/apachetop for monitoring the performance of apache server. Note that both utilities are not for unattended use. kind regards, Martin Hudec