[Freeswitch-users] High load on database server

[curriegrad2004]

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 at 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 at develix.com>
> To: "FreeSWITCH Users Help" <freeswitch-users at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
> --
> 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 at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>