[Freeswitch-users] Best database setup for high volume

Avi Marcus avi at avimarcus.net
Tue May 29 16:53:58 MSD 2012


Do you do anything to keep the voicemail DB on the actual hard drive rather
than also in ramdisk? I presume that in the case of a system crash,
everything in the ramdisk is lost...

-Avi


On Tue, May 29, 2012 at 2:56 PM, Wesley Akio <wesleyakio at tuntscorp.com>wrote:

> Hi Andy,
>
> This is as simple as it gets, and performace of sqlite is inarguably
> superior...
>
> mkfs.ext2 /dev/ram0 &2> /dev/null
> mount /dev/ram0 /usr/local/freeswitch/db &2> /dev/null
> exec /usr/local/freeswitch/bin/freeswitch -nc -nonat
>
> Works for me and it has for quite some time...
>
> Wesley Akio
> TuntsCorp.com
>
>
>
> On Tue, May 29, 2012 at 8:00 AM, Andy Ayers <andy at fabulous4.co.uk> wrote:
>
>> Many thanks Wesley that would be extremely helpful.****
>>
>> ** **
>>
>> *From:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
>> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Wesley Akio
>> *Sent:* 28 May 2012 13:42
>>
>> *To:* FreeSWITCH Users Help
>> *Subject:* Re: [Freeswitch-users] Best database setup for high volume****
>>
>> ** **
>>
>> Pretty easy, just format a ramdisk and mount it... Will send you my init
>> script as soon as I get to the office...****
>>
>> Sent from mobile, sorry for the typos....****
>>
>> Em 28/05/2012 06:32, "Andy Ayers" <andy at fabulous4.co.uk> escreveu:****
>>
>> Disk at the moment. Is it easy to move it to memory?****
>>
>>  ****
>>
>> *From:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
>> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Wesley Akio
>> *Sent:* 24 May 2012 12:58
>> *To:* FreeSWITCH Users Help
>> *Subject:* Re: [Freeswitch-users] Best database setup for high volume****
>>
>>  ****
>>
>> Out of curiosity, do you run sqlite from memory or disk?****
>>
>> Sent from mobile, sorry for the typos....****
>>
>> Em 24/05/2012 06:33, "Andy Ayers" <andy at fabulous4.co.uk> escreveu:****
>>
>> Hi Avi,****
>>
>>  ****
>>
>> Yes sadly I’ve been through all those options and am still getting the
>> error. Tried OPTION and OPTIONS but it doesn’t seem to make any difference.
>> There seem to be a few other folks on the users list that have had the same
>> problem and not managed to find a solution.****
>>
>>  ****
>>
>> Cheers****
>>
>> Andy****
>>
>>  ****
>>
>> *From:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
>> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Avi Marcus
>> *Sent:* 23 May 2012 19:10
>> *To:* FreeSWITCH Users Help
>> *Subject:* Re: [Freeswitch-users] Best database setup for high volume****
>>
>>  ****
>>
>> On Wed, May 23, 2012 at 8:36 PM, Andy Ayers <andy at fabulous4.co.uk> wrote:
>> ****
>>
>> Many thanks for your reply Avi, that’s very helpful.****
>>
>>  ****
>>
>> I’ve disabled the sql scoreboard and presence and all seems to be ok so
>> those should help.****
>>
>>  ****
>>
>> My traffic consists of relatively high volumes of incoming and outgoing
>> calls but all one sided. i.e. It’s the switch taking the caller through an
>> ivr ‘form’ so there are no 2-way calls, no bridging, forwarding or
>> directing of calls at all. The only time multiple callers are involved is
>> when we use it for conferencing which is only small scale at the moment.*
>> ***
>>
>>  ****
>>
>> It’s the database corruption issue I’m really interested in solving so
>> I’d like to get the odbc connection working if possible. Any info you can
>> provide on how you got that to work would be greatly appreciated. Like I
>> say I hit 2 problems:****
>>
>>  ****
>>
>> Firstly on load freeswitch complains that it can’t run multiple
>> statements. I’ve tried everything that’s recommended in the MyOdbc docs
>> including setting the options in odbc.ini but still get the error. Some
>> posts talk about needing to use to _r version of the driver but I don’t
>> have that on my system. I’m running Debian if that’s significant.****
>>
>> Did you set:****
>>
>> OPTIONS  = 67108864****
>>
>> in the odbc.ini, for  FLAG_MULTI_STATEMENTS? (Supposedly it's "OPTION"
>> on centos)****
>>
>> http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core****
>>
>>  ****
>>
>> -Avi****
>>
>>  ****
>>
>> The second issue was a message popping up in the logs every few seconds
>> saying: Error in my_thread_global_end() nn threads didn’t exit.****
>>
>> Did you encounter either of these problems or find ways round them?****
>>
>>  ****
>>
>> Once again many thanks for any help.****
>>
>>  ****
>>
>> Cheers****
>>
>> Andy****
>>
>>  ****
>>
>> *From:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
>> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Avi Marcus
>> *Sent:* 23 May 2012 09:52
>> *To:* FreeSWITCH Users Help
>> *Subject:* Re: [Freeswitch-users] Best database setup for high volume****
>>
>>  ****
>>
>> Is your issue the CDRs & Voicemail or session count, current calls,
>> recovery data..****
>>
>> You can make sure track-calls is off... ****
>>
>>  ****
>>
>>  ****
>>
>>  ****
>>
>>  ****
>>
>> -nosql                 -- disable internal sql scoreboard****
>>
>> I'm not sure if that kills presence or not.****
>>
>>  ****
>>
>> Disable presence if you don't need it - it's a real usage hog.****
>>
>>  ****
>>
>> I have odbc to mysql but I made calls,channels,sip_dialogs,
>> sip_subscriptions, etc into memory tables a few months ago.****
>>
>>  ****
>>
>> (I left sip_registrations as non-memory for persistence of a sort)****
>>
>>  ****
>>
>> -Avi****
>>
>>  ****
>>
>> On Wed, May 23, 2012 at 11:29 AM, Andy Ayers <andy at fabulous4.co.uk>
>> wrote:****
>>
>> Hi,****
>>
>>  ****
>>
>> Can anyone tell me what the best database setup is for dealing with high
>> call volumes?****
>>
>>  ****
>>
>> The background:****
>>
>>  ****
>>
>> I’ve been running with the standard SQLite system for about 3 years
>> without issue but recently am getting a lot of database corruption errors
>> (‘database disk image is malformed’). Easily solved by deleting the db and
>> restarting but on occasion it brings my switch down.****
>>
>>  ****
>>
>> I’ve tried upgrading to odbc and mysql but hit 2 problems:****
>>
>>  ****
>>
>> FLAG_MULTIPLE_STATEMENTS****
>>
>> Error in my_thread_global_end()****
>>
>>  ****
>>
>> Both of which are mentioned in the user groups but not with any solutions
>> that worked.****
>>
>>  ****
>>
>> I’ve just upgraded to version 1.2 so this may solve the corruption
>> problems but would really like to get my system set up to handle as much
>> traffic as possible.****
>>
>>  ****
>>
>> Any advice or suggestions much appreciated.****
>>
>>  ****
>>
>> Kind regards****
>>
>> Andy****
>>
>>  ****
>>
>>
>> _________________________________________________________________________
>> 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
>>
>> Join Us At ClueCon - Aug 7-9, 2012
>>
>> 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
>>
>> Join Us At ClueCon - Aug 7-9, 2012
>>
>> 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
>>
>> Join Us At ClueCon - Aug 7-9, 2012
>>
>> 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
>>
>> Join Us At ClueCon - Aug 7-9, 2012
>>
>> 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
>>
>> Join Us At ClueCon - Aug 7-9, 2012
>>
>> 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
>
> Join Us At ClueCon - Aug 7-9, 2012
>
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120529/3a0e29cd/attachment-0001.html 


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