[Freeswitch-users] MySQL high CPU usage after Freeswitch update

[Yehavi Bourvine]

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?

                           Thanks, __Yehavi:

2011/9/13 Yehavi Bourvine <yehavi.bourvine at gmail.com>

> Hello,
>
>   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).
>
> Any idea how to locate the culprit?
>
> 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.
>
>                                   Thanks! __Yehavi:
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20110913/4598d2f9/attachment.html