<div dir="ltr"><div>The problem just went away, but while looking after it I've found something odd: Using TCPDUMP on lo0 I see that there are about 150 MySQL queries per second with the string "select 1". Searching the source code I found that this is called from odbc_switch.c to check whether the database is up. Are150 calls per second ok?</div>
<div> </div><div> Thanks, __Yehavi:<br><br></div><div class="gmail_quote">2011/9/13 Yehavi Bourvine <span dir="ltr"><<a href="mailto:yehavi.bourvine@gmail.com">yehavi.bourvine@gmail.com</a>></span><br>
<blockquote style="margin: 0px 0.8ex; padding-right: 1ex; padding-left: 1ex; border-right-color: rgb(204, 204, 204); border-left-color: rgb(204, 204, 204); border-right-width: 1px; border-left-width: 1px; border-right-style: solid; border-left-style: solid;" class="gmail_quote">
<div dir="rtl"><div dir="ltr">Hello,</div><div dir="ltr"> </div><div dir="ltr"> This mornning I've updated our Freeswitch from a 3 months old GIT to yesterday's GIT (git-2fa8f11 2011-09-09 14-50-54 -0700). We are using MySQL via ODBC, and I noticed that since today's mornning MySQL is eating 300% CPU (I have 16 cores total).</div>
<div dir="ltr"> </div><div dir="ltr">Any idea how to locate the culprit?</div><div dir="ltr"> </div><div dir="ltr">BTW, I did "git clone" and then install fresh bin/mod/lib directories (after deleting the previous content) just to make sure that I have no leftovers from previous version.</div>
<div dir="ltr"> </div><div dir="ltr"> Thanks! __Yehavi:</div><div dir="ltr"> </div></div>
</blockquote></div></div>