Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:93116
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain schlueters.de from 217.114.215.10 cause and error)
Message-ID: <1462729893.13652.28.camel@kuechenschabe>
To: Raja Kulasekaran <cullsin@gmail.com>
Cc: internals@lists.php.net
Date: Sun, 08 May 2016 19:51:33 +0200
In-Reply-To: <CAMMzK+=B=3WxrWkx6EPj9mHCSoxww_rUwiq_eHSm-v6LKKwqpg@mail.gmail.com>
References: 
	<CAMMzK+=B=3WxrWkx6EPj9mHCSoxww_rUwiq_eHSm-v6LKKwqpg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] How to get trace of all database queries executed by
 php
From: johannes@schlueters.de (Johannes =?ISO-8859-1?Q?Schl=FCter?=)

Hi,

On Fri, 2016-05-06 at 19:34 -0400, Raja Kulasekaran wrote:
> Is there any php extension available which help me out to give the
> statistics of
> all the queries execution details ?

if you are on a development machine (thus no unrelated traffic)
something like a query log (in MySQL general_log) might be the quickest
and most simple way. However if you're using MySQL you might also look
at pecl.php.ne/mysqlnd_uh which allows to overload low level calls in
mysqlnd (thus below PDO or mysqli or so) from userland and adding your
own logging logic.
See http://php.net/manual/en/mysqlnd-uh.quickstart.query-monitoring.php

Maybe you should also check the license agreement of the software you're
using. Some people try to disallow that. (I can't tell whether such
rules might be relevant and binding)
 
johannes