Re: [Freeswitch-users] High load on database server
but, is anyone experienced that with shared ODBC ? (managing more than 330 concurrent calls) ----- Original Message ----- From: "Madovsky" <infos@madovsky.org> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Combine the knowledge expressed in this thread and make the right choices and you can get any load you want within the limits of the box's resources. On Thu, Oct 27, 2011 at 11:36 AM, Madovsky <infos@madovsky.org> wrote:
but, is anyone experienced that with shared ODBC ? (managing more than 330 concurrent calls)
----- Original Message ----- From: "Madovsky" <infos@madovsky.org> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
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@madovsky.org> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@lists.freeswitch.org [mailto:freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
FreeSWITCH-users mailing list FreeSWITCH-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
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@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@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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
on this subject, is SIPp can be used to test to reproduce hundreds calls ? ----- Original Message ----- From: Anthony Minessale To: FreeSWITCH Users Help 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@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@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@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@lists.freeswitch.org > [mailto:freeswitch-users-bounces@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@madovsky.org> >> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> >>> To: "FreeSWITCH Users Help" <freeswitch-users@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@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@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@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900 -- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900 ------------------------------------------------------------------------------ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@gmail.com>
To: FreeSWITCH Users Help <mailto:freeswitch-users@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@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@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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@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@madovsky.org> >> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> > >>> To: "FreeSWITCH Users Help" <freeswitch-users@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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Re: [Freeswitch-users] High load on database serverThanks 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 To: FreeSWITCH Users Help 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@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@gmail.com> To: FreeSWITCH Users Help <mailto:freeswitch-users@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@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@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@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@lists.freeswitch.org > [mailto:freeswitch-users-bounces@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@madovsky.org> >> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> >>> To: "FreeSWITCH Users Help" <freeswitch-users@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@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@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@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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@freeswitch.org> *To:* FreeSWITCH Users Help <freeswitch-users@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@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@gmail.com<anthony.minessale@gmail.com>>
*To:* FreeSWITCH Users Help <mailto:freeswitch-users@lists.freeswitch.org<freeswitch-users@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@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@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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org<freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@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@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
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@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@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@freeswitch.org> *To:* FreeSWITCH Users Help <freeswitch-users@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@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@gmail.com<anthony.minessale@gmail.com><anthony.minessale@gmail.com>>
*To:* FreeSWITCH Users Help <mailto:freeswitch-users@lists.freeswitch.org<freeswitch-users@lists.freeswitch.org><freeswitch-users@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@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@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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org<freeswitch-users-bounces@lists.freeswitch.org><freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" <freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@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@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> googletalk:conf+888@conference.freeswitch.org pstn:+19193869900 FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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-connecti... 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.h... or http://tinyurl.com/4xo26sv On Thu, Oct 27, 2011 at 1:29 PM, Hynek Cihlar <hynek.cihlar@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@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@madovsky.org> infos@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@freeswitch.org> *To:* FreeSWITCH Users Help <freeswitch-users@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@madovsky.org>infos@madovsky.org> wrote:
on this subject, is SIPp can be used to test to reproduce hundreds calls ?
----- Original Message -----
*From:* Anthony Minessale < <anthony.minessale@gmail.com> mailto:anthony.minessale@gmail.com <anthony.minessale@gmail.com>>
*To:* FreeSWITCH Users Help < <freeswitch-users@lists.freeswitch.org> mailto:freeswitch-users@lists.freeswitch.org<freeswitch-users@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@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@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@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@lists.freeswitch.org [ <freeswitch-users-bounces@lists.freeswitch.org> mailto:freeswitch-users-bounces@lists.freeswitch.org<freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" <<http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <<http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@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
FreeSWITCH-users mailing list <http://FreeSWITCH-users@lists.freeswitch.org> FreeSWITCH-users@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@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@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@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@lists.freeswitch.org> FreeSWITCH-users@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@lists.freeswitch.org> FreeSWITCH-users@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: <http://irc.freenode.net>irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip: <sip%3A888@conference.freeswitch.org>888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
Hey Anthony, I think he¹s being a little confused here... What tony is refering to, is stacked statements ³select * from foo; update bar set foo=bar; some other statement;² Allowing stacked statements in 1 call over ODBC is bad mojo that¹s exactly host most sql injections work in the first place ³select * from users where username = $USERNAME¹² ... Replace $USERNAME with the next line ; UPDATE users set password=NEWPASSWORD where username = admin¹; -- Boom sql injection... Now there are other ways to protect against this like properly escaping input from 3rd parties going into your sql statements but it still happens all the time... This is one of the main reasons I use prepared statements on Postgresql cause it stops this sort of behavior cold in its tracks... You should still properly escape inputs but the extra layer is worth it On 10/27/11 2:08 PM, "Anthony Minessale" <anthony.minessale@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-connecti... -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.htm> l
or
On Thu, Oct 27, 2011 at 1:29 PM, Hynek Cihlar <hynek.cihlar@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@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 < <mailto:infos@madovsky.org> infos@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 <mailto:krice@freeswitch.org>
To: FreeSWITCH Users Help <mailto:freeswitch-users@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" < <mailto:infos@madovsky.org> infos@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@gmail.com> > mailto:anthony.minessale@gmail.com> > > To: FreeSWITCH Users Help < > <mailto:freeswitch-users@lists.freeswitch.org> > mailto:freeswitch-users@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@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@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@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@lists.freeswitch.org [ <mailto:freeswitch-users-bounces@lists.freeswitch.org> mailto:freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" < <http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" < <http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@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
FreeSWITCH-users mailing list <http://FreeSWITCH-users@lists.freeswitch.org> FreeSWITCH-users@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@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@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@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 <mailto:FreeSWITCH-users@lists.freeswitch.org> FreeSWITCH-users@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 <mailto:FreeSWITCH-users@lists.freeswitch.org> FreeSWITCH-users@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
ya so furthermore, The core and sofia has to be generic so it uses ANSI sql transactions with BEGIN; <2000 sql stmts> COMMIT; This falls under the category of multi-line stmts and breaks w/o that enabled thus making the DB suck much more. On Thu, Oct 27, 2011 at 2:35 PM, Ken Rice <krice@freeswitch.org> wrote:
Hey Anthony,
I think he’s being a little confused here...
What tony is refering to, is stacked statements “select * from foo; update bar set foo=bar; some other statement;”
Allowing stacked statements in 1 call over ODBC is bad mojo that’s exactly host most sql injections work in the first place
“select * from users where username = ‘$USERNAME’” ... Replace $USERNAME with the next line
‘; UPDATE users set password=NEWPASSWORD where username = ‘admin’; --
Boom sql injection... Now there are other ways to protect against this like properly escaping input from 3rd parties going into your sql statements but it still happens all the time...
This is one of the main reasons I use prepared statements on Postgresql cause it stops this sort of behavior cold in its tracks... You should still properly escape inputs but the extra layer is worth it
On 10/27/11 2:08 PM, "Anthony Minessale" <anthony.minessale@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-connecti... 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.h...
or
On Thu, Oct 27, 2011 at 1:29 PM, Hynek Cihlar <hynek.cihlar@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@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 < <mailto:infos@madovsky.org<infos@madovsky.org>> infos@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 <mailto:krice@freeswitch.org <krice@freeswitch.org>>
*To:* FreeSWITCH Users Help <mailto:freeswitch-users@lists.freeswitch.org<freeswitch-users@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" < <mailto:infos@madovsky.org<infos@madovsky.org>> infos@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@gmail.com<anthony.minessale@gmail.com>> mailto:anthony.minessale@gmail.com <anthony.minessale@gmail.com>>
*To:* FreeSWITCH Users Help < < mailto:freeswitch-users@lists.freeswitch.org<freeswitch-users@lists.freeswitch.org>> mailto:freeswitch-users@lists.freeswitch.org<freeswitch-users@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@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@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@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@lists.freeswitch.org [ <mailto:freeswitch-users-bounces@lists.freeswitch.org<freeswitch-users-bounces@lists.freeswitch.org>> mailto:freeswitch-users-bounces@lists.freeswitch.org<freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" < < http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" < < http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@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
FreeSWITCH-users mailing list <http://FreeSWITCH-users@lists.freeswitch.org> FreeSWITCH-users@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@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@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@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 <mailto:FreeSWITCH-users@lists.freeswitch.org<FreeSWITCH-users@lists.freeswitch.org>> FreeSWITCH-users@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 <mailto:FreeSWITCH-users@lists.freeswitch.org<FreeSWITCH-users@lists.freeswitch.org>> FreeSWITCH-users@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
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@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-connecti... 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.h...
or
On Thu, Oct 27, 2011 at 1:29 PM, Hynek Cihlar <hynek.cihlar@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@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@madovsky.org> infos@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@freeswitch.org> *To:* FreeSWITCH Users Help <freeswitch-users@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@madovsky.org> infos@madovsky.org> wrote:
on this subject, is SIPp can be used to test to reproduce hundreds calls ?
----- Original Message -----
*From:* Anthony Minessale < <anthony.minessale@gmail.com> mailto:anthony.minessale@gmail.com <anthony.minessale@gmail.com>>
*To:* FreeSWITCH Users Help < <freeswitch-users@lists.freeswitch.org> mailto:freeswitch-users@lists.freeswitch.org<freeswitch-users@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@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@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@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@lists.freeswitch.org [ <freeswitch-users-bounces@lists.freeswitch.org> mailto:freeswitch-users-bounces@lists.freeswitch.org<freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" <<http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@develix.com> To: "FreeSWITCH Users Help" <<http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@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@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@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@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@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@lists.freeswitch.org> FreeSWITCH-users@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@lists.freeswitch.org> FreeSWITCH-users@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: <http://irc.freenode.net>irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip: <sip%3A888@conference.freeswitch.org>888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@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-connecti... 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.h...
or
On Thu, Oct 27, 2011 at 1:29 PM, Hynek Cihlar <hynek.cihlar@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@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@madovsky.org> infos@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@freeswitch.org> *To:* FreeSWITCH Users Help <freeswitch-users@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@madovsky.org> infos@madovsky.org> wrote:
on this subject, is SIPp can be used to test to reproduce hundreds calls ?
----- Original Message -----
*From:* Anthony Minessale < <anthony.minessale@gmail.com> mailto:anthony.minessale@gmail.com <anthony.minessale@gmail.com>>
*To:* FreeSWITCH Users Help < <freeswitch-users@lists.freeswitch.org> mailto:freeswitch-users@lists.freeswitch.org<freeswitch-users@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@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@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@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@lists.freeswitch.org [ <freeswitch-users-bounces@lists.freeswitch.org> mailto:freeswitch-users-bounces@lists.freeswitch.org<freeswitch-users-bounces@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@madovsky.org> To: "FreeSWITCH Users Help" <<http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@develix.com> > To: "FreeSWITCH Users Help" <<http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@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@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@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@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@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@lists.freeswitch.org> FreeSWITCH-users@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@lists.freeswitch.org> FreeSWITCH-users@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: <http://irc.freenode.net>irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip: <sip%3A888@conference.freeswitch.org>888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
FreeSWITCH-users mailing list FreeSWITCH-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@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@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-connecti... 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.h...
or
On Thu, Oct 27, 2011 at 1:29 PM, Hynek Cihlar <hynek.cihlar@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@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@madovsky.org> infos@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@freeswitch.org> *To:* FreeSWITCH Users Help <freeswitch-users@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@madovsky.org> infos@madovsky.org> wrote:
on this subject, is SIPp can be used to test to reproduce hundreds calls ?
----- Original Message -----
*From:* Anthony Minessale < <anthony.minessale@gmail.com> mailto:anthony.minessale@gmail.com <anthony.minessale@gmail.com>>
*To:* FreeSWITCH Users Help < <freeswitch-users@lists.freeswitch.org> mailto:freeswitch-users@lists.freeswitch.org<freeswitch-users@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@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@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@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@lists.freeswitch.org [ <freeswitch-users-bounces@lists.freeswitch.org> mailto:freeswitch-users-bounces@lists.freeswitch.org<freeswitch-users-bounces@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@madovsky.org> > To: "FreeSWITCH Users Help" <<http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@develix.com> >> To: "FreeSWITCH Users Help" <<http://freeswitch-users@lists.freeswitch.org> freeswitch-users@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@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@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@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@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@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@lists.freeswitch.org> FreeSWITCH-users@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@lists.freeswitch.org> FreeSWITCH-users@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: <http://irc.freenode.net>irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip: <sip%3A888@conference.freeswitch.org>888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
On Thu, Oct 27, 2011 at 7:36 PM, Anthony Minessale < anthony.minessale@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
Enable transactions? What does it mean? When you experience the segfault,in which module (mem address), if it is tracable? Hynek
participants (7)
-
Anthony Minessale
-
Avi Marcus
-
Hynek Cihlar
-
Ken Rice
-
Madovsky
-
Robert Huddleston
-
Sergey Okhapkin