I have a code that will create multiple connections for the database ) (All threads reach the same table) Each thread updates sets of different rows in the same table. In such a situation, to ensure there is no problem updating the table, mutex is required? What is the standard?
I think the task of maintaining the integrity of the data is more "MySQL side".
Overlapping data access can be controlled by table locking requests and rollback logic / transactions, but if you are working on different lines, then data should not be affected in corruption, in case Update thread table together Database server should handle properly.
No comments:
Post a Comment