InnoDB should be the default table type
Bug #633364 reported by
Clint Byrum
This bug affects 3 people
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| mysql-5.5 (Ubuntu) |
Fix Released
|
Wishlist
|
Unassigned | ||
Bug Description
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)
Related branches
Revision history for this message
| RoyK (roysk) wrote | #1 |
Revision history for this message
| Clint Byrum (clint-fewbar) wrote | #2 |
Revision history for this message
| Clint Byrum (clint-fewbar) wrote | #3 |
| tags: | added: wishlist |
Revision history for this message
| Chuck Short (zulcss) wrote | #4 |
| Changed in mysql-5.1 (Ubuntu): | |
| importance: | Undecided → Wishlist |
| status: | New → Opinion |
Revision history for this message
| Clint Byrum (clint-fewbar) wrote | #5 |
| affects: | mysql-5.1 (Ubuntu) → mysql-5.5 (Ubuntu) |
| Changed in mysql-5.5 (Ubuntu): | |
| status: | Opinion → Fix Released |
To post a comment you must log in.
if, or when, this is to happen, the default mysqld installation should be tuned for innodb, not myisam, as it is today. I would guess this should go into a future release