# Php-fpm is very very slow

**URL:** <https://www.ruby-forum.com/t/php-fpm-is-very-very-slow/211467>\
**Category:** NGINX\
**Created:** [September 5, 2011, 4:42am UTC](https://www.ruby-forum.com/t/php-fpm-is-very-very-slow/211467 "2011-09-05T04:42:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dubstep](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/cdc98d/32.png) [@dubstep](https://www.ruby-forum.com/u/dubstep)\
**Post date:** [September 5, 2011, 4:42am UTC](https://www.ruby-forum.com/t/php-fpm-is-very-very-slow/211467/1 "2011-09-05T04:42:30Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![LiuXin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/ac91a4/32.png) [@LiuXin](https://www.ruby-forum.com/u/LiuXin)\
**Post date:** [September 5, 2011, 4:56am UTC](https://www.ruby-forum.com/t/php-fpm-is-very-very-slow/211467/2 "2011-09-05T04:56:39Z")

</div>

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

its a slow mysql query.

2011/9/5 LiuXin [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![LiuXin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/ac91a4/32.png) [@LiuXin](https://www.ruby-forum.com/u/LiuXin)\
**Post date:** [September 5, 2011, 5:52am UTC](https://www.ruby-forum.com/t/php-fpm-is-very-very-slow/211467/3 "2011-09-05T05:52:45Z")

</div>

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: removed\_email\_address@domain.invalid  
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 [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

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  
removed\_email\_address@domain.invalid  
[nginx Info Page](http://mailman.nginx.org/mailman/listinfo/nginx)

---

<div class="post-metadata">

**Author:** ![LiuXin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/ac91a4/32.png) [@LiuXin](https://www.ruby-forum.com/u/LiuXin)\
**Post date:** [September 5, 2011, 5:58am UTC](https://www.ruby-forum.com/t/php-fpm-is-very-very-slow/211467/4 "2011-09-05T05:58:55Z")

</div>

On Mon, Sep 5, 2011 at 10:52 AM, LiuXin [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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

---

<div class="post-metadata">

**Author:** ![LiuXin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/ac91a4/32.png) [@LiuXin](https://www.ruby-forum.com/u/LiuXin)\
**Post date:** [September 5, 2011, 7:34am UTC](https://www.ruby-forum.com/t/php-fpm-is-very-very-slow/211467/5 "2011-09-05T07:34:26Z")

</div>

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

MagicBear

Posted at Nginx Forum:

> **[Re: php-fpm is very very slow...](https://forum.nginx.org/read.php?2,214766,214773#msg-214773)**
>
> 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,...
