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