Yes, me too, i have the same problem, killing after a time apache.....argh..
2006/12/5, Steve Ison <[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?
Thanks,
Steve.
--
Stephen Ison
Unix Support
University of Cambridge Computing Service
[EMAIL PROTECTED]
_______________________________________________
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
