From owner-freebsd-questions@FreeBSD.ORG Sun Nov 16 06:15:35 2003 Return-Path: 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 6438816A4CE for ; Sun, 16 Nov 2003 06:15:35 -0800 (PST) Received: from smtp.doruk.net.tr (smtp.doruk.net.tr [212.58.5.248]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0B56E43FF3 for ; Sun, 16 Nov 2003 06:15:34 -0800 (PST) (envelope-from vahric@doruk.net.tr) Received: from VAHOXP (vahric.doruk.net.tr [212.58.13.17]) by smtp.doruk.net.tr (8.12.8/8.12.8) with ESMTP id hAGEPrF0002672; Sun, 16 Nov 2003 16:25:53 +0200 From: "Vahric MUHTARYAN" To: "'Zhang Weiwu'" Date: Sun, 16 Nov 2003 16:14:45 +0200 Message-ID: <017a01c3ac4b$fcdfdcc0$110d3ad4@VAHOXP> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-reply-to: <3FB77AC0.7040704@hotmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal cc: freebsd-questions@freebsd.org Subject: RE: seperating SQL and application server? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 16 Nov 2003 14:15:35 -0000 Could you see any bottleneck on CPU or I/0 at this slow response ?!! You can see it when you run wmstat for example freebsd# vmstat 10 procs memory page disks faults cpu r b w avm fre flt re pi po fr sr ad0 ac0 in sy cs us sy id 1 0 0 99428 141268 57 0 0 0 52 0 0 0 335 0 264 0 2 97 0 0 0 99428 141268 0 0 0 0 0 0 0 0 331 0 250 0 1 99 0 0 0 99428 141268 0 0 0 0 0 0 0 0 333 0 253 0 2 98 You can watch CPU and Disk Bottlenecek ?! CPU and RAM is more important for PHP ?! And if you read too much from the disk I suggest use RAID1 or RAID10 Vahric -----Original Message----- From: owner-freebsd-questions@freebsd.org [mailto:owner-freebsd-questions@freebsd.org] On Behalf Of Zhang Weiwu Sent: Sunday, November 16, 2003 3:25 PM To: freebsd-questions@freebsd.org Subject: seperating SQL and application server? Hello. I am running apache + php + mysql on an PIII 800MHz server. Phpgroupware webpages takes several seconds to show up on a LAN (15 seconds at max). I mean each webpage takes several seconds to show up, even if I am the only user to access the server, and the server have no other works to do. I wish to know what slowed it down. A static page is 10 times faster. I know phpgroupware is very complicated, and each page are displayed after complicated process, so is the CPU too slow? Or is it the I/O problem? Or should I put the SQL server on another box? What is likely to be the slowest part? I have a very old Pentium 200 box (compaq deskpro, years old but very good quanlity), if I let it run mysql server for phpgroupware, would it bring up the speed or actually slow it down? _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"