[rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries
Roy El-Hames
rfh at pipex.net
Tue Dec 5 09:42:39 EST 2006
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 <efeldhusen.lists at gmail.com>:
>>
>> 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
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
More information about the rt-users
mailing list