Hi SplitIce,

Do you mean this problem is casued by mysql? Thanks

[04-Sep-2011 12:28:27] ERROR: ptrace(PT_IO) failed: Bad address (14)


From: SplitIce
Sent: Monday, September 05, 2011 10:55 AM
To: nginx@nginx.org
Subject: Re: php-fpm is very very slow...

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

its a slow mysql query.


2011/9/5 LiuXin <sy.meteor@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@nginx.org
http://mailman.nginx.org/mailman/listinfo/nginx





--------------------------------------------------------------------------------
_______________________________________________
nginx mailing list
nginx@nginx.org
http://mailman.nginx.org/mailman/listinfo/nginx_______________________________________________
nginx mailing list
nginx@nginx.org
http://mailman.nginx.org/mailman/listinfo/nginx