On 6/3/07, <b class="gmail_sendername">David Strauss</b> <<a href="mailto:david@fourkitchens.com">david@fourkitchens.com</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Many discount web hosts (like Dreamhost) support InnoDB but don't<br>configure it as a default. </blockquote><div><br>Most shared hosts support it recently. </div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
What do people think about using InnoDB as the default, </blockquote><div><br>Big -1 from me. </div><br>We used to have Engine=MyISAM everywhere in the CREATE statements.<br>
We went thru an exercise to purge them all so that we are engine agnostic.<br>
<br>
Defaulting back to a specific engine is a step back.<br>
<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">or at least an option during installation?</blockquote><div><br>That I can live with. <br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">The only way I know to install Drupal with InnoDB is by modifying<br>my.cnf, which requires root access.
<br></blockquote></div><br>An option at install time, such as a drop down list of engines that<br>are supported on the server, and selecting one is more appropriate.<br>It will require preg stuff to change the engine. Or using the new
<br>schema, we can add that more elegantly (not sure how hard would<br>it be, but can't be that hard).<br>-- <br><a href="http://2bits.com">2bits.com</a><br><a href="http://2bits.com">http://2bits.com</a><br>Drupal development, customization and consulting.