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

Peter Olsson peter.olsson at visionutveckling.se
Tue Sep 13 13:39:55 MSD 2011


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 at lists.freeswitch.org [mailto:freeswitch-users-bounces at 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 at gmail.com<mailto: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:

!DSPAM:4e6f22de32761349872408!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20110913/e2805813/attachment.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list