[Freeswitch-users] High load on database server
anthony.minessale at gmail.com
Tue Oct 25 18:49:02 MSD 2011
make sure you have it setup so it can do transactions or multiple
On Mon, Oct 24, 2011 at 5:11 PM, Cliff Wells <cliff at develix.com> wrote:
> On Mon, 2011-10-24 at 17:36 -0400, Tim St. Pierre wrote:
> > Database is MySQL 5.5. I'm seeing 18 queries per second, mostly
> complicated internal
> > joins on tables like sip_dialogs and sip_subscriptions.
> > Freeswitch is Version 1.0.head (git-7531fed 2011-08-17 11-27-20 -0500)
> and hardly breaking
> > a sweat, while the database server is at 100% CPU load.
> You need to optimize your database. Most likely you need to index tables
> that are used in joins (I doubt further optimization is needed for such
> a small dataset and such a light load). I don't use MySQL, but I recall
> it has a way to log slow queries. You should turn this on and use the
> output to figure out the right queries to optimize. Don't blindly
> create needless indexes as this will actually slow it more.
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
Anthony Minessale II
MSN:anthony_minessale at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users