derp. OP has a small statement on the differences: > Unlike SERIALIZABLE isolation, it works even in autocommit mode or if the statements are in separate trans

derp. OP has a small statement on the differences: > Unlike SERIALIZABLE isolation, it works even in autocommit mode or if the statements are in separate transactions. For this reason it’s often a good choice for web applications that might have very long user “think time” pauses or where clients might just vanish mid-session, as it doesn’t need long-running transactions that can cause performance problems.