Re: Potential G2-item cycles under serializable isolation - Mailing list pgsql-bugs

From Kyle Kingsbury
Subject Re: Potential G2-item cycles under serializable isolation
Date
Msg-id 1fbd7c3d-f3e3-a14f-d391-d7c4b490e977@jepsen.io
Whole thread Raw
In response to Re: Potential G2-item cycles under serializable isolation  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: Potential G2-item cycles under serializable isolation
List pgsql-bugs
On 6/14/20 9:30 PM, Thomas Munro wrote:
> By my reading of their manual, MySQL (assuming InnoDB) uses SI for
> REPEATABLE READ just like us, and it's also their default level.
>
> https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html

That can't be right. MySQL repeatable read allows lost update, write skew, and 
at least some kinds of read skew: it's got to be weaker than SI and also weaker 
than RR. I think it's actually Monotonic Atomic View plus some read-only 
constraints?

https://github.com/ept/hermitage

<sigh> I really gotta do a report on MySQL too...

--Kyle




pgsql-bugs by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Potential G2-item cycles under serializable isolation
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #16492: DROP VIEW IF EXISTS error