Mailing-List: contact users-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@httpd.apache.org
Received-SPF: pass (athena.apache.org: domain of abiacco@formatdynamics.com
 designates 209.111.94.85 as permitted sender)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----_=_NextPart_001_01C98C19.EB9DA0EB"
Date: Wed, 11 Feb 2009 00:25:31 -0700
Message-ID: 
 <40D5E3C3CBE03D45A776E7C358BDE908166039@missoula.formatdynamics.com>
Thread-Topic: [users@httpd]  Re: optimizing apache web server
Thread-Index: AcmMAjRkRNyufWX6RqyRUVCM80SpugAFla9i
References: <49912906.6080908@infoservices.in> <gmrrsr$f48$1@ger.gmane.org>
 <49925567.3080501@infoservices.in>
From: "Anthony J. Biacco" <abiacco@formatdynamics.com>
To: <users@httpd.apache.org>
Subject: RE: [users@httpd]  Re: optimizing apache web server

------_=_NextPart_001_01C98C19.EB9DA0EB
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Did you compile apache from source or use a binary package?
List any 3rd party modules you're using, if any. Does typo use php? I =
forget.
Run an strace on the apache process consuming the CPU and see what it's =
doing at the time of trouble.
Run lsof on the process to see if any unusual files or exorbanat amount =
of sockets are open
Run vmstat to check on the status/numberof waiting or queued processes =
and type of cpu wait (system/user/disk)
Turn on query logging in mysql and watch the query log for an unusual =
amount of queries or large data queries at the time the apache process =
is consuming the CPU.

-Tony
=20
________________________________

From: J. Bakshi [mailto:joydeep@infoservices.in]
Sent: Tue 10/02/2009 21:34
To: users@httpd.apache.org
Subject: Re: [users@httpd] Re: optimizing apache web server


Nicholas Sherlock wrote:
> J. Bakshi wrote:
>> I am running an apache server at a remote debian box which have 4 GB =
RAM
>> and quad-core intel CPU. During the development period the site was
>> first. But after finishing the site when people start to access it, =
the
>> site some times become very very very slow. There is no noticeable =
load
>> on the system, but still the site is not working  as fast as it were =
in
>> its development period.
>
> Double check that you aren't using your swapfile (the 'top' utility
> can tell you this). If too many concurrent Apache processes are
> allowed, they'll soak up all your RAM and more, and having to swap
> them to disk kills performance stone dead. While you're in 'top', you
> might check to see what is using the CPU while the site is running =
slow.
>
> Does your site use a database? Could the slowdown be due to
> competition for exclusive locks on tables? This could cause a site
> slowdown even with low CPU usage.

Hello Nicholas,

Thanks for your kind response.
Yes, the storage engine is mysql and it is actually typo3 powered site.
But I have already done the optimization in mysql level and there is no
such load on mysql. The server is armed with 4 GB Ram and quadcore
processor. When the site becomes slow ; the top shows it is actually
apache which consumes so much CPU. Is not there any way to optimize =
apache ?

Thanks


>
> Cheers,
> Nicholas Sherlock
>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server
> Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>   "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
>


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server =
Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


------_=_NextPart_001_01C98C19.EB9DA0EB
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64

