[Freeswitch-users] High load on database server

[Anthony Minessale]

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