<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Re: [Freeswitch-users] High load on database server</TITLE>
<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>another idea, maybe you have some hardware
problem....</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=infos@madovsky.org href="mailto:infos@madovsky.org">Madovsky</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 2:07
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Freeswitch-users] High load
on database server</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>Thanks Ken. here the link of official SIPP
website</FONT></DIV>
<DIV><FONT size=2><A
href="http://sipp.sourceforge.net/">http://sipp.sourceforge.net/</A></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I didn't know it was a HP app ! :0)</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=krice@freeswitch.org href="mailto:krice@freeswitch.org">Ken
Rice</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:54
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Freeswitch-users] High
load on database server</DIV>
<DIV><BR></DIV><FONT face="Monaco, Courier New"><SPAN
style="FONT-SIZE: 11pt">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<BR><BR>K<BR><BR><BR>On 10/27/11 12:51
PM, "Madovsky" <<A
href="mailto:infos@madovsky.org">infos@madovsky.org</A>>
wrote:<BR><BR></SPAN></FONT>
<BLOCKQUOTE><FONT face="Monaco, Courier New"><SPAN
style="FONT-SIZE: 11pt">on this subject,<BR>is SIPp can be used to test to
reproduce hundreds calls ?<BR></SPAN></FONT>
<BLOCKQUOTE><FONT face="Monaco, Courier New"><SPAN
style="FONT-SIZE: 11pt"><BR>----- Original Message -----
<BR> <BR><B>From:</B> Anthony Minessale <<A
href="mailto:anthony.minessale@gmail.com">mailto:anthony.minessale@gmail.com</A>>
<BR> <BR><B>To:</B> FreeSWITCH Users Help <<A
href="mailto:freeswitch-users@lists.freeswitch.org">mailto:freeswitch-users@lists.freeswitch.org</A>>
<BR> <BR><B>Sent:</B> Thursday, October 27, 2011 1:39
PM<BR> <BR><B>Subject:</B> Re: [Freeswitch-users] High load
on database server<BR> <BR><BR>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. <BR><BR> <BR><BR> <BR><BR><BR> <BR>On
Thu, Oct 27, 2011 at 12:36 PM, Anthony Minessale <<A
href="anthony.minessale@gmail.com">anthony.minessale@gmail.com</A>>
wrote:<BR> <BR></SPAN></FONT>
<BLOCKQUOTE><FONT face="Monaco, Courier New"><SPAN
style="FONT-SIZE: 11pt"><BR>Let's recap<BR> <BR><BR> <BR>You
have 4 moving parts, you have various versions of all 4 to choose
from and even different implementations of 3 of the
4.<BR> <BR><BR>ODBC LIB <BR>ODBC
DRIVER<BR> <BR>DATABASE<BR> <BR>FS<BR> <BR><BR> <BR>You
must choose a stable combination of all 4 which may require
specific configuration of each component as
well.<BR> <BR><BR> <BR>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.<BR> <BR><BR> <BR>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.
<BR> <BR>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.........<BR> <BR><BR> <BR>Things to
remember:<BR> <BR><BR> <BR>1) try the Threading=0 in the
odbcinst.ini, this is a serious problem and has been made the
default in latest versions.<BR> <BR>2) If you must use Mysql,
enable transactions and make sure your odbc.ini is referencing
the threadsafe version of the lib
<BR> <BR> libmyodbc3_r.so <--
note _r<BR> <BR>3) Try various combos of drivers and odbc libs,
many time newer is not better, stable versions lie in the
past.<BR> <BR>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.......<BR> <BR>5) Find a test to reproduce your
problem so you can try different database engines and driver
combos.<BR> <BR>6) Make sure you are on latest FS git so you know
you have a stable
copy.<BR> <BR><BR> <BR><BR> <BR>Anyway, this is a
pain, that's why ppl pay you to do it.<BR> <BR>Discuss this all
you want here, just minimize any FUD to scare away people who
want to use
it.<BR> <BR><BR> <BR><BR> <BR><BR> <BR><BR> <BR> <BR> <BR> <BR><BR><BR> <BR>On
Thu, Oct 27, 2011 at 12:24 PM, Hynek Cihlar <<A
href="hynek.cihlar@gmail.com">hynek.cihlar@gmail.com</A>>
wrote:<BR> <BR></SPAN></FONT>
<BLOCKQUOTE><FONT face="Monaco, Courier New"><SPAN
style="FONT-SIZE: 11pt">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> <BR><BR>Sent from my mobile
device<BR><BR> <BR> <BR> <BR>On Oct 27, 2011, at
18:56, Robert Huddleston <<A
href="rhuddleston@gmail.com">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="freeswitch-users-bounces@lists.freeswitch.org">freeswitch-users-bounces@lists.freeswitch.org</A><BR>>
[<A
href="mailto:freeswitch-users-bounces@lists.freeswitch.org">mailto: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="infos@madovsky.org">infos@madovsky.org</A>><BR>>> To:
"FreeSWITCH Users Help" <<A
href="freeswitch-users@lists.freeswitch.org">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="cliff@develix.com">cliff@develix.com</A>><BR>>>>
To: "FreeSWITCH Users Help" <<A
href="freeswitch-users@lists.freeswitch.org">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="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><BR>>>>>
<A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>>>>><BR>>
UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR>>>>>
<A
href="http://www.freeswitch.org">http://www.freeswitch.org</A><BR>>><BR>>>
FreeSWITCH-users mailing list<BR>>> <A
href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><BR>>>
<A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>>>
UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR>>>
<A
href="http://www.freeswitch.org">http://www.freeswitch.org</A><BR>><BR>><BR>><BR>>
FreeSWITCH-users mailing list<BR>> <A
href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><BR>>
<A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>>
UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR>>
<A
href="http://www.freeswitch.org">http://www.freeswitch.org</A><BR>><BR>><BR>><BR>>
FreeSWITCH-users mailing list<BR>> <A
href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><BR>>
<A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>>
UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR>>
<A
href="http://www.freeswitch.org">http://www.freeswitch.org</A><BR><BR><BR>FreeSWITCH-users
mailing list<BR><A
href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org">http://www.freeswitch.org</A><BR></SPAN></FONT></BLOCKQUOTE><FONT
face="Monaco, Courier New"><SPAN
style="FONT-SIZE: 11pt"><BR><BR> <BR><BR> <BR></SPAN></FONT></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE>
<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></BLOCKQUOTE></BODY></HTML>