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 # u...@host: rt[rt] @ localhost [] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600); # u...@host: rt[rt] @ localhost [] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600); # u...@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
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com