<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p style="margin-top: 0px; margin-bottom: 0px;">Hi list,<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">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:<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"></p>
<p style="margin-top: 0px; margin-bottom: 0px;">577 rt_user localhost rt4 234 Query SELECT GET_LOCK('Apache-Session-d5370769b644a8e12a7df739cf100b8a', 3600) <br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">This one, with process id 577, never goes away for example. Others appear and disappear.<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">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.<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">Any idea would be welcome.<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">Thanks,<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">Giuseppe</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<div id="Signature">
<div id="divtagdefaultwrapper" style="font-size:12pt; color:#000000; background-color:#FFFFFF; font-family:Calibri,Arial,Helvetica,sans-serif">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<pre><div style="font-family:Calibri,Arial,Helvetica,sans-serif">--</div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt"><strong>Giuseppe Sollazzo</strong></span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">Senior System Analyst</span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><pre style="background-color:rgb(255,255,255)"><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">Member of the Open Data User Group (Cabinet Office)<br style=""></span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">Member of the Technical Standards Board (Cabinet Office)<br style=""></span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">Member of the Health and Social Care Transparency Panel (Department of Health)<br style=""><br></span></div></pre></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">Computing Services</span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">Information Services</span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">St George's, University of London</span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">Cranmer Terrace</span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">London SW17 0RE</span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><br style="font-size:8pt"></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">gsollazz@sgul.ac.uk</span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">+44 20 8725 5160</span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-size:8pt">@sgulit</span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif"><br style="font-size:8pt"><span style="font-size:8pt; background-color:white"><b style=""><i><font color="black" face="Helvetica,sans-serif"><span lang="en-US">St George’s, University of London is proud to be a Stonewall Diversity Champion: ‘</span></font><font color="black" face="Helvetica,sans-serif"><span lang="en">people perform better when they can be themselves’.</span></font></i></b><font face="Helvetica,sans-serif"><br> </font></span><br></div></pre>
</div>
</div>
</div>
</div>
<div style="margin: 10px; padding: 10px; height: auto; width: auto; border: none; background-color: #FFFFFF;">
<img src="http://www.sgul.ac.uk/images/misc/diversity_logo_with_text.jpg" border="0">
</div>
</body>
</html>