<div dir="ltr"><div><div><div><div><div><div><div><div><div>Hi All,<br><br></div>Can someone help me to know what could be the possible reason for HIGH SWAP on MySQL Server ??<br><br></div>Environment is below given :<br><br>
</div>OS - CentOS 6.4<br><br></div>Database - MySQL 5.5<br><br></div>Application which is using the DB : Roxen CMS<br><br><br></div>Please suggest me while I am taking a look on TOP, I see mysql is the process which is causing 100 % Memory and SWAP<br>
<br></div>How can i do the low level analysis ?<br><br><br></div>Please help me.<br><br></div>Thanks<br>Vimal<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Mar 4, 2014 at 11:42 AM, Anthony Somerset <span dir="ltr"><<a href="mailto:anthony@teamzol.co.zw" target="_blank">anthony@teamzol.co.zw</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">HI Ralph, has there been any update on this? we have around 40-50 servers and VM's in our DC alone that are still going to SA and even brazil in some cases! i'm loathe to have to manually set the mirror's on these to allow basic failover to other mirrors when and if ours is down for any reason<span class="HOEnZb"><font color="#888888"><div>
<div><div>
<div style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;font-weight:normal;line-height:normal;text-transform:none;font-size:12px;white-space:normal;font-family:Helvetica;word-spacing:0px">
<div><div><div style="font-size:medium;text-align:-webkit-auto;word-wrap:break-word"><div style="text-align:-webkit-auto;word-wrap:break-word"><p class="MsoNormal" style="text-align:-webkit-auto"><a name="1448bb9fcb80725c__MailAutoSig"><b><span style="font-size:13.5pt;color:rgb(249,149,41)" lang="EN-ZW">Anthony Somerset </span></b></a><span style="font-size:13.5pt;color:rgb(54,77,167)" lang="EN-ZW">| Systems Administrator</span></p>
</div></div></div></div></div><br><span></span></div></div></div></font></span></div><br><div style="word-wrap:break-word"><div><div><div><span></span><p class="MsoNormal" style="line-height:normal;text-indent:0px;letter-spacing:normal;text-align:start;font-variant:normal;text-transform:none;font-style:normal;white-space:normal;font-family:Helvetica;font-weight:normal;word-spacing:0px">
<b><span style="font-size:9pt;color:rgb(54,77,167)" lang="EN-ZW"><br><br>T </span></b><span style="font-size:9pt;color:rgb(54,77,167)" lang="EN-ZW">08677 123 123 | <b>Ext </b>3154 | <b>M </b><a href="tel:%2B263%20779%20128%20693" value="+263779128693" target="_blank">+263 779 128 693</a></span></p>
<p class="MsoNormal" style="line-height:normal;text-indent:0px;letter-spacing:normal;text-align:start;font-variant:normal;text-transform:none;font-style:normal;white-space:normal;font-family:Helvetica;font-weight:normal;word-spacing:0px">
<b><span style="font-size:9pt;color:rgb(54,77,167)" lang="EN-ZW">E </span></b><span style="font-size:9pt;color:rgb(54,77,167)" lang="EN-ZW"><a href="mailto:themba@teamzol.co.zw" target="_blank">anthony@teamzol.co.zw</a> </span><span style="font-size:13.5pt" lang="EN-ZW"><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:normal;text-indent:0px;letter-spacing:normal;text-align:start;font-variant:normal;text-transform:none;font-style:normal;white-space:normal;font-family:Helvetica;font-weight:normal;word-spacing:0px">
<span style="color:rgb(54,77,167);font-size:9pt">3rd Floor, Greenbridge, Eastgate, Harare</span></p><p class="MsoNormal" style="line-height:normal;text-indent:0px;letter-spacing:normal;text-align:start;font-variant:normal;text-transform:none;font-style:normal;white-space:normal;font-family:Helvetica;font-weight:normal;word-spacing:0px">
<a href="http://www.zol.co.zw" target="_blank"><b><span style="font-size:9pt;font-family:Calibri" lang="EN-ZW">www.zol.co.zw</span></b></a></p>
</div>
<br><div><div>On 13 Feb 2014, at 23:11, Ralph Angenendt <<a href="mailto:ralph.angenendt@gmail.com" target="_blank">ralph.angenendt@gmail.com</a>> wrote:</div><br><blockquote type="cite"><fieldset style="padding-top:10px;border:0px;border:3px solid #ccc;padding-left:20px"><legend style="font-weight:bold">Signed PGP part</legend><div style="padding-left:3px">
On 05.02.2014 09:21, Anthony Somerset wrote:<br>> Hi Mirror team, any update on the following?<br>><br>> I'm seeing some bizzare mirror list results for ZW ip's right now -<br>> in fact we have never ever been offered the ZW mirror on any tested<br>
> ZW IP!<br>><br>> from my home IP: <a href="http://f.sts.io/ssWvDoKRJD.txt" target="_blank">http://f.sts.io/ssWvDoKRJD.txt</a> - Mosty US<br>> servers?<br>><br>> from a ZW server: <a href="http://f.sts.io/u67AWSDCNt.txt" target="_blank">http://f.sts.io/u67AWSDCNt.txt</a> - mix of global<br>
> servers plus some SA (i kind of expect this but the ZW listing<br>> should be included as well)<br>><br>> very occasionally i get a listing like this:<br>> <a href="http://f.sts.io/0KseCzRxT9.txt" target="_blank">http://f.sts.io/0KseCzRxT9.txt</a> - what appears to be a load of msync<br>
> nodes?<br>><br>> is GeoIP needing an update or kick perhaps - is there any extra<br>> info we can provide you that would help to improve accuracy?<br><br>It is what I expected.<br><br><a href="http://geo_cc.pm" target="_blank">geo_cc.pm</a> has<br>
<br>ZW => "ZA",<br><br>and ZA is:<br><br>za => 'il-br-tr-es-in'<br><br>Which means it is pure luck if your server is hit directly from ZW.<br><br>What I can do: Point ZW to itself (ZW => "ZW",) and than add<br>
<br>zw => 'zw-za-...' (whatever you think appropriate).<br><br>Cheers,<br><br>Ralph</div></fieldset><br>_______________________________________________<br>CentOS-mirror mailing list<br><a href="mailto:CentOS-mirror@centos.org" target="_blank">CentOS-mirror@centos.org</a><br>
<a href="http://lists.centos.org/mailman/listinfo/centos-mirror" target="_blank">http://lists.centos.org/mailman/listinfo/centos-mirror</a><br></blockquote></div><br></div></div></div><br>_______________________________________________<br>
CentOS-mirror mailing list<br>
<a href="mailto:CentOS-mirror@centos.org">CentOS-mirror@centos.org</a><br>
<a href="http://lists.centos.org/mailman/listinfo/centos-mirror" target="_blank">http://lists.centos.org/mailman/listinfo/centos-mirror</a><br>
<br></blockquote></div><br></div>