[rt-users] Identifying sessions

[Giuseppe Sollazzo]

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

gsollazz at sgul.ac.uk
+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]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20150316/174a1a1e/attachment.htm>