Re: Read level locking problem for mysql

[lata rishi]

Following procedure is used for every user:

Suppose there are 100 records with the condition

For first user it should select 10 records from that lot:

Begin;
Select * from tablename where field1 > 100 limit 10 for update;
update tablename set field2_status=1;
commit;

For second user it should select next ten records:

Begin;
Select * from tablename where field1 > 100 limit 10 for update;
update tablename set field2_status=1;
commit;



But the problem is once the records are locked by 1st user, second user waits....