php-fpm is very very slow...

[SplitIce]

a) not nginx related
b) not even php-fpm related

its a slow mysql query.

2011/9/5 LiuXin <sy.meteor at msn.com>

>   Hi all,
>  After upgrade from php 5.3.6 to php 5.3.8, now php-fpm is very very slow.
> Even I tried to roll back to php 5.3.6, it still doen't work.
>  And there are lots of errors in php-fpm.log,
>
> [04-Sep-2011 12:28:27] WARNING: [pool www] child 18793, script
> '/web/www/forum.php' (request: "GET /forum.php") executing too slow
> (60.073197 sec), logging
> [04-Sep-2011 12:28:27] WARNING: [pool www] child 18784, script
> '/web/www/forum.php' (request: "GET /forum.php") executing too slow
> (60.080807 sec), logging
> [04-Sep-2011 12:28:27] NOTICE: child 18793 stopped for tracing
> [04-Sep-2011 12:28:27] NOTICE: about to trace 18793
> [04-Sep-2011 12:28:27] ERROR: ptrace(PT_IO) failed: Bad address (14)
> [04-Sep-2011 12:28:27] NOTICE: finished trace of 18793
> [04-Sep-2011 12:28:27] NOTICE: child 18784 stopped for tracing
> [04-Sep-2011 12:28:27] NOTICE: about to trace 18784
> [04-Sep-2011 12:28:27] ERROR: ptrace(PT_IO) failed: Bad address (14)
> [04-Sep-2011 12:28:27] NOTICE: finished trace of 18784
>
> And in php-fpm.slow
>
> [04-Sep-2011 12:27:30] [pool www] pid 18622
> script_filename = /web/www/forum.php
> [0x000000080455aaa8] mysql_query() /web/www/source/class/class_core.php:815
> [0x000000080455a958] query() /web/www/source/class/class_core.php:1003
> [0x000000080455a858] _execute() /web/www/source/class/class_core.php:977
> [0x00000008045591a0] query()
> /web/www/source/module/forum/forum_viewthread.php:514
> [0x0000000804559058] +++ dump failed
>
>  And one can help me about this issue?
> My server is running Freebsd 8.1 + nginx + php 5.3.8
>
> _______________________________________________
> nginx mailing list
> nginx at nginx.org
> http://mailman.nginx.org/mailman/listinfo/nginx
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.nginx.org/pipermail/nginx/attachments/20110905/3a09f7f5/attachment.html>