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

[Eric J. Feldhusen]

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 <si202 at cam.ac.uk <mailto:si202 at cam.ac.uk>>:
> 
>     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?

-- 
Eric Feldhusen
Network Administrator    http://www.remc1.org
eric at remc1.org
PO Box 270              (906) 482-4520  x239
809 Hecla St            (906) 482-5031 fax
Hancock, MI  49930      (906) 370 6202 mobile