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