[Freeswitch-users] High load on database server

Avi Marcus avi at avimarcus.net
Fri Oct 28 12:46:37 MSD 2011 

He gave you the link to what he's talking about for a DB that he doesn't
even use.

Feel free to clean up the wiki page on this.

-Avi


On Fri, Oct 28, 2011 at 10:37 AM, Hynek Cihlar <hynek.cihlar at gmail.com>wrote:

> My god!
>
> Multi statements and transactions are two completely different thinks! You
> should read up on the topic.
>
> Hynek
>
>
>
> On Thu, Oct 27, 2011 at 9:08 PM, Anthony Minessale <
> anthony.minessale at gmail.com> wrote:
>
>> Blah,
>>
>> I said I don't like mysql, but ok I'll look it up for you.......
>>
>> http://www.mail-archive.com/profox@leafe.com/msg33150.html
>>
>> AND
>>
>>
>> http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-connection-parameters.html
>> search for 'FLAG_MULTI_STATEMENTS'
>>
>> From our own FS resources:
>>
>> http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#CentOS_5.2
>>
>> http://www.mail-archive.com/freeswitch-users@lists.freeswitch.org/msg19883.html
>>
>> or
>>
>> http://tinyurl.com/4xo26sv
>>
>>
>>
>>
>>
>>
>> On Thu, Oct 27, 2011 at 1:29 PM, Hynek Cihlar <hynek.cihlar at gmail.com>wrote:
>>
>>> Transactions are by default supported by mysql, the transactions are
>>> driven by sql statements themselves.
>>>
>>> Your statement is either incorrect or I interpret it wrong.
>>>
>>>
>>> Sent from my mobile device
>>>
>>> On Oct 27, 2011, at 20:09, Anthony Minessale <
>>> anthony.minessale at gmail.com> wrote:
>>>
>>> mysql does not work with transactions by default in defense of injection
>>> attacks... read the thread its in the top.
>>>
>>>
>>> On Thu, Oct 27, 2011 at 1:07 PM, Madovsky < <infos at madovsky.org>
>>> infos at madovsky.org> wrote:
>>>
>>>> **
>>>> Thanks Ken. here the link of official SIPP website
>>>>  <http://sipp.sourceforge.net/>http://sipp.sourceforge.net/
>>>>
>>>> I didn't know it was a HP app ! :0)
>>>>
>>>> ----- Original Message -----
>>>> *From:* Ken Rice <krice at freeswitch.org>
>>>> *To:* FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
>>>> *Sent:* Thursday, October 27, 2011 1:54 PM
>>>> *Subject:* Re: [Freeswitch-users] High load on database server
>>>>
>>>> SIPP works fine for this... However keep in mind some of their default
>>>> scenario files arent exactly the best in the world and can in many
>>>> situations leave a bit to be desired... Check the wiki I think there is more
>>>> info on this on there
>>>>
>>>> K
>>>>
>>>>
>>>> On 10/27/11 12:51 PM, "Madovsky" < <infos at madovsky.org>
>>>> infos at madovsky.org> wrote:
>>>>
>>>> on this subject,
>>>> is SIPp can be used to test to reproduce hundreds calls ?
>>>>
>>>>
>>>> ----- Original Message -----
>>>>
>>>> *From:*  Anthony Minessale < <anthony.minessale at gmail.com>
>>>> mailto:anthony.minessale at gmail.com <anthony.minessale at gmail.com>>
>>>>
>>>> *To:* FreeSWITCH Users Help < <freeswitch-users at lists.freeswitch.org>
>>>> mailto:freeswitch-users at lists.freeswitch.org<freeswitch-users at lists.freeswitch.org>>
>>>>
>>>>
>>>> *Sent:* Thursday, October 27, 2011 1:39  PM
>>>>
>>>> *Subject:* Re: [Freeswitch-users] High load  on database server
>>>>
>>>>
>>>> BTW I know it's a contradiction to tell you to consider older  ODBC and
>>>> newer FS but I wrote FS so I can attest to its stability especially  the
>>>> ODBC code in the core.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Oct 27, 2011 at 12:36 PM, Anthony Minessale  <<http://anthony.minessale@gmail.com>
>>>> anthony.minessale at gmail.com>  wrote:
>>>>
>>>>
>>>>
>>>> Let's recap
>>>>
>>>>
>>>>
>>>> You have 4 moving parts, you have various versions of all 4 to choose
>>>>  from and even different implementations of 3 of the 4.
>>>>
>>>>
>>>> ODBC LIB
>>>> ODBC DRIVER
>>>>
>>>> DATABASE
>>>>
>>>> FS
>>>>
>>>>
>>>>
>>>> You must choose a stable combination of all 4 which may require
>>>>  specific configuration of each component as well.
>>>>
>>>>
>>>>
>>>> My only issue is FUD, I do not want people to advertise that FS does
>>>>  not work on ODBC under load when the whole story is FS does not work under
>>>>  load when you use fooODBC with barDRIVER with basBASE database server
>>>>  configured a particular way.
>>>>
>>>>
>>>>
>>>> It should never crash, if it does, its a bug in something.  I can  speak
>>>> for FS that there is no bug there.  The other 3 are  variables.
>>>>
>>>> Remember this next time there is a discussion about using system libs
>>>>  and why we build our own depends.  The one thing we use system libs  for,
>>>> ODBC, is a huge PITA.........
>>>>
>>>>
>>>>
>>>> Things to remember:
>>>>
>>>>
>>>>
>>>> 1) try the Threading=0 in the odbcinst.ini, this is a serious problem
>>>>  and has been made the default in latest versions.
>>>>
>>>> 2) If you must use Mysql, enable transactions and make sure your
>>>>  odbc.ini is referencing the threadsafe version of the lib
>>>>
>>>>      libmyodbc3_r.so <-- note _r
>>>>
>>>> 3) Try various combos of drivers and odbc libs, many time newer is not
>>>>  better, stable versions lie in the past.
>>>>
>>>> 4) build the drivers and odbc yourself or get the debug symbols so you
>>>>  can get a backtrace, you could be finding a bug for them.......
>>>>
>>>> 5) Find a test to reproduce your problem so you can try different
>>>>  database engines and driver combos.
>>>>
>>>> 6) Make sure you are on latest FS git so you know you have a stable
>>>>  copy.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Anyway, this is a pain, that's why ppl pay you to do it.
>>>>
>>>> Discuss this all you want here, just minimize any FUD to scare away
>>>>  people who want to use it.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Oct 27, 2011 at 12:24 PM, Hynek Cihlar <<http://hynek.cihlar@gmail.com>
>>>> hynek.cihlar at gmail.com> wrote:
>>>>
>>>>
>>>> Do not agree. Issues happening under extreme cases like  high load with
>>>> some specific conditions are hard to reproduce, sharing  the
>>>> information in this case is a lot more efficient, for all.
>>>>
>>>>
>>>> Sent from my mobile device
>>>>
>>>>
>>>>
>>>>
>>>> On Oct 27, 2011, at 18:56, Robert Huddleston <<http://rhuddleston@gmail.com>
>>>> rhuddleston at gmail.com> wrote:
>>>>
>>>> > My bologna  has a first name - it's O S C A R...
>>>> >
>>>> > This topic is getting  really old... I have to agree with Antm - get
>>>> out of
>>>> > the lazy  pants and do some research / hard work.
>>>> >
>>>> >
>>>> >  -----Original Message-----
>>>> > From: <http://freeswitch-users-bounces@lists.freeswitch.org>
>>>> freeswitch-users-bounces at lists.freeswitch.org
>>>> >  [ <freeswitch-users-bounces at lists.freeswitch.org>
>>>> mailto:freeswitch-users-bounces at lists.freeswitch.org<freeswitch-users-bounces at lists.freeswitch.org>]
>>>> On Behalf  Of Sergey
>>>> > Okhapkin
>>>> > Sent: Thursday, October 27, 2011 12:43  PM
>>>> > To: FreeSWITCH Users Help
>>>> > Subject: Re:  [Freeswitch-users] High load on database server
>>>> >
>>>> > What do  you mean "shared ODBC"?
>>>> >
>>>> > On Thursday 27 October 2011,  Madovsky wrote:
>>>> >> but, is anyone experienced that with shared  ODBC ? (managing more
>>>> than 330
>>>> >> concurrent  calls)
>>>> >>
>>>> >> ----- Original Message -----
>>>> >>  From: "Madovsky" < <http://infos@madovsky.org>infos at madovsky.org>
>>>> >> To: "FreeSWITCH Users  Help" <<http://freeswitch-users@lists.freeswitch.org>
>>>> freeswitch-users at lists.freeswitch.org>
>>>> >>  Sent: Thursday, October 27, 2011 12:33 PM
>>>> >> Subject: Re:  [Freeswitch-users] High load on database  server
>>>> >>
>>>> >>> ha ok, good luck  so
>>>> >>>
>>>> >>> ----- Original Message  -----
>>>> >>> From: "Cliff Wells" < <http://cliff@develix.com>cliff at develix.com>
>>>> >>> To: "FreeSWITCH  Users Help" <<http://freeswitch-users@lists.freeswitch.org>
>>>> freeswitch-users at lists.freeswitch.org>
>>>> >>>  Sent: Thursday, October 27, 2011 12:26 PM
>>>> >>> Subject: Re:  [Freeswitch-users] High load on database  server
>>>> >>>
>>>> >>>> On Thu, 2011-10-27 at 11:55  -0400, Madovsky wrote:
>>>> >>>>> I means that depend the  quality of your script ;)
>>>> >>>>
>>>> >>>> Quality  isn't the issue here.  The script is too simple to be
>>>>  incorrect
>>>> >>>> (and it carefully releases the odbc  connection back to the pool in
>>>> a
>>>> >>>> hangup handler).   I have written poor-quality code plenty of
>>>> times,  but
>>>> >>>> 25 years as a programmer usually allows me the  luxury of knowing
>>>> when
>>>> >>>> I'm doing it,  thanks.
>>>> >>>>
>>>> >>>> In any case, Lua scripts  work fine.  Google will tell you that
>>>> unixODBC
>>>> >>>>  before 2.3.0 was a bit of a mess, so I expect the issue lies
>>>> there,  but
>>>> >>>> again, I emphasize, everything WORKS GREAT (been  using it for a
>>>> couple
>>>> >>>> of years now) until you get to  very high concurrency (about 330
>>>> >>>> concurrent calls on a  single system).  If you don't expect to
>>>> handle
>>>> >>>>  more than 300 concurrent calls, then you do not need to worry
>>>> about  it.
>>>> >>>> At all.
>>>> >>>>
>>>> >>>>  Regards,
>>>> >>>>  Cliff
>>>> >>>>
>>>> >>>>
>>>> >>>>
>>>> >>>>  FreeSWITCH-users mailing list
>>>> >>>> <http://FreeSWITCH-users@lists.freeswitch.org>
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> >>>>   <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> >>>>
>>>> >  UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> >>>>   <http://www.freeswitch.org>http://www.freeswitch.org
>>>> >>
>>>> >>  FreeSWITCH-users mailing list
>>>> >> <http://FreeSWITCH-users@lists.freeswitch.org>
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> >> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> >>  UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> >>   <http://www.freeswitch.org>http://www.freeswitch.org
>>>> >
>>>> >
>>>> >
>>>> >  FreeSWITCH-users mailing list
>>>> > <http://FreeSWITCH-users@lists.freeswitch.org>
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> > <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> >  UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> >   <http://www.freeswitch.org>http://www.freeswitch.org
>>>> >
>>>> >
>>>> >
>>>> >  FreeSWITCH-users mailing list
>>>> > <http://FreeSWITCH-users@lists.freeswitch.org>
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> > <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> >  UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> >   <http://www.freeswitch.org>http://www.freeswitch.org
>>>>
>>>>
>>>> FreeSWITCH-users  mailing list
>>>> <http://FreeSWITCH-users@lists.freeswitch.org>
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>  <http://www.freeswitch.org>http://www.freeswitch.org
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>  ------------------------------
>>>>
>>>>
>>>> FreeSWITCH-users mailing list
>>>> <FreeSWITCH-users at lists.freeswitch.org>
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>  <http://www.freeswitch.org>http://www.freeswitch.org
>>>>
>>>>
>>>>
>>>> FreeSWITCH-users mailing list
>>>>  <FreeSWITCH-users at lists.freeswitch.org>
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>  <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>  <http://www.freeswitch.org>http://www.freeswitch.org
>>>>
>>>>
>>>
>>>
>>> --
>>> Anthony Minessale II
>>>
>>> FreeSWITCH <http://www.freeswitch.org/>http://www.freeswitch.org/
>>> ClueCon <http://www.cluecon.com/>http://www.cluecon.com/
>>> Twitter: <http://twitter.com/FreeSWITCH_wire>
>>> http://twitter.com/FreeSWITCH_wire
>>>
>>> AIM: anthm
>>> MSN:anthony_minessale at hotmail.com
>>> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
>>> IRC: <http://irc.freenode.net>irc.freenode.net #freeswitch
>>>
>>> FreeSWITCH Developer Conference
>>> sip: <sip%3A888 at conference.freeswitch.org>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
>>
>>
>
>
> 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/20111028/8672e38e/attachment-0001.html

Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list