Date: 2008-10-13 20:23 Subject: Would you prefer InnoDB to be the default storage engine? Security: Public

I've created a new community poll: Would you prefer InnoDB to be the default storage engine?, as I'm just curious how the community currently feels about this.

Of course, anyone can put --default-storage-engine=InnoDB (and --sql_mode=NO_ENGINE_SUBSTITUTION) in their my.cnf to accomplish the same, but... as a friend of mine has been asking me for years, it would make MySQL "ACID compliant out of the box" (e.g., by default) with no silent ignoring of transactions or foreign key constraints.

You can always specify the desired engine explicitly with CREATE TABLE ... ENGINE=...

One could say that it's about usability and ease-of-use for new users who don't yet know much about MySQL or its configuration. Did you know that the config wizard on Windows actually already sets the default storage engine to InnoDB if you select that you might be using transactions? It's not explicitly noted that that's the consequence, but it is what happens.


So, please put in your vote, and possibly a comment here explaining your opinion? Great!