Re: Trans.: Re: Read locks with InnoDB?

2004-11-10 Thread Julien ALLANOS
Selon Harald Fuchs <[EMAIL PROTECTED]>: > In article <[EMAIL PROTECTED]>, > Julien ALLANOS <[EMAIL PROTECTED]> writes: > > > Well, I've tried the following scenario: > > > 1/ User A: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED; > > 2/ User B: SET GLOBAL TRANSACTION ISOLATION LEVEL READ C

Re: Trans.: Re: Read locks with InnoDB?

2004-11-10 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Julien ALLANOS <[EMAIL PROTECTED]> writes: > Well, I've tried the following scenario: > 1/ User A: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED; > 2/ User B: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED; > 3/ User A: START TRANSACTION; > 4/ User B

Re: Trans.: Re: Read locks with InnoDB?

2004-11-10 Thread Julien ALLANOS
Selon Harald Fuchs <[EMAIL PROTECTED]>: > In article <[EMAIL PROTECTED]>, > Julien ALLANOS <[EMAIL PROTECTED]> writes: > > > Thanks, I've already read these pages. > > > Here is a test example I've done: > > > 1/ User A: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED; > > 2/ User B: SET GLO

Re: Trans.: Re: Read locks with InnoDB?

2004-11-10 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Julien ALLANOS <[EMAIL PROTECTED]> writes: > Thanks, I've already read these pages. > Here is a test example I've done: > 1/ User A: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED; > 2/ User B: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED; > 3/ Use