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<mailto: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!