[Freeswitch-users] High load on database server

Hynek Cihlar hynek.cihlar at gmail.com
Thu Oct 27 22:06:00 MSD 2011


On Thu, Oct 27, 2011 at 7:36 PM, Anthony Minessale <
anthony.minessale at gmail.com> wrote:

> Let's recap
>
> You have 4 moving parts, you have various versions of all 4 to choose from
> and even different implementations of 3 of the 4.
>
> ODBC LIB
> ODBC DRIVER
>  DATABASE
> FS
>
> You must choose a stable combination of all 4 which may require specific
> configuration of each component as well.
>
> My only issue is FUD, I do not want people to advertise that FS does not
> work on ODBC under load when the whole story is FS does not work under load
> when you use fooODBC with barDRIVER with basBASE database server configured
> a particular way.
>
> It should never crash, if it does, its a bug in something.  I can speak for
> FS that there is no bug there.  The other 3 are variables.
> Remember this next time there is a discussion about using system libs and
> why we build our own depends.  The one thing we use system libs for, ODBC,
> is a huge PITA.........
>
> Things to remember:
>
> 1) try the Threading=0 in the odbcinst.ini, this is a serious problem and
> has been made the default in latest versions.
> 2) If you must use Mysql, enable transactions and make sure your odbc.ini
> is referencing the threadsafe version of the lib
>      libmyodbc3_r.so <-- note _r
>

Enable transactions? What does it mean?

When you experience the segfault,in which module (mem address), if it is
tracable?

Hynek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111027/27a72879/attachment.html 


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