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
-- 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
