[rt-users] RT Query Logging

[Raed El-Hames]

Varun;

There is no straight forward answer to this , you possibly should start 
by stating your RT version, DB type(oracle,mysql ??) and version , 
apache, mod_perl or fastcgi  etc ..
Also search the wiki and mailing list there are lots of posts and a good 
article in the wiki covering this.(sorry don't remember the url).

Good luck;

Roy


Varun Vyas wrote:
> And i want to know one more thing as my RT is slow right now .What steps 
> should i take to increase its performance on application side or on 
> database side. We have remote database on our RT and it has 2 gigs RAM.
>
> Raed El-Hames wrote:
>   
>> From RT_Config.pm
>>
>> # DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be
>> # the level that you wish SQL statements to be logged at.
>> Set($StatementLog,undef);
>>
>> I am not sure what the different levels but :
>> Set($StatementLog,1);
>>
>> will be a good start.
>> Remember to restart your web server.
>>
>> Regards;
>>
>> Roy
>>
>>
>> Varun Vyas wrote:
>>     
>>> Hello All
>>>
>>> Can anyone can tell me how i can log my queries that hits my database 
>>> in RT.log. I am using oracle 9i and RT 3.6.3 we have a performance 
>>> issue as our RT is very slow and takes 15-20 seconds for database 
>>> operations. So i want to log my queries so that i can then analyze 
>>> them for performance optimisation. And also i m getting internal 
>>> server error frequently can any one tell me how can i correct it
>>>
>>> Any help in highly appreciated
>>>
>>>   
>>>       
>>     
>
>
>