[Freeswitch-users] Best database setup for high volume

Kristian Kielhofner kris at kriskinc.com
Tue May 29 19:52:44 MSD 2012


This structure of commands is very bizarre...  I highly, highly
suggest using tmpfs instead of this method.  Besides, it's easier:

mount -t tmpfs none /usr/local/freeswitch/db

On Tue, May 29, 2012 at 7:56 AM, 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
>



-- 
Kristian Kielhofner



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