Help ! Optimize Apache2 and PHP

Hello everybody!

I need to optimize my Apache and my PHP and Mysql. Now my apache uses 90 %
of CPU when i run a query by the apliaction webpage.But when i make the same
query by mysql command it is very fastest.
Why my apache use 90% of CPU when i run a query by my webpage ??
Someone can help me???
Thz

Alex

Hi Alex,

On Apr 8, 2007, at 10:17 AM, Alejandro Decchi wrote:

> I need to optimize my Apache and my PHP and Mysql. Now my apache
> uses 90 % of CPU when i run a query by the apliaction webpage.But
> when i make the same query by mysql command it is very fastest.
> Why my apache use 90% of CPU when i run a query by my webpage ??
> Someone can help me???

The fact that no one has reacted to your repeatedly asking the same
question over the past couple of days usually indicates that no one
here truly understands your question, or knows the answer to it.

When you say Apache uses 90% CPU, is that out of the ordinary? I
would expect the kernel to grant all available CPU power to a process
that has work to do. Are you seeing unacceptable delays in page
display when you run your web app?

If I were you, I'd concentrate on the PHP code in your application.
Apache by itself is pretty fast, and you have already established
that executing the query in MySQL is not the problem (good
troubleshooting skill there).

So, that leaves the application code. Could you possibly be doing
something inefficient with the data once fetched from the database?
Unfortunately, this is not a forum for help with PHP optimization: if
you need more help with that please check php.net.

S.

--
sctemme@apache.org http://www.temme.net/sander/
Open Source Software Consultant
PGP FP: 51B4 8727 466A 0BC3 69F4 B7B8 B2BE BC40 1529 24AF

ApacheCon 2007 Europe, May 1-4 in Amsterdam
http://www.eu.apachecon.com/

Thank you very Much for your reply Sander Temme

On 4/8/07, Sander Temme <sctemme@apache.org> wrote:
>
> Hi Alex,
>
> On Apr 8, 2007, at 10:17 AM, Alejandro Decchi wrote:
>
> > I need to optimize my Apache and my PHP and Mysql. Now my apache
> > uses 90 % of CPU when i run a query by the apliaction webpage.But
> > when i make the same query by mysql command it is very fastest.
> > Why my apache use 90% of CPU when i run a query by my webpage ??
> > Someone can help me???
>
> The fact that no one has reacted to your repeatedly asking the same
> question over the past couple of days usually indicates that no one
> here truly understands your question, or knows the answer to it.
>
> When you say Apache uses 90% CPU, is that out of the ordinary? I
> would expect the kernel to grant all available CPU power to a process
> that has work to do. Are you seeing unacceptable delays in page
> display when you run your web app?
>
> If I were you, I'd concentrate on the PHP code in your application.
> Apache by itself is pretty fast, and you have already established
> that executing the query in MySQL is not the problem (good
> troubleshooting skill there).
>
> So, that leaves the application code. Could you possibly be doing
> something inefficient with the data once fetched from the database?
> Unfortunately, this is not a forum for help with PHP optimization: if
> you need more help with that please check php.net.
>
> S.
>
> --
> sctemme@apache.org http://www.temme.net/sander/
> Open Source Software Consultant
> PGP FP: 51B4 8727 466A 0BC3 69F4 B7B8 B2BE BC40 1529 24AF
>
> ApacheCon 2007 Europe, May 1-4 in Amsterdam
> http://www.eu.apachecon.com/
>
>
>
>
>