Roy, Yes, we clean it 4 times the day!!! A this moment, everytime rt goes slower, i pick up the process by hand and kill them, not the best way, but the only working at this moment :-(
Torsten 2006/12/5, Roy El-Hames <[EMAIL PROTECTED]>:
Torsten; One other thing ..how big is your sessions table, do you clean it regularly (delete old sessions) Roy Torsten Brumm wrote: > At this moment, we have round about 500.000 Tickets in 700 Queues, > 26.000Users > > Torsten > > 2006/12/5, Eric J. Feldhusen <[EMAIL PROTECTED]>: >> >> Just curious, how many tickets are in your RT installation? >> >> Torsten Brumm wrote: >> > But with MySQL 4.12 and apache 2 with FastCGI >> > >> > 2006/12/5, Steve Ison <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>: >> > >> > Hello, >> > >> > My RT installation (3.6.1, MySQL 5, Apache 1.3, mod_perl 1.9, >> > DBIx::SearchBuilder v1.45) has slowed considerably as the >> number of >> > tickets has grown. In the MySQL slow query log I see: >> > >> > # Time: 061205 11:52:19 >> > # [EMAIL PROTECTED]: rt_user[rt_user] @ localhost [] >> > # Query_time: 181 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 >> > SELECT GET_LOCK('Apache-Session-b59f829ebcd37237783322425399eeb2', >> > 3600); >> > >> > While this is happening apache just spins using all the cpu. >> > >> > While trawling back the the mailing-list archives I noticed others >> have >> > had this problem, but I can't find any mention of a solution. Am I >> > missing >> > it or is this an ongoing problem? >> >> -- >> Eric Feldhusen >> Network Administrator http://www.remc1.org >> [EMAIL PROTECTED] >> PO Box 270 (906) 482-4520 x239 >> 809 Hecla St (906) 482-5031 fax >> Hancock, MI 49930 (906) 370 6202 mobile >> _______________________________________________ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: [EMAIL PROTECTED] >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> > > > > ------------------------------------------------------------------------ > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com
-- MFG Torsten Brumm http://www.torsten-brumm.de
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
