[rt-users] RT Query Logging

[Raed El-Hames]

Varun;

You should make it a habit to reply to the list and not individuals , I 
have never deployed RT with Oracle so can't help you --
few in the may though


ps: A pointer so you know what RT is capable of , our RT db is > 50G in 
size, the attachments table alone is > 26G, our db server is quad dual 
core with 16 G Ram (4x4) and the web server is standard 3.6G cpu with 3G 
Ram, average per day tickets is ~ 1000 with 200 internal users and 
10000+ external customer users.

Regards;
Roy

 



Varun Vyas wrote:
> We have deployed RT 3.6.3 on oracle 9i database as an backend
> in a medium sized firm and we have lots of tickets processed
> everyday more than 100. My problem is that the application is very
> irresponsive and very slow. We have already 8 gigs of RAM on our
> webserver with Apache 2.0 and fastCGI implemented. Also we have
> performed indexing on our oracle database with fastcgi implemented. But nothing seems to be going in our way. So please anyone can suggest wat will be the problem. I m looking for concerete answer to my problem. On which side i need to tune on application side or on database side and if on both side what step i need to take to make my application lightning fast.With acceptable level of performance.
>
> And i have looked for all this things in google and have searched a lot from past two months but has found nothing.
>
>
>
> Raed El-Hames wrote:
>   
>> 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
>>>>>
>>>>>         
>>>>>           
>>>>     
>>>>         
>>>   
>>>       
>>     
>
>
>