From: Johan De Meersman
Date: July 12 2011 3:01pm
Subject: Re: Low priority write
List-Archive: http://lists.mysql.com/mysql/225360
Message-Id: <0385fa50-dd65-42fc-bb18-3bda46a19a7e@zimbra>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Client C - LOW PRIORITY inserts will always wait until absolutely no other processes are using a table.

----- Original Message -----
> From: "Jon Siebert" <jon.siebert1@stripped>
> To: mysql@stripped
> Sent: Saturday, 9 July, 2011 5:54:58 PM
> Subject: Low priority write
> 
> Low Priority Lock
> 
> Hello was wondering if anybody would have some input:
> 
> This will be on the same table.
> 
> Client (A) acquires a READ lock;
> immediately thereafter a large amount of clients wait for a read lock
> as
> well, and client(B) requests a LOW PRIORITY insert.
> 
> Another surge of clients request read locks as client(C) requests a
> INSERT
> lock.
> 
> The last of the read locks are finished selecting.
> 
> Does client (B) or (C) acquire their lock first?
> 
> Will it go by priority or in order which the requests were received.
> 
> I could not find documentation in forums or MySQL reference regarding
> this.
> 
> Thanks!
> 

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel