[Freeswitch-users] High load on database server

[Muhammad Naseer Bhatti]

Tuning MySQL would be the first thing I would do. Download and run
this small script, http://mysqltuner.pl and it would show you some
configurable parameters of MySQL which may greatly enhance your DB
performance.

On Tue, Oct 25, 2011 at 5:49 PM, Anthony Minessale
<anthony.minessale at gmail.com> wrote:
> 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
>
>
> 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
>
>