Hello,

I am running php 5.3.8 with php-fpm. I tried to enable slow queries to
troubleshoot the server load

[03-Apr-2012 08:39:29] [pool www] pid 18042
script_filename = /var/testsite/www/index.php
[0x0000000001e0e520] mysql_connect() /var/testsite/www/database.php:71
[0x0000000001e0e3f0] connect()/var/testsite/www/database.php:27
[0x0000000001e0e288] __construct() /var/testsite/www/include.php:92
[0x0000000001e0e168] +++ dump failed

Do you know what the last line means? Is it a bug? How do i analyze these
logs?

Thanks in advance


-Vij

On 04/03/2012 07:46 PM, vij wrote:
> Hello,
>
> I am running php 5.3.8 with php-fpm. I tried to enable slow queries to troubleshoot the server load
>
> [03-Apr-2012 08:39:29] [pool www] pid 18042
> script_filename = /var/testsite/www/index.php
> [0x0000000001e0e520] mysql_connect() /var/testsite/www/database.php:71
> [0x0000000001e0e3f0] connect()/var/testsite/www/database.php:27
> [0x0000000001e0e288] __construct() /var/testsite/www/include.php:92
> [0x0000000001e0e168] +++ dump failed
>
> Do you know what the last line means? Is it a bug?

It's "ok", the method used to get these traces isn't quite reliable.

> How do i analyze these logs?

Well, from the backtrace it seems that mysql_connect() in index.php is doing really slow, at least that's where the trace points.

--
Wbr,
Antony Dovgal
---
http://pinba.org - realtime profiling for PHP

Thanks for the response. I had been using strace to find which part of the
code taking time. But as am running very large number of fpm childs its not
easy to sample all. Is there any other tool which i can use for this ?

-Vij



On Tuesday, 3 April 2012 21:35:40 UTC+5:30, tony2001 wrote:
>
> On 04/03/2012 07:46 PM, vij wrote:
> > Hello,
> >
> > I am running php 5.3.8 with php-fpm. I tried to enable slow queries to
> troubleshoot the server load
> >
> > [03-Apr-2012 08:39:29] [pool www] pid 18042
> > script_filename = /var/testsite/www/index.php
> > [0x0000000001e0e520] mysql_connect() /var/testsite/www/database.php:71
> > [0x0000000001e0e3f0] connect()/var/testsite/www/database.php:27
> > [0x0000000001e0e288] __construct() /var/testsite/www/include.php:92
> > [0x0000000001e0e168] +++ dump failed
> >
> > Do you know what the last line means? Is it a bug?
>
> It's "ok", the method used to get these traces isn't quite reliable.
>
> > How do i analyze these logs?
>
> Well, from the backtrace it seems that mysql_connect() in index.php is
> doing really slow, at least that's where the trace points.
>
> --
> Wbr,
> Antony Dovgal
> ---
> http://pinba.org - realtime profiling for PHP
>
>

maybe you can use core file and gdb to debug your program