[rt-users] Web interface is slow

[Ruslan U. Zakirov]

Hello, Jaime. AFAI understand you have problem only with tickets that 
was imported from old system. 151MB memory usage is very big for 17 
transactions. Could you turn on DB query log and send it. I expect some 
loop in it.

			Best regards. Ruslan.

PS: May be this ticket has a lot of file attachments...

Jaime Kikpole wrote:
>     Ever since upgrading to the 3.x series, I've had very slow 
> performance on the web interface for RT.  Maybe I don't notice this on 
> the email interface because it only makes small transactions instead of 
> trying to view the 17 comments in the ticket's history.  So, for all I 
> know I'm barking up the wrong tree.
> 
>     I do know that performance is so bad that certain very long tickets 
> do not even load after 15 minutes.
> 
> RT 3.2.2
> FreeBSD 4.10
> Apache 1.3.33
> mod_perl 1.29
> MySQL 4.0.21
> DBIx::SearchBuilder version 1.15 and 1.16 have been tried with the same 
> results
> Almost 5000 tickets
> 7 users that login
> email interface available over postfix 2.0
> 
>     I've tried to install RT 3.2.2 on a different server (athena) and 
> reference the DB storage on the first server (zeus).  Watching "top" on 
> both of these servers shows the mysqld process on zeus to be barely used 
> at all while an httpd process on athena consumes all available CPU time 
> for well over a half hour (and still going, so I don't know how long it 
> will take) and a lot of memory (151MB and still climbing).  This ticket 
> displayed fine in RT version 2.0.15.
> 
>     The migration from 2.0.15 to 3.2.2 involved an upgrade to 3.0, use 
> of the migration tools, and then another upgrade to 3.2.  Since this 
> effects the DB storage and not the web GUI, I'm not sure if this is 
> relevant.  The use of the FreeBSD ports collections was attempted, but 
> manual installation from source was found to work better.  Its been a 
> few months since I've done this, so please forgive me for forgetting 
> *how* it worked better.  I think that it just didn't vs. did work, but I 
> am not completely certain.
> 
>     The command line interface appears to want a password but none that 
> I try work.  My shell username is the same as my RT username, but that 
> password and the DB user password do not work.  I'm not sure if this is 
> related.
> 
>     Are there any tips that anyone can offer?
> 
>                             Thanks in advance,
>                             Jaime
> 
> -- 
> Network Administrator
> Cairo-Durham Central School District
> http://cns.cairodurham.org
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com