Hi list,
we've been having some issues with RT (4) becoming very slow at times. By using
mytop, I've realised that there are often SQL sessions showing up as "slow" or
completely froze such as:
577 rt_user localhost rt4 234 Query SELECT
GET_LOCK('Apache-Session-d5370769b644a8e12a7df739cf100b8a', 3600) ?
This one, with process id 577, never goes away for example. Others appear and
disappear.
How can I identify what's running this session? I suspect this might be linked
to some users running heavy searches, and what I read online in the archives
seems to confirm the suspicion.
Any idea would be welcome.
Thanks,
Giuseppe
--
Giuseppe Sollazzo
Senior System Analyst
Member of the Open Data User Group (Cabinet Office)
Member of the Technical Standards Board (Cabinet Office)?
Member of the Health and Social Care Transparency Panel (Department of Health)
Computing Services
Information Services
St George's, University of London
Cranmer Terrace
London SW17 0RE
[email protected]
+44 20 8725 5160
@sgulit
St George's, University of London is proud to be a Stonewall Diversity
Champion: 'people perform better when they can be themselves'.
[http://www.sgul.ac.uk/images/misc/diversity_logo_with_text.jpg]
