[Freeswitch-users] High load on database server

[Hynek Cihlar]

Transactions are by default supported by mysql, the transactions are driven
by sql statements themselves.

Your statement is either incorrect or I interpret it wrong.

Sent from my mobile device

On Oct 27, 2011, at 20:09, Anthony Minessale <anthony.minessale at gmail.com>
wrote:

mysql does not work with transactions by default in defense of injection
attacks... read the thread its in the top.


On Thu, Oct 27, 2011 at 1:07 PM, Madovsky <infos at madovsky.org> wrote:

> **
> Thanks Ken. here the link of official SIPP website
> http://sipp.sourceforge.net/
>
> I didn't know it was a HP app ! :0)
>
> ----- Original Message -----
> *From:* Ken Rice <krice at freeswitch.org>
> *To:* FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> *Sent:* Thursday, October 27, 2011 1:54 PM
> *Subject:* Re: [Freeswitch-users] High load on database server
>
> 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<anthony.minessale at gmail.com><anthony.minessale at gmail.com>>
>
>
> *To:* FreeSWITCH Users Help <mailto:freeswitch-users at lists.freeswitch.org<freeswitch-users at lists.freeswitch.org><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<freeswitch-users-bounces at lists.freeswitch.org><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
>
>
>
>
>
>
>
>  ------------------------------
>
>
> 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 <sip%3A888 at conference.freeswitch.org>
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900


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