Php-fpm is very very slow

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

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

its a slow mysql query.

2011/9/5 LiuXin [email protected]

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: [email protected]
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 [email protected]

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
[email protected]
nginx Info Page

On Mon, Sep 5, 2011 at 10:52 AM, LiuXin [email protected] wrote:

Hi SplitIce,

Do you mean this problem is casued by mysql? Thanks

[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

You can check iowait, Discuz when have many of data, suggest you using
MySQL Cluster to process.

MagicBear

Posted at Nginx Forum: