Hi, <div><br></div><div>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. </div>
<div><br></div><div><div># Time: 090317 12:42:29</div><div># User@Host: rt[rt] @ localhost []</div><div># Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 0</div><div>SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600);</div>
<div># User@Host: rt[rt] @ localhost []</div><div># Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 0</div><div>SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600);</div><div># User@Host: rt[rt] @ localhost []</div>
<div># Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 0</div><div>SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600);</div><div><br></div><div>-- </div><div>Regards</div><div><br>
</div><div>Aaron</div><div><br></div></div>