MySQL Forums
Forum List  »  Stored Procedures

Stored Procedure Concurrent Updates
Posted by: Soumya Nayak
Date: May 22, 2018 12:27AM

Hi,

I have a stored procedure written in MySQL which reads and updates a status in a table.

The Problem is when more than one user is calling the stored procedure that is from multiple machines(say 5 machines) concurrently, all the machines are reading the same status at a time. So here i want to restrict each machine reading once rather than all the machines reading at sametime. So does stored procedure puts a lock on the concurrent reads, if not how to achieve that.
Please help.

regards,
Ranjan

Options: ReplyQuote


Subject
Views
Written By
Posted
Stored Procedure Concurrent Updates
1400
May 22, 2018 12:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.