Question about mysql database engine type.
When I use ODBC as core database, freeswitch auto create the database tables using engine=MyISAM. I have to change the table type to innodb for 'complete' table to avoid the Maximum index length ERROR. My question is should I change rest of the tables to innodb or just leave them as MyISAM. Which one is better suited for freeswitch? Gary
I didn't have that issue.. I actually changed the channels, calls, sip_subscriptions and anything else transitory to memory tables to they wouldn't write to disk. I kept regs as myisam so it would persist. -Avi On Mon, Mar 19, 2012 at 11:12 PM, GCHEN00 <gchen00@insightbb.com> wrote:
** When I use ODBC as core database, freeswitch auto create the database tables using engine=MyISAM. I have to change the table type to innodb for 'complete' table to avoid the Maximum index length ERROR. My question is should I change rest of the tables to innodb or just leave them as MyISAM.
Which one is better suited for freeswitch?
Gary
_________________________________________________________________________ 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
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
The wiki on FS does say how the driver should be configured iirc, but some of the heavy users here prefer postgresql for the high performance code, but at the end of the day all it boils down to is how you want to use FS as and what not. On Mon, Mar 19, 2012 at 2:11 PM, Avi Marcus <avi@avimarcus.net> wrote:
I didn't have that issue.. I actually changed the channels, calls, sip_subscriptions and anything else transitory to memory tables to they wouldn't write to disk. I kept regs as myisam so it would persist.
-Avi
On Mon, Mar 19, 2012 at 11:12 PM, GCHEN00 <gchen00@insightbb.com> wrote:
When I use ODBC as core database, freeswitch auto create the database tables using engine=MyISAM. I have to change the table type to innodb for 'complete' table to avoid the Maximum index length ERROR. My question is should I change rest of the tables to innodb or just leave them as MyISAM.
Which one is better suited for freeswitch?
Gary
_________________________________________________________________________ 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
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
_________________________________________________________________________ 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
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
participants (3)
-
Avi Marcus
-
curriegrad2004
-
GCHEN00