Re: [Freeswitch-users] High load on database server
Hello, I have had lot's of issues with 2.14 odbc as well, the Threadong parameter helped to reduce the crashes from approx. 4 a day to 1 a day, but the crashing was still there. I compiled my own debian packages for odbc with the 2.11 centos 5 sources (so I can install other debiacn packages that depend on odbc) and this works like a charm! So I would recommend using 2.11 instead of 2.14, I do not have expierence with newer odbc's though. using postgres 9.(0|1), 8.4 and debian squeeze with fairly recent Freeswitch boxes best ----- Original Message ----- From: "Cliff Wells" <cliff@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@lists.freeswitch.org> Sent: Thursday, October 27, 2011 8:02:46 AM Subject: Re: [Freeswitch-users] High load on database server On Wed, 2011-10-26 at 11:12 -0500, Anthony Minessale wrote:
if you have older unixodbc edit /etc/odbcinst.ini and add the param Threading=0 to each db entry.
In general postgres to me appears to care more about multithreaded environments and with the above threading=0 change works pretty well.
I tried this (after googling a bit and coming across an older thread you responded to) and it didn't change anything. Crashes at ~330 concurrent calls like clockwork. This was with unixODBC 2.14 and PostgreSQL 8.4 odbc driver. 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 -- Logitravel.com Raimund Sacherer Sistemas Agencia de Viajes Online www.logitravel.com Edificio Logitravel, Parcela 3B (Parc Bit) Ctra. Palma - Valldemossa km 7,4 | 07121 Palma de Mallorca Tel 902 366 847 | Fax 971 213 495 Síguenos en: Facebook de Logitravel Twitter de Logitravel Blog de Logitravel Logitravel en Youtube Logitravel en Foursquare Descarga nuestras aplicaciones para móvil Logitravel.com Este correo electrónico y, en su caso, cualquier fichero anexo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario. Queda prohibida su divulgación, copia o distribución a terceros sin la previa autorización escrita de LOGITRAVEL S.L.. En caso de haber recibido este correo electrónico por error, se ruega notifíquese inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente. Al mismo tiempo LA EMPRESA le recuerda que sus datos forman o formarán parte de un fichero registrado como CLIENTES con número de inscripción 2070610043 en la Agencia General de Protección de Datos, propiedad de la empresa LOGITRAVEL, con domicilio en Edificio Logitravel, Ctra. Palma - Valldemosa km 7,4, Parc Bit, Palma de Mallorca. Usted tiene derecho de acceso, oposición, rectificación y cancelación a estos datos que deberá ejercer mediante escrito a la dirección anteriormente citada.
FreeSWITCH at the moment compiles fine with iODBC and you might give that a try if you want to see if that does anything On Fri, Nov 18, 2011 at 4:00 AM, Raimund Sacherer <raimund.sacherer@logitravel.com> wrote:
Hello,
I have had lot's of issues with 2.14 odbc as well, the Threadong parameter helped to reduce the crashes from approx. 4 a day to 1 a day, but the crashing was still there.
I compiled my own debian packages for odbc with the 2.11 centos 5 sources (so I can install other debiacn packages that depend on odbc) and this works like a charm!
So I would recommend using 2.11 instead of 2.14, I do not have expierence with newer odbc's though.
using postgres 9.(0|1), 8.4 and debian squeeze with fairly recent Freeswitch boxes
best
----- Original Message ----- From: "Cliff Wells" <cliff@develix.com> To: "FreeSWITCH Users Help" <freeswitch-users@lists.freeswitch.org> Sent: Thursday, October 27, 2011 8:02:46 AM Subject: Re: [Freeswitch-users] High load on database server
On Wed, 2011-10-26 at 11:12 -0500, Anthony Minessale wrote:
if you have older unixodbc edit /etc/odbcinst.ini and add the param Threading=0 to each db entry.
In general postgres to me appears to care more about multithreaded environments and with the above threading=0 change works pretty well.
I tried this (after googling a bit and coming across an older thread you responded to) and it didn't change anything. Crashes at ~330 concurrent calls like clockwork. This was with unixODBC 2.14 and PostgreSQL 8.4 odbc driver.
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
-- Logitravel.com Raimund Sacherer Sistemas Agencia de Viajes Online www.logitravel.com Edificio Logitravel, Parcela 3B (Parc Bit) Ctra. Palma - Valldemossa km 7,4 | 07121 Palma de Mallorca Tel 902 366 847 | Fax 971 213 495 Síguenos en: Facebook de Logitravel Twitter de Logitravel Blog de Logitravel Logitravel en Youtube Logitravel en Foursquare Descarga nuestras aplicaciones para móvil Logitravel.com Este correo electrónico y, en su caso, cualquier fichero anexo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario. Queda prohibida su divulgación, copia o distribución a terceros sin la previa autorización escrita de LOGITRAVEL S.L.. En caso de haber recibido este correo electrónico por error, se ruega notifíquese inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente. Al mismo tiempo LA EMPRESA le recuerda que sus datos forman o formarán parte de un fichero registrado como CLIENTES con número de inscripción 2070610043 en la Agencia General de Protección de Datos, propiedad de la empresa LOGITRAVEL, con domicilio en Edificio Logitravel, Ctra. Palma - Valldemosa km 7,4, Parc Bit, Palma de Mallorca. Usted tiene derecho de acceso, oposición, rectificación y cancelación a estos datos que deberá ejercer mediante escrito a la dirección anteriormente citada.
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
I had exactly the same problem with PGSQL and FS, moved to MySQL for the core DB and everything is fine. PGSQL's transaction logging is pretty heavyweight for the amount of transactions you get from FS, but if you are really needing to use PostGres I would look at using unlogged tables. As I say though, MySQL runs like a charm, I've had it at well over 300CPS with 500 registrations/sec. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Re-High-load-on-database-serve... Sent from the freeswitch-users mailing list archive at Nabble.com.
On Wed, 2011-11-23 at 13:23 -0800, peely wrote:
I had exactly the same problem with PGSQL and FS, moved to MySQL for the core DB and everything is fine.
PGSQL's transaction logging is pretty heavyweight for the amount of transactions you get from FS, but if you are really needing to use PostGres I would look at using unlogged tables.
As I say though, MySQL runs like a charm, I've had it at well over 300CPS with 500 registrations/sec.
The OP was using MySQL 5.5. Further, his call load is what I would term "very light". His issue is unlikely to be solved by changing databases. Other people's issues appear to be related to ODBC drivers rather than PostgreSQL itself (my own were solved by upgrading to unixODBC 3.0). Unless you are using MyISAM, MySQL and PostgreSQL aren't drastically different in performance these days. Cliff
participants (4)
-
Cliff Wells
-
curriegrad2004
-
peely
-
Raimund Sacherer