MySQL: "Our implementation of this feature technically satisfies the standard, but does so in a way that makes the feature completely useless"
-
-
-
Replying to @lostapathy
serializable transaction isolation levels. Just changes all your selects to `SELECT FOR SHARE` which causes a deadlock
1 reply 0 retweets 2 likes -
Replying to @sgrif @lostapathy
haven't use mysql 8 yet, does `select for share skip lock` did the trick ?
1 reply 0 retweets 0 likes
Replying to @kocoten1992 @lostapathy
`SKIP LOCKED` is extremely useful for certain use cases, but has nothing to do with matching the semantics of a serializable transaction
3:18 PM - 10 Sep 2018
0 replies
0 retweets
3 likes
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.