[Freeswitch-users] High load on database server

Anthony Minessale anthony.minessale at gmail.com
Thu Oct 27 21:39:47 MSD 2011


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 <
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 <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 <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: freeswitch-users-bounces at lists.freeswitch.org
>> > [mailto: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" <infos at madovsky.org>
>> >> To: "FreeSWITCH Users Help" <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" <cliff at develix.com>
>> >>> To: "FreeSWITCH Users Help" <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
>> >>>> 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
>> >
>> >
>> >
>> > 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
>>
>>
>> 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
>



-- 
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/20111027/b7602ba4/attachment-0001.html 


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