MySQL/PHP Bottleneck

kid_c

Hola,

I'm running MySQL 4.0.13-standard, PHP 4.2.3 and Apache 1.3.29

MySQL is on a Linux server, Redhat 7.1, while the PHP/Apache is on FreeBSD 4.8-stable

I've noticed that sometimes, httpd processes take upto 10-11% CPU instead of the normal < 1%

I've gone over Apache settings amny times and tried different things, but I've come to the conclusion the problem is either my PHP or a query my pages are doing maybe.

My problem is I have tons of pages, scripts, etc...that run.

What is the best way to go about finding my problem, if indeed its from PHP/mysql ??

Thx

Frederick

post example of one of your querys so someone can help. the number of pages does not make a difference.

bastien

Add a timer to each page....on opening take a timestamp, on closing take a timestamp and write it out to the page...see what the times are like..

If the time is low and the system's not slowing due to load, then I would not worry

ravenlock

I think that slow queries would show up as mysql threads eating resources, not httpd threads. So it's either Apache or PHP. Can you check your access logs to see what pages were being requested at that time?

kid_c

Frederick, I have so many different queries form different pages I wouldn't know which to post =)....All have been tested and site is fast even with tables having 1 million rows +

ravenlock, bastien: Those are some good ideas I will try out.