[rt-users] RT Performance - Intermittent slow spells

Aaron Guise aaron at guise.net.nz
Mon Mar 16 19:49:14 EDT 2009


Hi,
We are currently having some intermittent problems where our RT stops
responding.  I have isolated this I think to a database problem of some
sort.  I turned on Slow Query logging and this is what MySQL picked up.  Any
ideas what may cause such performance issues.  It is intermittent but very
annoying when it does occur.  I have tuned the DB with mysqltuner and when
it does run proper then it really hums along.

# Time: 090317 12:42:29
# User at Host: rt[rt] @ localhost []
# Query_time: 11  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600);
# User at Host: rt[rt] @ localhost []
# Query_time: 11  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600);
# User at Host: rt[rt] @ localhost []
# Query_time: 11  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600);

-- 
Regards

Aaron
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090317/63dd0c17/attachment.htm>


More information about the rt-users mailing list