[Freeswitch-users] High load on database server

[Anthony Minessale]

make sure you have it setup so it can do transactions or multiple
statements.


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.
>
> Cliff
>
>
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>



-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
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
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111025/62ccc50f/attachment.html