From owner-freebsd-questions Sun Sep 22 19:11:28 2002 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 8D0C937B401 for ; Sun, 22 Sep 2002 19:11:27 -0700 (PDT) Received: from mail.au.darkbluesea.com (mail.au.darkbluesea.com [203.185.208.1]) by mx1.FreeBSD.org (Postfix) with ESMTP id 25B2943E42 for ; Sun, 22 Sep 2002 19:11:26 -0700 (PDT) (envelope-from d.anker@au.darkbluesea.com) Received: (qmail 84102 invoked by uid 82); 23 Sep 2002 02:10:17 -0000 Received: from unknown (HELO ?10.0.0.188?) (10.0.0.188) by mail.au.darkbluesea.com with SMTP; 23 Sep 2002 02:10:17 -0000 Subject: Locating performance bottlenecks From: Duncan Anker To: freebsd-questions@freebsd.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 23 Sep 2002 12:09:46 +1000 Message-Id: <1032746986.20899.50.camel@duncan> Mime-Version: 1.0 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG I'm having problems with one of our web servers. Most of them run at around a load average of 1 or less with no problems. The troublesome one is hitting a load average of over 30 sometimes. The site is intensely interactive, uses a load of PHP and accesses a database. The database is located on another server so that probably isn't causing any problems directly. I suspect that the database is the bottleneck and Apache is being held up waiting for it - but I can't see where. What performance tools are available for locating bottlenecks? I don't want to spend a lot of time fine-tuning something that isn't the problem, but I'm at a loss to know where to start - Everything looks relatively normal in the standard tools. Thanks in advance, Duncan Anker To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message