[Freeswitch-users] High load on database server

[Hynek Cihlar]

Of course that MySQL supports and enables transaction by default. It is the
SQL statements that must tell the DB when to start a transaction, commit,
rollback.

I had an issue with batch statements to be enabled on the ODBC connection,
once on, it works ok.

Hynek



On Tue, Oct 25, 2011 at 5:00 PM, Anthony Minessale <
anthony.minessale at gmail.com> wrote:

> 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
>
>
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111025/93e92f39/attachment.html