Re: How to get trace of all database queries executed by php

Le sam. 7 mai 2016 à 02:18, Wim Godden <wim.godden@cu.be> a écrit : > 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/ MySQL Proxy is indeed what I mostly used, I've shared a few LUA scripts to help logging/debugging/profiling them: https://github.com/patrickallaert/MySQL-Proxy-scripts-for-devs > > For Postgres : > > > http://www.microhowto.info/howto/log_all_queries_to_a_postgresql_server.html > > Kind regards, > > Wim > > -- > PHP Internals - PHP Runtime Development Mailing List > To unsubscribe, visit: http://www.php.net/unsub.php >