On Thursday 16. August 2007, David Fetter wrote:
>On Thu, Aug 16, 2007 at 11:47:12AM -0400, Robert Treat wrote:
>> The windows default table type for mysql is innodb, which is ACID.
>> Since > 50% of thier users work on windows (perhaps not deploy, but
>> do development/testing) this means that most of them are getting
>> ACID out of the box as well.
>
>Until they move to production on Linux, *BSD or Solaris, at which
>point all the stuff that worked on the development boxes starts
>breaking--silently, as characterizes MySQL--on prod boxes.
>
>This qualifies, not as a "feature," but as a really severe gotcha.
Right. Most web hotels that offer MySQL only support MyISAM tables.
Guess what happens if you try to create a table of type InnoDB in a
database that only has MyISAM installed?, Yeah, it silently creates
an 'ACID-free' MyISAM table.
http://sql-info.de/en/mysql/database-definition.html#2_4
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/