Date: Sun, 16 Nov 2003 16:14:45 +0200 From: "Vahric MUHTARYAN" <vahric@doruk.net.tr> To: "'Zhang Weiwu'" <weiwuzhang@hotmail.com> Cc: freebsd-questions@freebsd.org Subject: RE: seperating SQL and application server? Message-ID: <017a01c3ac4b$fcdfdcc0$110d3ad4@VAHOXP> In-Reply-To: <3FB77AC0.7040704@hotmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?017a01c3ac4b$fcdfdcc0$110d3ad4>