[Bug 633364] [NEW] InnoDB should be the default table type

[Clint Byrum]

Public bug reported:

Currently the default table type in mysql is MyISAM.

Since the MyISAM storage engine is prone to data loss on crashing, this
is an unsafe default for MySQL users.

While InnoDB is less performant on writes (nearly identical on reads for
most workloads), it does offer better data security on crashes and in
general.

This would likely have wide reaching affects on packages that create
tables without specifying a table type, but most of them would be
positive. Some of the side effects to watch out for:

* InnoDB does not support FULLTEXT type indexes
* InnoDB tables ignore "INSERT DELAYED" (they just insert immediately)

** Affects: mysql-5.1 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
InnoDB should be the default table type
https://bugs.launchpad.net/bugs/633364
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in ubuntu.