[rt-users] Query Tracing

Raed El-Hames rfh at vialtus.com
Thu Jul 2 04:33:29 EDT 2009


I think I have mailed you this before, to log the sql queries within RT 
you need to add the following line to you RT_SiteConfig.pm file
# DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be
# the level that you wish SQL statements to be logged at.

Then restart the web server, at that point any sql query called will be 
logged to your rt.log file, if not enough logging is been written you 
can increase the level of logging by increasing 1 to 2 or 3 (not sure 
what each level log).

Also I would recommend you log at the sql level , not sure about Oracle 
but I am sure there is a tool or variable to allow you to log slow 
queries some where, or you can once you do show queries from the oracle 
commend line during creating a ticket.

By the way what version of DBIx::SearchBuilder and DBD you have 
installed, have you googled for common problems with the versions you 
have installed.
You can determine the version of modules you have installed by browsing 
to your:


Varun wrote:
> Hello All
> I want to trace queries that are dynamically firing in RT to track 
> where they are making application slow. But I m not able to find out 
> from where all queries are fired and from which file. My main concern 
> is to trace Insert query for ticket creation and Update queries. Do 
> any one has idea where I can find all this queries in which file.
> Any help is highly appreciated.
> Thanks & Regards
> Varun Vyas

More information about the rt-users mailing list