[rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

[Steve Ison]

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
# User at Host: 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
si202 at cam.ac.uk