Status: Solved
Priority: Medium
Security: Public
Views: 380
Last Modified: 2009-07-29

Transparent wrapper around DBI for debugging purposes

I have a large code base (which runs under mod_perl) to which I would like to add some debugging code.

I would like to be able to run a bit of code everytime DBI is used to connect, prepare or execute. How can I add this debugging code _without_ editing every call to those methods and _without_ editing the DBI module itself.

dorward

Asked: 2004-09-08

Advertise Here

Perl

1 Solution

LVL 18

kanduraCommented: 2004-09-08

DBI can generate debugging information itself:

set
DBI->trace(2 => "/tmp/logfile");
somewhere near the top of your script.
Or set the environment variable
DBI_PROFILE=2

See manuals for DBI::Profile and DBI::Trace.

(Found this at http://www.class-dbi.com/cgi-bin/wiki/index.cgi?SeeAllSQL)

LVL 18

kanduraCommented: 2004-09-08

Also see DBI::ProfileDumper::Apache.

Here's the synopsis from the manual:

Add this line to your httpd.conf:

PerlSetEnv DBI_PROFILE DBI::ProfileDumper::Apache

Then restart your server. Access the code you wish to test using a web browser, then shutdown your server. This will create a set of dbi.prof.* files in your Apache log directory. Get a profiling report with dbiprof:

dbiprof /usr/local/apache/logs/dbi.prof.*

When you're ready to perform another profiling run, delete the old files

rm /usr/local/apache/logs/dbi.prof.*

and start again.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Transparent wrapper around DBI for debugging purposes

Join & Write a Comment Already a member? Login.

Featured Post