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

Clint Byrum clint at fewbar.com
Wed Sep 8 18:03:33 BST 2010

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

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
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in ubuntu.

More information about the Ubuntu-server-bugs mailing list