php, mysql and apache2 slow?

[smartt]

hi everbody,

i´ve installed apache 2.045 and php4.3.1 and mysql 3.23 on a debian woody machine. Now i notice that all pages using data from mysql are 4 to 5 times slower than in my previous configuration (apache 1.3, php4.3.0 and mysql3.23)! is apache 2 the problem or does anyone know the solution?

thanks in advance, smartt

[Sxooter]

Do you have logging turned on for apache and mysql? you might wanna look at upping the log level and see if there's anything there that helps.

Either that, or profile your code to see if it's the database running slow or the web server / php code.

[smartt]

hi,

i don´t know what you mean exactly, but logging is turned on in apache2 by default to log level warn.
i don´t think that my mysql is to slow:

select benchmark(1000000,1+1);
+------------------------+
| benchmark(1000000,1+1) |
+------------------------+
| 0 |
+------------------------+
1 row in set (0.12 sec)

also my php-code are only a simple select of about 100 rows which takes about 5-7 seconds to build the page. the exactly same page on my apache 1.3 took only about 1-1,5 seconds.

bye, smartt

[Sxooter]

Well, the problem could be anywhere.

Try storing microtime stamps at various places in your code and then printing them out to see which section is taking the longest.