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. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs