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