Khalid Baheyeldin wrote:
What do people think about using InnoDB as the default,
Big -1 from me.
We used to have Engine=MyISAM everywhere in the CREATE statements. We went thru an exercise to purge them all so that we are engine agnostic.
Yeah, but we didn't have a schema API then. Now, becaue we generate the CREATE statements, we can do whatever we want. :-)
An option at install time, such as a drop down list of engines that are supported on the server, and selecting one is more appropriate. It will require preg stuff to change the engine. Or using the new schema, we can add that more elegantly (not sure how hard would it be, but can't be that hard).
It would be quite elegant because we generate all the CREATE statements from scratch with schema API. No preg_replace required.