[rt-users] Slow down in RT w/ strange mysql-slow.log queries

[Adrian Carter]

Noticing lately that RT has really slowed down - its a never ending 
battle with shredder stripping spam versus the db filling... ANYWAY...

been getting a lot of these with in mysql-slow.log lately:

# Time: 061107  1:55:13
# User at Host: rt_user[rt_user] @ localhost []
# Query_time: 11  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT GET_LOCK('Apache-Session-b22c6874f84cb8e2ababf7c26a7c7a80', 3600);


This is after having run rt-clean-sessions.pl and freshly logging in - 
the moment this gets logged out the interface displays the ticket - 
prior to that its just hanging 'Transfering data...'

Has anyone got any suggestions ? Its mysql 4.1 on Debian-Sarge..

Thanks!

Adrian