Re: DB troubleshooting with PDO

From: Date: Sat, 18 Mar 2006 13:47:04 +0000
Subject: Re: DB troubleshooting with PDO
References: 1 2 3  Groups: php.pecl.dev 
Request: Send a blank email to pecl-dev+get-3621@lists.php.net to get a copy of this message
Yes, I was aware of that. Basically what I was doing prior to PDO, I had a database class that if in debug mode recorded each sql query and how long it took. I would output this data prior to xdebug data which made it real easy to track down slowdowns and redundant querys. So while yes I can check the logs this provided a cleaner instant access to all the development info I needed in one location. Richard Thomas - CEO Cyberlot Technologies Group Inc. 507.398.4124 - Voice David Tulloh wrote:
Mysql has a query log where it writes all the sql statements recieved, you will probably have to enable it. I suspect that this would be easier than adding hooks in PHP. David Richard Thomas wrote:
Is it possible to somehow pull the final string submitted to mysql when you do a prepare/execute? What I would like to do is log all the querys in debug mode for troubleshooting and be able to review them afterwards.


« previous php.pecl.dev (#3621) next »