[Freeswitch-users] High load on database server

Hynek Cihlar hynek.cihlar at gmail.com
Fri Oct 28 13:06:56 MSD 2011 

Yes, I see the link - transaction statements are composed of multiple
statements, hence enabling multi statements... fine.

But what the heck does it have in common with "enabling transactions in
mysql"?? Transactions in mysql can't even be turned off in the first place!

Hynek



On Fri, Oct 28, 2011 at 10:46 AM, Avi Marcus <avi at avimarcus.net> wrote:

> He gave you the link to what he's talking about for a DB that he doesn't
> even use.
>
> Feel free to clean up the wiki page on this.
>
> -Avi
>
>
> On Fri, Oct 28, 2011 at 10:37 AM, Hynek Cihlar <hynek.cihlar at gmail.com>wrote:
>
>> My god!
>>
>> Multi statements and transactions are two completely different thinks! You
>> should read up on the topic.
>>
>> Hynek
>>
>>
>>
>> On Thu, Oct 27, 2011 at 9:08 PM, Anthony Minessale <
>> anthony.minessale at gmail.com> wrote:
>>
>>> Blah,
>>>
>>> I said I don't like mysql, but ok I'll look it up for you.......
>>>
>>> http://www.mail-archive.com/profox@leafe.com/msg33150.html
>>>
>>> AND
>>>
>>>
>>> http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-connection-parameters.html
>>> search for 'FLAG_MULTI_STATEMENTS'
>>>
>>> From our own FS resources:
>>>
>>> http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#CentOS_5.2
>>>
>>> http://www.mail-archive.com/freeswitch-users@lists.freeswitch.org/msg19883.html
>>>
>>> or
>>>
>>> http://tinyurl.com/4xo26sv
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Thu, Oct 27, 2011 at 1:29 PM, Hynek Cihlar <hynek.cihlar at gmail.com>wrote:
>>>
>>>> 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>
>>>> infos at madovsky.org> wrote:
>>>>
>>>>> **
>>>>> Thanks Ken. here the link of official SIPP website
>>>>>  <http://sipp.sourceforge.net/>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>
>>>>> infos at madovsky.org> wrote:
>>>>>
>>>>> on this subject,
>>>>> is SIPp can be used to test to reproduce hundreds calls ?
>>>>>
>>>>>
>>>>> ----- Original Message -----
>>>>>
>>>>> *From:*  Anthony Minessale < <anthony.minessale at gmail.com>
>>>>> mailto:anthony.minessale at gmail.com <anthony.minessale at gmail.com>>
>>>>>
>>>>> *To:* FreeSWITCH Users Help < <freeswitch-users at lists.freeswitch.org>
>>>>> mailto: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  <<http://anthony.minessale@gmail.com>
>>>>> 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 <<http://hynek.cihlar@gmail.com>
>>>>> 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 <<http://rhuddleston@gmail.com>
>>>>> 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: <http://freeswitch-users-bounces@lists.freeswitch.org>
>>>>> freeswitch-users-bounces at lists.freeswitch.org
>>>>> >  [ <freeswitch-users-bounces at lists.freeswitch.org>
>>>>> mailto: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" < <http://infos@madovsky.org>infos at madovsky.org>
>>>>> >> To: "FreeSWITCH Users  Help" <<http://freeswitch-users@lists.freeswitch.org>
>>>>> 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" < <http://cliff@develix.com>cliff at develix.com>
>>>>> >>> To: "FreeSWITCH  Users Help" <<http://freeswitch-users@lists.freeswitch.org>
>>>>> 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
>>>>> >>>> <http://FreeSWITCH-users@lists.freeswitch.org>
>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>> >>>>   <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> >>>>
>>>>> >  UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>> >>>>   <http://www.freeswitch.org>http://www.freeswitch.org
>>>>> >>
>>>>> >>  FreeSWITCH-users mailing list
>>>>> >> <http://FreeSWITCH-users@lists.freeswitch.org>
>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>> >> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> >>  UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>> >>   <http://www.freeswitch.org>http://www.freeswitch.org
>>>>> >
>>>>> >
>>>>> >
>>>>> >  FreeSWITCH-users mailing list
>>>>> > <http://FreeSWITCH-users@lists.freeswitch.org>
>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>> > <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> >  UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>> >   <http://www.freeswitch.org>http://www.freeswitch.org
>>>>> >
>>>>> >
>>>>> >
>>>>> >  FreeSWITCH-users mailing list
>>>>> > <http://FreeSWITCH-users@lists.freeswitch.org>
>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>> > <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> >  UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>> >   <http://www.freeswitch.org>http://www.freeswitch.org
>>>>>
>>>>>
>>>>> FreeSWITCH-users  mailing list
>>>>> <http://FreeSWITCH-users@lists.freeswitch.org>
>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>>  <http://www.freeswitch.org>http://www.freeswitch.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>  ------------------------------
>>>>>
>>>>>
>>>>> FreeSWITCH-users mailing list
>>>>> <FreeSWITCH-users at lists.freeswitch.org>
>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>>  <http://www.freeswitch.org>http://www.freeswitch.org
>>>>>
>>>>>
>>>>>
>>>>> FreeSWITCH-users mailing list
>>>>>  <FreeSWITCH-users at lists.freeswitch.org>
>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>>  <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>>  <http://www.freeswitch.org>http://www.freeswitch.org
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Anthony Minessale II
>>>>
>>>> FreeSWITCH <http://www.freeswitch.org/>http://www.freeswitch.org/
>>>> ClueCon <http://www.cluecon.com/>http://www.cluecon.com/
>>>> Twitter: <http://twitter.com/FreeSWITCH_wire>
>>>> http://twitter.com/FreeSWITCH_wire
>>>>
>>>> AIM: anthm
>>>> MSN:anthony_minessale at hotmail.com
>>>> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
>>>> IRC: <http://irc.freenode.net>irc.freenode.net #freeswitch
>>>>
>>>> FreeSWITCH Developer Conference
>>>> sip: <sip%3A888 at conference.freeswitch.org>888 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
>>>>
>>>>
>>>>
>>>> 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
>>>
>>>
>>> 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/20111028/b924acff/attachment-0001.html

Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list