List:General Discussion« Previous MessageNext Message »
From:Jon Siebert Date:July 9 2011 3:54pm
Subject:Low priority write
View as plain text  
  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!

Thread
Low priority writeJon Siebert9 Jul
  • Re: Low priority writeJohan De Meersman12 Jul