[Freeswitch-users] Is MySQL OK to use?

[Anthony Minessale]

I've always seen Threading=0 as the solution to stability probs.
Basically if the driver already uses mutexing, its better to disable the
arbitrary ones in the core of odbc.
For postgres 0 is basically mandatory.



On Fri, Nov 22, 2013 at 2:12 AM, Steven Ayre <steveayre at gmail.com> wrote:

> No such thing in the latest versions, they're all threadsafe now (_r is a
> symlink to the other).
>
> I use it with success. I did find stability problems in libmyodbc when
> upgrading from 5.0 to 5.5. My solution was to add these to odbc.ini
>
> Option      = 67108864
> Threading   = 2
>
> The Threading setting is what stopped the crashes. There's a Jira on the
> subject and someone else said manually upgrading to a newer version of
> unixodbc+myodbc also fixed it.
>
> -Steve
>
>
>
> On 21 November 2013 18:23, Jeff Leung <jleung at v10networks.ca> wrote:
>
>> Try the non-thread safe MySQL library instead of the thread safe one.
>>
>>
>>
>> *From:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
>> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Vik Killa
>> *Sent:* Thursday, November 21, 2013 10:22 AM
>> *To:* FreeSWITCH Users Help
>> *Subject:* Re: [Freeswitch-users] Is MySQL OK to use?
>>
>>
>>
>> short answer no.
>>
>> use postgres
>>
>>
>>
>> On Thu, Nov 21, 2013 at 12:41 PM, Alex Lake <alex at digitalmail.com> wrote:
>>
>> I find these "Error in my_thread_global_end()" messages somewhat
>> annoying in my fs1.2stable on Ubuntu12.04 box. Is there any advice
>> (other than "don't use MySQL") for how to install it better? Might it be
>> something to do with thread-safe libraries (I'm using libmyodbc_r.so at
>> the moment)
>>
>> _________________________________________________________________________
>> 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
>>
>>
>>
>> _________________________________________________________________________
>> 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
>>
>>
>
> _________________________________________________________________________
> 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
>
>


-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20131122/e762a407/attachment.html