[Freeswitch-users] Best database setup for high volume

[Avi Marcus]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120523/2176a532/attachment.html