Re: #18557: get_or_create() causes a race condition with MySQL

2012-09-05 Thread Anssi Kääriäinen
On 5 syys, 10:09, lucky wrote: >                Session A                            Session B           > CREATE TABLE t (k INT, v INT, PRIMARY KEY (k)); > >            SET autocommit=0;                    SET autocommit=0; > time > |          SELECT * FROM t; > |        

Re: #18557: get_or_create() causes a race condition with MySQL

2012-09-05 Thread lucky
среда, 5 сентября 2012 г., 5:32:44 UTC+6 пользователь Anssi Kääriäinen написал: > > > > On 4 syys, 17:53, lucky wrote: > > *E) Use locking with SELECT query* > > According tohttp:// > dev.mysql.com/doc/refman/5.5/en/innodb-consistent-read.html > > > > If you want to