[Freeswitch-users] High load on database server
Ken Rice
krice at freeswitch.org
Thu Oct 27 21:54:29 MSD 2011
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> wrote:
> on this subject,
> is SIPp can be used to test to reproduce hundreds calls ?
>>
>> ----- Original Message -----
>>
>> From: Anthony Minessale <mailto:anthony.minessale at gmail.com>
>>
>> To: FreeSWITCH Users Help <mailto: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
>> <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
>>>
>>>
>>>
>>>
>>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111027/95dd91ec/attachment-0001.html
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users
mailing list