php-fpm is very very slow...

[LiuXin]

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 at 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 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





--------------------------------------------------------------------------------
_______________________________________________
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/d4671212/attachment.html>