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.
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)
St George’s, University of London
London SW17 0RE
+44 20 8725 5160
St George’s, University of London is proud to be a Stonewall Diversity Champion: ‘people perform better when they can be themselves’.