[Freeswitch-users] High load on database server

[Anthony Minessale]

I don't particularly like mysql so I don't know the exact answer, but I do
know that by default it disables transactions and multi statements as a
knee-jerk solution to injection and that it's some numeric param deep in
some config file.  So I would just google for "enable transactions mysql" or
something like that.

You can tell if it matters if freeswitch complains about transactions
disabled when it connect to the db for the first time.


On Tue, Oct 25, 2011 at 9:55 AM, Hynek Cihlar <hynek.cihlar at gmail.com>wrote:

> For the transactions, what would be required to change? Any tweaks in the
> ODBC driver/DSN settins?
>
> Hynek
>
>
>
>
> On Tue, Oct 25, 2011 at 4: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
>>
>>
>
>
> 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/51686663/attachment-0001.html