Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:93105
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain cu.be from 194.50.97.15 cause and error)
To: internals@lists.php.net
References: <CAMMzK+=B=3WxrWkx6EPj9mHCSoxww_rUwiq_eHSm-v6LKKwqpg@mail.gmail.com>
Organization: Cu.be Solutions
Message-ID: <34286ced-d10e-beb5-b0b6-4b86947c9da3@cu.be>
Date: Sat, 7 May 2016 02:18:04 +0200
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:45.0) Gecko/20100101
 Thunderbird/45.0
MIME-Version: 1.0
In-Reply-To: <CAMMzK+=B=3WxrWkx6EPj9mHCSoxww_rUwiq_eHSm-v6LKKwqpg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] How to get trace of all database queries executed by
 php
From: wim.godden@cu.be (Wim Godden)

On 7/05/2016 1:34, Raja Kulasekaran wrote:
> I have encrypted php Application codebase which I may or may not have
> access.
>
> So, I would like to know how the application behaving / profiling Database
> queries through the .so or .dll level .
>
> Is there any php extension available which help me out to give the
> statistics of
> all the queries execution details ?
>

Most DB servers will allow you to do this directly or indirectly.

If you're using MySQL, there's a few options :
- General query log (don't do this on a busy production server since it 
will produce massive log files and the I/O alone could bring down your 
server) : http://dev.mysql.com/doc/refman/5.7/en/query-log.html
- MySQLProxy : 
http://philippeback.be/2013/02/logging-mysql-queries-with-mysqlproxy/

For Postgres : 
http://www.microhowto.info/howto/log_all_queries_to_a_postgresql_server.html

Kind regards,

Wim