<div dir="ltr">I didn't have that issue..<div>I actually changed the channels, calls, sip_subscriptions and anything else transitory to memory tables to they wouldn't write to disk.</div><div>I kept regs as myisam so it would persist.</div>
<div><br clear="all"><div dir="ltr"><span style="font-family:Verdana,Arial,Helvetica,sans-serif"><span style="font-size:small">-Avi</span></span></div>
<br><br><div class="gmail_quote">On Mon, Mar 19, 2012 at 11:12 PM, GCHEN00 <span dir="ltr"><<a href="mailto:gchen00@insightbb.com">gchen00@insightbb.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div bgcolor="#ffffff">
<div><font face="Arial">When I use ODBC as core database, freeswitch auto
create the database tables using engine=MyISAM.</font></div>
<div><font face="Arial">I have to change the table type to innodb
for 'complete' table to avoid the Maximum index length ERROR.</font></div>
<div><font face="Arial">My question is should I change rest
of the tables to innodb or just leave them as MyISAM. </font></div>
<div><font face="Arial"></font> </div>
<div><font face="Arial">Which one is better suited for
freeswitch?</font></div>
<div><font face="Arial"></font> </div>
<div><font face="Arial">Gary</font></div>
<div><font face="Arial"></font> </div>
<div> </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>
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>