<div dir="ltr">Is your issue the CDRs & Voicemail or session count, current calls, recovery data..<div>You can make sure track-calls is off... </div><div><pre style="padding-top:1em;padding-right:1em;padding-bottom:1em;padding-left:1em;border-top-width:1px;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-top-style:dashed;border-right-style:dashed;border-bottom-style:dashed;border-left-style:dashed;border-top-color:rgb(47,111,171);border-right-color:rgb(47,111,171);border-bottom-color:rgb(47,111,171);border-left-color:rgb(47,111,171);background-color:rgb(249,249,249);line-height:1.1em">
-nosql -- disable internal sql scoreboard</pre><div dir="ltr"><font face="Verdana, Arial, Helvetica, sans-serif">I'm not sure if that kills presence or not.</font></div><div dir="ltr"><font face="Verdana, Arial, Helvetica, sans-serif"><br>
</font></div><div dir="ltr"><font face="Verdana, Arial, Helvetica, sans-serif">Disable presence if you don't need it - it's a real usage hog.</font></div><div dir="ltr"><font face="Verdana, Arial, Helvetica, sans-serif"><br>
</font></div><div dir="ltr"><font face="Verdana, Arial, Helvetica, sans-serif">I have odbc to mysql but I made calls,channels,sip_dialogs, sip_subscriptions, etc into memory tables a few months ago.</font></div><div dir="ltr">
<font face="Verdana, Arial, Helvetica, sans-serif"><br></font></div><div dir="ltr"><font face="Verdana, Arial, Helvetica, sans-serif">(I left </font>sip_registrations as non-memory for persistence of a sort)</div><div dir="ltr">
<font face="Verdana, Arial, Helvetica, sans-serif"><br></font></div><div dir="ltr"><span style="font-family:Verdana,Arial,Helvetica,sans-serif"><span style="font-size:small">-Avi</span></span></div><br><div class="gmail_quote">
On Wed, May 23, 2012 at 11:29 AM, Andy Ayers <span dir="ltr"><<a href="mailto:andy@fabulous4.co.uk" target="_blank">andy@fabulous4.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="blue" vlink="purple"><div><p class="MsoNormal">Hi,<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Can anyone tell me what the best database setup is for dealing with high call volumes?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">The background:<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I’ve tried upgrading to odbc and mysql but hit 2 problems:<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">FLAG_MULTIPLE_STATEMENTS<u></u><u></u></p>
<p class="MsoNormal">Error in my_thread_global_end()<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Both of which are mentioned in the user groups but not with any solutions that worked.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Any advice or suggestions much appreciated.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Kind regards<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></p>
<span class="HOEnZb"><font color="#888888"><p class="MsoNormal">Andy<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p></font></span></div></div><br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
Join Us At ClueCon - Aug 7-9, 2012<br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div></div>