From: | "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org> |
---|---|
To: | pgsql-advocacy(at)postgresql(dot)org |
Subject: | Re: 12 Silver Bullets |
Date: | 2007-08-16 17:30:03 |
Message-ID: | 200708161930.03793.leif@solumslekt.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Mayer | 2007-08-16 18:31:01 | Re: default_text_search_config and expression indexes |
Previous Message | vincent | 2007-08-16 16:59:54 | Re: 12 Silver Bullets |