seperating SQL and application server?

[Vahric MUHTARYAN]

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 at freebsd.org
[mailto:owner-freebsd-questions at freebsd.org] On Behalf Of Zhang Weiwu
Sent: Sunday, November 16, 2003 3:25 PM
To: freebsd-questions at 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 at freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to
"freebsd-questions-unsubscribe at freebsd.org"