<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19154">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>on this subject,</FONT></DIV>
<DIV><FONT size=2>is SIPp can be used to test to reproduce hundreds calls
?</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=anthony.minessale@gmail.com
href="mailto:anthony.minessale@gmail.com">Anthony Minessale</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeswitch-users@lists.freeswitch.org
href="mailto:freeswitch-users@lists.freeswitch.org">FreeSWITCH Users Help</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, October 27, 2011 1:39
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Freeswitch-users] High load
on database server</DIV>
<DIV><BR></DIV>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.
<DIV><BR>
<DIV><BR></DIV>
<DIV><BR><BR>
<DIV class=gmail_quote>On Thu, Oct 27, 2011 at 12:36 PM, Anthony Minessale
<SPAN dir=ltr><<A
href="mailto:anthony.minessale@gmail.com">anthony.minessale@gmail.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV>Let's recap</DIV>
<DIV><BR></DIV>
<DIV>You have 4 moving parts, you have various versions of all 4 to choose
from and even different implementations of 3 of the 4.</DIV>
<DIV><BR></DIV>ODBC LIB
<DIV>ODBC DRIVER</DIV>
<DIV>DATABASE</DIV>
<DIV>FS</DIV>
<DIV><BR></DIV>
<DIV>You must choose a stable combination of all 4 which may require
specific configuration of each component as well.</DIV>
<DIV><BR></DIV>
<DIV>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.</DIV>
<DIV><BR></DIV>
<DIV>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. </DIV>
<DIV>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.........</DIV>
<DIV><BR></DIV>
<DIV>Things to remember:</DIV>
<DIV><BR></DIV>
<DIV>1) try the Threading=0 in the odbcinst.ini, this is a serious problem
and has been made the default in latest versions.</DIV>
<DIV>2) If you must use Mysql, enable transactions and make sure your
odbc.ini is referencing the threadsafe version of the lib </DIV>
<DIV> libmyodbc3_r.so <-- note _r</DIV>
<DIV>3) Try various combos of drivers and odbc libs, many time newer is not
better, stable versions lie in the past.</DIV>
<DIV>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.......</DIV>
<DIV>5) Find a test to reproduce your problem so you can try different
database engines and driver combos.</DIV>
<DIV>6) Make sure you are on latest FS git so you know you have a stable
copy.</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>Anyway, this is a pain, that's why ppl pay you to do it.</DIV>
<DIV>Discuss this all you want here, just minimize any FUD to scare away
people who want to use it.</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>
<DIV>
<DIV></DIV>
<DIV class=h5><BR><BR>
<DIV class=gmail_quote>On Thu, Oct 27, 2011 at 12:24 PM, Hynek Cihlar <SPAN
dir=ltr><<A href="mailto:hynek.cihlar@gmail.com"
target=_blank>hynek.cihlar@gmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>Do not agree. Issues happening under extreme cases like
high load with<BR>some specific conditions are hard to reproduce, sharing
the<BR>information in this case is a lot more efficient, for all.<BR>
<DIV><BR>Sent from my mobile device<BR><BR></DIV>
<DIV>
<DIV></DIV>
<DIV>On Oct 27, 2011, at 18:56, Robert Huddleston <<A
href="mailto:rhuddleston@gmail.com"
target=_blank>rhuddleston@gmail.com</A>> wrote:<BR><BR>> My bologna
has a first name - it's O S C A R...<BR>><BR>> This topic is getting
really old... I have to agree with Antm - get out of<BR>> the lazy
pants and do some research / hard work.<BR>><BR>><BR>>
-----Original Message-----<BR>> From: <A
href="mailto:freeswitch-users-bounces@lists.freeswitch.org"
target=_blank>freeswitch-users-bounces@lists.freeswitch.org</A><BR>>
[mailto:<A href="mailto:freeswitch-users-bounces@lists.freeswitch.org"
target=_blank>freeswitch-users-bounces@lists.freeswitch.org</A>] On Behalf
Of Sergey<BR>> Okhapkin<BR>> Sent: Thursday, October 27, 2011 12:43
PM<BR>> To: FreeSWITCH Users Help<BR>> Subject: Re:
[Freeswitch-users] High load on database server<BR>><BR>> What do
you mean "shared ODBC"?<BR>><BR>> On Thursday 27 October 2011,
Madovsky wrote:<BR>>> but, is anyone experienced that with shared
ODBC ? (managing more than 330<BR>>> concurrent
calls)<BR>>><BR>>> ----- Original Message -----<BR>>>
From: "Madovsky" <<A href="mailto:infos@madovsky.org"
target=_blank>infos@madovsky.org</A>><BR>>> To: "FreeSWITCH Users
Help" <<A href="mailto:freeswitch-users@lists.freeswitch.org"
target=_blank>freeswitch-users@lists.freeswitch.org</A>><BR>>>
Sent: Thursday, October 27, 2011 12:33 PM<BR>>> Subject: Re:
[Freeswitch-users] High load on database
server<BR>>><BR>>>> ha ok, good luck
so<BR>>>><BR>>>> ----- Original Message
-----<BR>>>> From: "Cliff Wells" <<A
href="mailto:cliff@develix.com"
target=_blank>cliff@develix.com</A>><BR>>>> To: "FreeSWITCH
Users Help" <<A href="mailto:freeswitch-users@lists.freeswitch.org"
target=_blank>freeswitch-users@lists.freeswitch.org</A>><BR>>>>
Sent: Thursday, October 27, 2011 12:26 PM<BR>>>> Subject: Re:
[Freeswitch-users] High load on database
server<BR>>>><BR>>>>> On Thu, 2011-10-27 at 11:55
-0400, Madovsky wrote:<BR>>>>>> I means that depend the
quality of your script ;)<BR>>>>><BR>>>>> Quality
isn't the issue here. The script is too simple to be
incorrect<BR>>>>> (and it carefully releases the odbc
connection back to the pool in a<BR>>>>> hangup handler).
I have written poor-quality code plenty of times,
but<BR>>>>> 25 years as a programmer usually allows me the
luxury of knowing when<BR>>>>> I'm doing it,
thanks.<BR>>>>><BR>>>>> In any case, Lua scripts
work fine. Google will tell you that unixODBC<BR>>>>>
before 2.3.0 was a bit of a mess, so I expect the issue lies there,
but<BR>>>>> again, I emphasize, everything WORKS GREAT (been
using it for a couple<BR>>>>> of years now) until you get to
very high concurrency (about 330<BR>>>>> concurrent calls on a
single system). If you don't expect to handle<BR>>>>>
more than 300 concurrent calls, then you do not need to worry about
it.<BR>>>>> At all.<BR>>>>><BR>>>>>
Regards,<BR>>>>>
Cliff<BR>>>>><BR>>>>><BR>>>>><BR>>>>>
FreeSWITCH-users mailing list<BR>>>>> <A
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR>>>>>
<A href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>>>>><BR>>
UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR>>>>>
<A href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR>>><BR>>>
FreeSWITCH-users mailing list<BR>>> <A
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR>>> <A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>>>
UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR>>>
<A href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR>><BR>><BR>><BR>>
FreeSWITCH-users mailing list<BR>> <A
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR>> <A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>>
UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR>>
<A href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR>><BR>><BR>><BR>>
FreeSWITCH-users mailing list<BR>> <A
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR>> <A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>>
UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR>>
<A href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR><BR><BR>FreeSWITCH-users
mailing list<BR><A href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR></DIV></DIV></BLOCKQUOTE></DIV><BR><BR
clear=all>
<DIV><BR></DIV></DIV></DIV>
<DIV class=im>-- <BR>Anthony Minessale II<BR><BR>FreeSWITCH <A
href="http://www.freeswitch.org/"
target=_blank>http://www.freeswitch.org/</A><BR>ClueCon <A
href="http://www.cluecon.com/"
target=_blank>http://www.cluecon.com/</A><BR>Twitter: <A
href="http://twitter.com/FreeSWITCH_wire"
target=_blank>http://twitter.com/FreeSWITCH_wire</A><BR><BR>AIM: anthm<BR><A
href="mailto:MSN%3Aanthony_minessale@hotmail.com"
target=_blank>MSN:anthony_minessale@hotmail.com</A><BR>GTALK/JABBER/<A
href="mailto:PAYPAL%3Aanthony.minessale@gmail.com"
target=_blank>PAYPAL:anthony.minessale@gmail.com</A><BR>IRC: <A
href="http://irc.freenode.net" target=_blank>irc.freenode.net</A>
#freeswitch<BR><BR>FreeSWITCH Developer Conference<BR><A
href="mailto:sip%3A888@conference.freeswitch.org"
target=_blank>sip:888@conference.freeswitch.org</A><BR><A
href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org"
target=_blank>googletalk:conf+888@conference.freeswitch.org</A><BR>pstn:<A
href="tel:%2B19193869900" target=_blank
value="+19193869900">+19193869900</A><BR></DIV></DIV></BLOCKQUOTE></DIV><BR><BR
clear=all>
<DIV><BR></DIV>-- <BR>Anthony Minessale II<BR><BR>FreeSWITCH <A
href="http://www.freeswitch.org/">http://www.freeswitch.org/</A><BR>ClueCon <A
href="http://www.cluecon.com/">http://www.cluecon.com/</A><BR>Twitter: <A
href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</A><BR><BR>AIM:
anthm<BR><A
href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</A><BR>GTALK/JABBER/<A
href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</A><BR>IRC:
<A href="http://irc.freenode.net">irc.freenode.net</A>
#freeswitch<BR><BR>FreeSWITCH Developer Conference<BR><A
href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</A><BR><A
href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</A><BR>pstn:+19193869900<BR></DIV></DIV>
<P>
<HR>
<P></P><BR>FreeSWITCH-users mailing
list<BR>FreeSWITCH-users@lists.freeswitch.org<BR>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<BR>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<BR>http://www.freeswitch.org<BR></BLOCKQUOTE></BODY></HTML>