Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:93104
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.220.174 as permitted sender)
MIME-Version: 1.0
Sender: yohgaki@gmail.com
In-Reply-To: <e6bbcae2-6319-e439-32c8-751e0fa4214d@gmail.com>
References: <CAMMzK+=B=3WxrWkx6EPj9mHCSoxww_rUwiq_eHSm-v6LKKwqpg@mail.gmail.com>
 <e6bbcae2-6319-e439-32c8-751e0fa4214d@gmail.com>
Date: Sat, 7 May 2016 09:15:36 +0900
Message-ID: <CAGa2bXaZEPMDU_BB5LFjWmijaZxofrZZA3RMQvecyqsO24qY5A@mail.gmail.com>
To: Stanislav Malyshev <smalyshev@gmail.com>
Cc: Raja Kulasekaran <cullsin@gmail.com>, "internals@lists.php.net" <internals@lists.php.net>
Content-Type: text/plain; charset=UTF-8
Subject: Re: [PHP-DEV] How to get trace of all database queries executed by php
From: yohgaki@ohgaki.net (Yasuo Ohgaki)

Hi,

On Sat, May 7, 2016 at 9:06 AM, Stanislav Malyshev <smalyshev@gmail.com> wrote:
>
>> Is there any php extension available which help me out to give the
>> statistics of
>> all the queries execution details ?
>
> I'm not sure there is an extension doing specifically that, but any
> profiler or debugger extension would be able to capture database calls,
> and thus have access to this data. They usually would not dump this
> information though, so one would need to modify them to do it. Also, you
> may have better luck just enabling query logging in your database, most
> databases allow to do that.

I would like to write one from years ago. It is not started yet, though.
We need such extension because database level logging is useless
without account information.

If anyone need it now, you may use RunKit for this purpose.
http://php.net/manual/en/book.runkit.php
Replace query execution function/method with your version and log
whatever you need.

Regards,

--
Yasuo Ohgaki
yohgaki@ohgaki.net