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@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@fabulous4.co.uk> wrote:
Many thanks Wesley that would be extremely helpful.****
** **
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@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@fabulous4.co.uk> escreveu:****
Disk at the moment. Is it easy to move it to memory?****
****
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@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@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@lists.freeswitch.org [mailto: freeswitch-users-bounces@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@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@lists.freeswitch.org [mailto: freeswitch-users-bounces@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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org