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@xxxxxxxxxx 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/
|