<div dir="ltr">Hi Everybody,<div><br></div><div>We have a (reasonably) new install that has been grinding to a halt every week or two. When I look at 'top' on the command line (Red Hat) mysqld is hogging 100% CPU. When I use mysqladmin processlist I can see a number of sessions queuing behind this...</div><div><br></div><div><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN">| 104558 | doras | localhost | doras | Query | 1587 | statistics | INSERT INTO
`cache17312`(`pos`, `eprintid`) SELECT @i:=@i+1, `eprintid` FROM (SELECT `eprint`.`eprin
| 0.000 |</span></p><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN">The other processes (queued) are all waiting for table level lock and look like this...</span></p><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN"><br></span></p><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN">| 105134 | doras | localhost | doras | Query | 487
| Waiting for table level lock | UPDATE `eprint` SET
`edit_lock_user`='1037', `edit_lock_since`='1550139932', `edit_lock_until`='1550
| 0.000 |</span></p><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN">
</span></p><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN">| 105135 | doras | localhost | doras | Query | 486
| Waiting for table level lock | SELECT
`eprintid`,`rev_number`,`eprint_status`,`userid`,`importid`,`source`,`dir`,`datestamp_year`,`
| 0.000 </span></p><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN"><br></span></p><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN">Eventually the max http processes is reached and the system crashes. The only remedy is to restart httpd and mariadb.</span></p><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN"><br></span></p><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN">Any ideas what this insert into cache is and why it's locking the the system?</span></p><p class="MsoNormal" style="margin:0cm 0cm 10pt;line-height:115%;font-size:11pt;font-family:Calibri,sans-serif"><span lang="EN">Thanks for any guidance</span></p><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>Fran Callaghan</div><div>Dublin City University</div></div></div></div></div></div></div></div>
<br>
<pre style="background-color:rgb(255,255,255)"><i><p><font color="#929292" face="Verdana, sans-serif"><span style="font-size:10px;white-space:normal"><b>Séanadh Ríomhphoist/Email Disclaimer</b></span></font></p><p><font color="#929292" face="Verdana, sans-serif"><span style="font-size:10px;white-space:normal"><b>Tá an ríomhphost seo agus aon chomhad a sheoltar leis faoi rún agus is lena úsáid ag an seolaí agus sin amháin é. <a href="https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww4.dcu.ie%2Fiss%2Fseanadh-riomhphoist.shtml&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=%2BTlBkCbSYNAoKBUnVBHycuQ%2BKRfmiAUJmZAhiMEu4N0%3D&reserved=0" originalSrc="https://www4.dcu.ie/iss/seanadh-riomhphoist.shtml" shash="n5MMaWxbWAgaILH5FC9+AU0hFJkrqiu6eD5vNMj3sxHLr+KN3m7fExTF1AppVYtoBwdvKQAe81Vvf+P20moSo0kAeDGhP9tJLub342yaResRGjgVIxZsQe5Og1JTp/Sv+SeOhPKTfDvW4ibx+MStAx1fWkGvrb5CkHdaSIt89s0=" target="_blank">Is féidir tuilleadh a léamh anseo. </a></b></span></font></p><p><font color="#929292" face="Verdana, sans-serif"><span style="font-size:10px;white-space:normal"><b>This e-mail and any files transmitted with it are confidential and are intended solely for use by the addressee. <a href="https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww4.dcu.ie%2Fiss%2Femail-disclaimer.shtml&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=mTI50reeEZ%2BKCkPHKpKjooHNHNGdGgA2YDISZDYmQcw%3D&reserved=0" originalSrc="https://www4.dcu.ie/iss/email-disclaimer.shtml" shash="k2pJ8KbiHd2fwZ87QGrDUQ7dcKX89Um9BOlH2ReKHc9JZdKnfKgl3YZhDq/HRivkhTJGL4hlFqmidyeBIBLRa6FcrAEfKukUfOsSN0p/BPiveP+hCfEPRjvpQEGR8oc/2NQZZf2Z8UkMDpzfFFkIgohk32v61ErNWRkQLcL0cRQ=" target="_blank">Read more here.</a></b></span></font></p><div style="color:rgb(146,146,146);font-family:Verdana;font-size:10px;white-space:normal"><br></div><div style="color:rgb(146,146,146);font-family:Verdana;font-size:10px;white-space:normal"><br></div></i></pre>
<br>
<img src="https://www4.dcu.ie/sites/default/files/iss/images/DCU_Dec_.png"><br><div><a href="https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FDCU%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=84yNSETj96%2Fi80RtNfmXATYrkRd64SnHyZoT6iyyyyE%3D&reserved=0" originalSrc="https://www.facebook.com/DCU/" shash="g6lMtGPYq2crx8CepxUgoqIVf4gJjV+hGGhzaJ6FZOvJPwwR8NSZJUM6e5YcLtg5xvz09i5jyttWyztT4HJCLuPH3VVPC/RyDnWrutFqiLvHehmrJJ5U1x+i86PKvwSDIA1YhodQV0eqzo97gW5WIw3fvoqB3edCnWcuZg//30A=" target="_blank"><img src="https://www4.dcu.ie/sites/default/files/iss/images/dcuapps/socmedicons-06.png"></a><a href="https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FDublinCityUni&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=PDYXHMoEuJpCfPoxqvE7xtReUTA%2FBD5tOM2%2F14Xh5y0%3D&reserved=0" originalSrc="https://twitter.com/DublinCityUni" shash="NQR1eIYnt6rkfu+jB0XGHz+0ksrmrYgKaG1bmeaNzqkd1okYlc/Igytrr7EDKpPiNJ2spR631TIihDPqBllj6aRHCMSY2sE8lWC0bhKflwhOBJV2R6+gTU5XkPqIITb3K1UIWFGm3HQVVPWucllf9MT/FRBS1tiRHYc8f7kAIF0=" target="_blank"><img src="https://www4.dcu.ie/sites/default/files/iss/images/dcuapps/socmedicons-07.png" style="font-size:1.3em"></a><a href="https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fdublin-city-university&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=9tkCC6HcmHo3WJEWbzYTy%2BgJIttmJTAv%2FhWNGqEr5ho%3D&reserved=0" originalSrc="https://www.linkedin.com/company/dublin-city-university" shash="wX9VmcKRHB7wwUoJ4JrSgWd8zVBemJNcmXk3rZvT6MfPikCNSj8q8P/SDNwbufQszwenvuZno2bXpKqikEoyrJDDvPCVU5HrN+qrO+G/xJ8wOH6Vc33S1PBmTIX5Nv/MYnpy9QuaXk0RsndaNqOxt4MxjLfRcXU7svuRtaLsbZ8=" target="_blank"><img src="https://www4.dcu.ie/sites/default/files/iss/images/dcuapps/socmedicons-08.png" style="font-size:1.3em"></a><a href="https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fdublincityuniversity%2F%3Fhl%3Den&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=AmGoga5ajbxCPOsPChiIG1R6r3Zms1YmE9%2BFpTP6gOw%3D&reserved=0" originalSrc="https://www.instagram.com/dublincityuniversity/?hl=en" shash="x6PLvTzcEXPoiR0h6Be8c3AdUC3Yx7PTEZootX5IUm6xbIopwmEltrZ9AXs6OxOUzKN1C+PSC1VkC3V4wglCt98zKg5X1Sf2R+iN+uPJZrQOO4BnmwHAmVtgC0KuJUb2A3juRG5C1INpeIv2xBJzF/LSdqC5LGvlcFq+XiUnGkc=" target="_blank"><img src="https://www4.dcu.ie/sites/default/files/iss/images/dcuapps/socmedicons-09.png" style="font-size:1.3em"></a><a href="https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fuser%2FDublinCityUniversity&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=GlewKcy9a41RSzEL5sCswr9Gl4Lv%2FWwcRzhkJ2IQbQw%3D&reserved=0" originalSrc="https://www.youtube.com/user/DublinCityUniversity" shash="g76WYP35vqUkTOtBth49tHwTkp3bDYHi/BedY+koyQUgWnInPBn/8UTc698wuB5JnOuaG+b70s4wMdnGgjcnqJfCmfbIDy8pV+V+yu3oZrQG5G74aYlWbTDfX5RCv59vFiH9zIAWUSEZerv0uGIIZcQwfyf0EhNoUrJWLk+RVGM=" target="_blank"><img src="https://www4.dcu.ie/sites/default/files/iss/images/dcuapps/socmedicons-10.png" style="font-size:1.3em"></a></div>