I believe it’s called every time before the ”real” query it wants to execute – just to confirm that the database connection is up. So it probably means you’ve got lots of traffic, so it need to do lots of SQL updates.

/Peter

Från: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] För Yehavi Bourvine
Skickat: den 13 september 2011 11:31
Till: FreeSWITCH Users Help
Ämne: Re: [Freeswitch-users] MySQL high CPU usage after Freeswitch update

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@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:

!DSPAM:4e6f22de32761349872408!