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
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.