eJ8+IiAHAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEANAAAAFJFOiBbdXNlcnNAaHR0cGRd
ICBSZTogb3B0aW1pemluZyBhcGFjaGUgd2ViIHNlcnZlcgBxEgEFgAMADgAAANkHAgALAAAAGQAf
AAMAKAEBIIADAA4AAADZBwIACwAAABkAHwADACgBAQmAAQAhAAAAMzJCQjg0RkEyMzBFNDM0RkEx
MjFDRjJBRDgwMEE0RUIAQAcBA5AGAPwVAAA4AAAAAwA2AAAAAABAADkA66Cd6xmMyQEeAD0AAQAA
AAUAAABSRTogAAAAAAIBRwABAAAAOQAAAGM9VVM7YT0gO3A9Rm9ybWF0IER5bmFtaWNzO2w9TUlT
U09VTEEtMDkwMjExMDcyNTMxWi00NDM0AAAAAB4ASQABAAAANAAAAFJlOiBbdXNlcnNAaHR0cGRd
ICBSZTogb3B0aW1pemluZyBhcGFjaGUgd2ViIHNlcnZlcgBAAE4AgI2bEQKMyQEeAFoAAQAAAAoA
AABKLiBCYWtzaGkAAAACAVsAAQAAAD8AAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAABKLiBCYWtz
aGkAU01UUABqb3lkZWVwQGluZm9zZXJ2aWNlcy5pbgAAAgFcAAEAAAAdAAAAU01UUDpKT1lERUVQ
QElORk9TRVJWSUNFUy5JTgAAAAAeAF0AAQAAAAoAAABKLiBCYWtzaGkAAAACAV4AAQAAAD8AAAAA
AAAAgSsfpL6jEBmdbgDdAQ9UAgAAAABKLiBCYWtzaGkAU01UUABqb3lkZWVwQGluZm9zZXJ2aWNl
cy5pbgAAAgFfAAEAAAAdAAAAU01UUDpKT1lERUVQQElORk9TRVJWSUNFUy5JTgAAAAAeAGYAAQAA
AAUAAABTTVRQAAAAAB4AZwABAAAAGAAAAGpveWRlZXBAaW5mb3NlcnZpY2VzLmluAB4AaAABAAAA
BQAAAFNNVFAAAAAAHgBpAAEAAAAYAAAAam95ZGVlcEBpbmZvc2VydmljZXMuaW4AHgBwAAEAAAAw
AAAAW3VzZXJzQGh0dHBkXSAgUmU6IG9wdGltaXppbmcgYXBhY2hlIHdlYiBzZXJ2ZXIAAgFxAAEA
AAAbAAAAAcmMAjRkRNyufWX6RqyRUVCM80SpugAFla9iAB4AdAABAAAAFwAAAHVzZXJzQGh0dHBk
LmFwYWNoZS5vcmcAAB4AGgwBAAAAEgAAAEFudGhvbnkgSi4gQmlhY2NvAAAAHgAdDgEAAAAwAAAA
W3VzZXJzQGh0dHBkXSAgUmU6IG9wdGltaXppbmcgYXBhY2hlIHdlYiBzZXJ2ZXIAAgEJEAEAAACA
DgAAfA4AACUzAABMWkZ154ih6AMACgByY3BnMTI1gjIDQ2h0bWwxAzA/AQMB9wqAAqQD4wIAY2jB
CsBzZXQwIAcTAoD/EAMAUARWCFUHshHVDlEDAd0Q1zIGAAbDEdUzBEYQ2VkS72Y0EG8RezUDxlR8
YWgDcQKAEeMI7wn3O3scHw4wNR0/HRER4QxgY2cAUAsJAWQzNhFgC6U0ciAQAipcDrIBkA4QOQAg
PEhUTUwgZIhpcj0isHI+fSJz5wAhAzAjwWRvAOAjwQqx/FxxHAAjwRjgAzAkJRFgjSIrMyIAIyBF
QUQj8AkiLDc3IxBUSVRMDkUoHSHwDvBSZTogLFt1GSAZEEAOsHRwNGRdKsNvBTAHcGl6MQuAZyBh
CrAY4GUg0HdlYiArMXYEkCgtdDg1IxAvKV8iwgrjIBcvnzCvDhA2DvA8TUU4VEEgBaACMAnwdD0G
IgXgIzM2LjAwLg8hYDTRMxAhYDgiIG4CYQeAPUdFTkVS8EFUT1IoHSqhLxAn3xcqcTHfIsE1EWA8
Qk8cRFkoHSFxOU9nOTYBIxBESVYgaWQ9MT2gT1dBKtALUHlUwGV4dDU5OD0wI4/+IAAAJSUlwyWB
Jh87bzx/nz2APw9AH0EqIkk2NEUKE0FfIqQ0OCMQRk9O+FQgZgDQNfAHEzOhG7F8PSM1ETURLYAs
gDXwMvdE+xgwAzBjE/ADsgHQQTkyRD2gIHkIYDOhbXD/AxAtMCzlA1ItgAhhSxAsIGcFwCshLNAg
YguACsB5SiAs8Wsi0GU/Iiw1/T0xL0qiI/kkB0dLAcAkB68KolUICoAiLDAnoS89Yf9UX0k/Qq9D
v0TPRd9VP0f/v1pfSh9LJkyPTZROTUwEAPcFQABwUkAzCyBSUQAgUkDdBGF1UAAEIE9xJx6gUYFd
LKEsPZAkgGdBLk8gbxMHkWfwcG9Rg3BocAVS3DgiACZuYnNwswKAJBgnYQFAYedJSuDzBbBSsHQu
Uu9T/1UPVh//Vy9YP1lPYf9bb1x/XY9en39fr2C/Yc9i32PvZP9OTVLudQOgA5FnEHJLASwgA6D2
dC0hLOVwA2BLEAQRM7Ecc3UscCyxg7JDUFU/ZzFPUBkgLTEY8AVAaXT+JwQgJOAsowVAg7IsUVFB
7ySAI9AIYAJgZW6Pb59wr/9xv3LPc990732fdw94H3kv/3o/e098X31vfn9/j4Cfga+9grFsUPAk
gIOFhGZ0aoBXhkJphFGAbisgdUtxZt9P8QQgBbE+gAWwYgBwhqH/NdAIYAIwiDJQ8FKAEUAEIPsK
wFFBcAnwiP+KD4sfjC//jT+OT49fmA+Rf5KPk5+Ur/+Vv5bPl9+Y75n/mw+cHwOg/HZtZxCHgmqA
LRFSgIN2+7ciKyAvn3AG0ASQiEBrL3tsP21KdwtwLFAssQWxcf8KUApQZ6GEdAeRhgJqUYgjhw3w
T5C8QiAoc3lnEChlbS8rIi+tQHNr/imiv6PPpN+l76b/qA+pH/+xz6s/rE+tX65vr3+wj7Gf77Kv
s7+0z05NVAhwA6CDgee88VIxG7BnZyyiC4BoEO+/cEERhgK8QHQl8YOy1Qf/uW+6f21KbiGC0p9m
oRjVAv8IkKAjC2BuQcrwhqBR0NxW34eKg78EIAQAhN9ViO/Bf3/HryJ3MxA6gTaRJBkLgGX/CoHN
X8PPxN/F78b/4+/JHz/KL8s/zE/mv85v69ctVP0CIHnnT+hf6W/qf+uP7J//7a/uv+/P8N/x7/L/
1+/Y//9tSvRf9W/2f/eP+J/5r/q/P/vP/N/97wkfCi89IkhSG2pAITBJhhA+gD0tMUvSjCAgcSUA
cWof8GzCZC1wXH4gXxOyE3H/5jMFU+aKDp8PrwcvCD8Vz/8P3wtvDH8Nj/7/AA/QD9EZ+FRhaE/A
UdDSL02RLvC/Tj4BHjqQEdsTYSVHRlCxPjoa/E4QF/Am6sKZIEoBaeBCYWtzaGkgDlsjQE/wnoA6
am95OxFwPjBA1eDawL/hdmn1hJEu1eBd5E/lX+ZsJd/rJu8wh1OikHQozynfKueH1ICGYBewLzAy
L05gADA5IDIxOjM0/y4fLy8wPzFPMl/UJSxwNB8nNS8q9r/Sc0ACkHRw9GQuUDQubjE3/zkPOh/v
Oy88PzNliKBqt8Az/z7PsSrYUmU6LABAeV1Kk5+icIfxI4CHQ1BEd2UTYP8tUrkgQd9C70P/4a/i
v1BP/05fT28DrwS/Bc8Xb1JvIS7/Wd9a7xnvGv9c7CCfXt8fK/0Q0FBU2mNhVdphL1uP0Of3I3/T
MbXsTi2QIyDdAL3g2lO3sHLVYLfRd4iAv5CPR/xUb1V/RM8mZ3QCaf4+Ks8r0mx/bY9un2+vcL8n
dd9273f/IEnboSBy/YKwbodDgsGEBE1kh3LdkH+iQNvAv5AcME0w0eCCwGJsb3iGcWthIIaQTZAg
ydNgR0KCkEFNc390j/91n3k/ek+C74P/cbq+At2w+GFkLeBQokHV4L+QDdD54TIgRNSQ4LYRcE2Q
1WDecN7AoVG+YN3gb74huEL/vyBNAWuwgC+BP4JPhe+G/1+PT5Bfcbqf4ECgdCuBdf2g8Wa/kNrg
n+B8ICvR4MX/jAS3sHyAvmCicKAAuGJXwOeectGA39R0LN7ijI+Nn3+Or5JPk1+b75z/cbqMA3P/
KKDehL3guRDgUN7BTZHXkNWiyHPVYHcrgFRr8YkR/b3gbreApKC8cNGQETCXgf/VYIiwmS+aP5tP
nu+f/6iP36mfcbq4Br9zmNBilTG3IF8sQA3Qi8ekc9wAd9rQa//VoatfAi/aCtugveDRcLcg/7PS
vyFNIIkDpc+m36fvq4//rJ+3/7kPcbq/IN4Qip9BEP+1P7ZPt1+6/7wPwZ+/r8C/98HPwt9x50Tb
0KVC32FsQTve8N4xedvQ26B90G4nX32Q21DVossh2uBzjFBwu5XAl4Eo3vLLoEwAJ0Bg+68xtJB5
xG/Ff8aPx5/Ir/0rI2PbAYlRDdDLIt7w4CD6KSuASdwwLGCksCNA9DDd4EJjifDLcX2QQd9L3gL/
fdDOP89P0F/Rb9J/iASvUMmj0GVkmNN5J69RoaD7K7BAYHDdUswkf/GIQ33w/33QmNCIUn9RihOk
sMyC18//2N/Z79r/3A8rI4pRe9CYEf0cQHNsULCwr1CiMItRLTD+ctWBItCvEfQgfiKIsCuA7lcr
4JeByyEniQPNVJjQ/8sh4Y/in+Ov5L/lzysjTED+Z7JwymbhISzQfuHK8aRx/8vUilKJkX7il4Gv
inv2o7P/63/sj+2f7q/vv/hf9m/3f//4j/mfyXmiIcw0jBJAcX2hzmTK8BEwa7BlP4mAzED3E0Cv
dKPBZKPQfpF+ITbB/yxg+y/8P/1P/l//b9OEKKBfl0Ch8KHwrfHogSARgGN+bMvRf3FsIqIwrfKl
MnP/ApCkEKRxiOAC0tPQAbSMAv8EfwWPBp8Hrwi/oQQDZr2x/XyAd7SQfzCjwfNTQHAfsH9BgA4/
D08QXxYfFy9V6Uj31CGksGtWLBjvGf8YDx0P/x4fVemkEIhQC+EK0swzsLH/iHB90LIgrfBAgBXf
IN8e7e5ZoiCY0+kCchWhCwCKIOse4aRiba5wcd5QiFK0kfukcdagdIigr1CjkM4QJFD+M5cw3ZF9
0IhwjAIkryW//x7tlSJ7oH9T3WB90Iiwo5D/A5DpQYpSTAXK8AqS6qEpZP/M4IqxiEOKUaRGLC8t
Px78/HN1fyGlgq3iKWOj830G/yoy6KAroRSzf6R7wYhWiOL/M580rx781vWI8OmylxGvh+eiVKIw
o7IgO4pDzXFpIP1rgHe0cyo5Or87zx78TLZ/fwPV0TaQP4PVYTaiiZNJ/7AkMuTVkoxQKtGksEwF
AdH91pQ/Qf9DDx7/Se9K/yIv/0y/Tc9L31BPUV9Sb1N/VI//VZ8Rz/o/Vj9XT1hfWW9af/1yQUOX
AH0gHL9cn12vXr//X89yBWtfYb9iz2PfZO9l//9rL2k/ak9rX2xvcH9uj2+f93M/cb9miy15L3o/
e098X39zj3Sfda92v3fPZwM30m+SZpXAY2ne8CBVOBGwLVRvLYPiNoFwJFA/l+HogUYAg0GKQ9aF
SFT8VFBn0DgjfX9+j3+fgK/rgb9nA1DXAGqiYJTwhy//iD+JT4pfi29nA4bAylCQTwuQ0LJJPI+o
VVJMOhmTLjxBL3DLcGY9IsGycHRwOi8vl4K+sOVE9C7gEGcvAbFhgI9A9bQwLrJyIo6JkGDMwDJw
OmSQYmYC4CPgtDB7SAhZUEWVwElOSyDnl3+Yj5mUfX2aoQLgmTHAdFxjZjFcAtCPIP+Pt5yPnZ+y
cpGXkYdzYKMvyZAeOTKOQC9BjoCTL/+RX2bWCtLgArUBCtCNP45P/49fpx+oL4K1SID00DaQshDO
Y76AP0DgQGUt6LDM0NY6AaJhgC2wSUChPqp/v6uPrJ+tr66/tn+3gm6wgMJwt+lcJ2EwuK+5v/u6
z2b0IrwvvT+7b79/wI//qRfXAOdR1sHnoCiQmXCxdv/FhLHvsv+0D7UfwX+3P68P/kYK4emQ56AK
goOxP2Hosc5kJ9GxHD5wbHDHj8if/8mvyr/Lz8zf1L/Sz9Pf1O//1f/aD9gf2S/cz93f3u/f///h
D+IefG/nH+gv6T99b+Qf/07Pgz+ET4VfhmqMv+rv6///4rSS75P/lQ+WH5cvoX+ZT/+aX5tv+Z/6
r56fn6+gv/+v/6Lfo++k/6YP2q/bv6k/qk//8u/z/7AfsS/HH9GPDT8OT/8Hj8LfwQ8WTxdfvl8Z
Xxpv/xifHK8dv8S/xc8RfxKPE5//FK8eds4/z0/QXyT/Jg8nHy8enyz/Lg8vHzUwMS9GuE9OVDCJ
Bd/28FxJQH5yNGgxiDEgNaExjwlmNyUIolAI/TEw+PEvRIxJVjO/N99nNTgIsZBCT0RZCP0yNwix
KYZwTUwwgH0/QB4ANRABAAAARQAAADw0MEQ1RTNDM0NCRTAzRDQ1QTc3NkU3QzM1OEJERTkwODE2
NjAzOUBtaXNzb3VsYS5mb3JtYXRkeW5hbWljcy5jb20+AAAAAB4AORABAAAAYwAAADw0OTkxMjkw
Ni42MDgwOTA4QGluZm9zZXJ2aWNlcy5pbj4gPGdtcnJzciRmNDgkMUBnZXIuZ21hbmUub3JnPiA8
NDk5MjU1NjcuMzA4MDUwMUBpbmZvc2VydmljZXMuaW4+AAAeAEcQAQAAAA8AAABtZXNzYWdlL3Jm
YzgyMgAACwDyEAEAAAAfAPMQAQAAAHgAAABSAEUAJQAzAEEAIABbAHUAcwBlAHIAcwBAAGgAdAB0
AHAAZABdACAAIABSAGUAJQAzAEEAIABvAHAAdABpAG0AaQB6AGkAbgBnACAAYQBwAGEAYwBoAGUA
IAB3AGUAYgAgAHMAZQByAHYAZQByAC4ARQBNAEwAAAALAPYQAAAAAEAABzB7miCLGIzJAUAACDCt
jKnrGYzJAQMA3j+vbwAAAwDxPwkEAAAeAPg/AQAAABIAAABBbnRob255IEouIEJpYWNjbwAAAAIB
+T8BAAAAZgAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1GT1JNQVQgRFlOQU1JQ1Mv
T1U9RklSU1QgQURNSU5JU1RSQVRJVkUgR1JPVVAvQ049UkVDSVBJRU5UUy9DTj1BQklBQ0NPAAAA
HgD6PwEAAAAVAAAAU3lzdGVtIEFkbWluaXN0cmF0b3IAAAAAAgH7PwEAAAAeAAAAAAAAANynQMjA
QhAatLkIACsv4YIBAAAAAAAAAC4AAAADAP0/5AQAAAMAGUAAAAAAAwAaQAAAAAADAB1AAAAAAAMA
HkAAAAAAHgAwQAEAAAAIAAAAQUJJQUNDTwAeADFAAQAAAAgAAABBQklBQ0NPAB4AMkABAAAAGAAA
AGpveWRlZXBAaW5mb3NlcnZpY2VzLmluAB4AM0ABAAAAGAAAAGpveWRlZXBAaW5mb3NlcnZpY2Vz
LmluAB4AOEABAAAACAAAAEFCSUFDQ08AHgA5QAEAAAACAAAALgAAAAMAdkD/////CwApAAAAAAAL
ACMAAAAAAAMABhBdmjXUAwAHEHAJAAADABAQAAAAAAMAERAAAAAAHgAIEAEAAABlAAAARElEWU9V
Q09NUElMRUFQQUNIRUZST01TT1VSQ0VPUlVTRUFCSU5BUllQQUNLQUdFP0xJU1RBTlkzUkRQQVJU
WU1PRFVMRVNZT1VSRVVTSU5HLElGQU5ZRE9FU1RZUE9VU0VQSAAAAAACAX8AAQAAAEUAAAA8NDBE
NUUzQzNDQkUwM0Q0NUE3NzZFN0MzNThCREU5MDgxNjYwMzlAbWlzc291bGEuZm9ybWF0ZHluYW1p
Y3MuY29tPgAAAAA5bg==


------_=_NextPart_001_01C98C19.EB9DA0EB
Content-Type: text/plain; charset=us-ascii

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
------_=_NextPart_001_01C98C19.EB9DA0EB--