<br><div class="gmail_quote">On Nov 13, 2007 12:13 PM, Iņaki Baz Castillo <<a href="mailto:ibc@in.ilimit.es">ibc@in.ilimit.es</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi, MySQL tables of OpenSer created by the script are "MyISAM". Is there any<br>reason for that instead of using InnoDB?<br><br>As I know:<br><br>MyISAM:<br>- Is faster reading and writting (except writting various entries to same
<br>table since it blocks the entire table).<br>- No transactions or rollbacks.<br>- Small disc space requeriments.<br><br>InnoDB:<br>- Transactions, rollbacks, restrictions in foreing keys.<br>- Faster writting various entries in same table (entry lock instead of table
<br>lock).<br>- More disc space and RAM requeriments.<br><br><br>Yes, it can be obvious that for OpenSer the engine MyISAM can be a good choice<br>but I would like to know if there is more data for this choice.<br><br>Regards.
<br><font color="#888888"><br><br>--<br>Iņaki Baz Castillo<br><a href="mailto:ibc@in.ilimit.es">ibc@in.ilimit.es</a><br><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.openser.org">
Users@lists.openser.org</a><br><a href="http://lists.openser.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser.org/cgi-bin/mailman/listinfo/users</a><br></font></blockquote></div><br>Depending on how much data you have, you should also look at mysql Cluster. Since it is an in memory database, it will be super fast.
<br><br>I have used SER with Mysql Cluster and it works well. <br><br>Joe<br>