[Freeswitch-users] Best database setup for high volume

Mon May 28 13:30:53 MSD 2012

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120528/bd001a33/attachment-0001.html 