CODEWITHSUNDEEP
phpmysqlconcurrency
osullic
osullic

Reputation: 612

Does (or, how does) MySQL natively take care of concurrent transactions?

Maybe this is an obvious question, but it's just something I'm unsure of. If I have two standalone PHP applications running on one LAMP server, and the two PHP applications share the same MySQL database, do I need to worry about data integrity during concurrent database transactions, or is this something that MySQL just takes care of "natively"?

What happens if the two PHP applications both try to update the same record at the same time? What happens if they try to update the same table at the same time? What happens if they both try to read data from the database at the same time? Or if one application tries to read a record at the same time as the other application is updating that record?

Upvotes: 0

Views: 63

Answers (1)

ScaisEdge
ScaisEdge

Reputation: 133400

What happens if the two PHP applications both try to update the same  record at the same time? 

What happens if they try to update the same table at the same time? 

What happens if they both try to read data from the database at the same time? 
Or if one application tries to read a record at the same time as the other application is updating that record?

This depend from several factor ..

the db engine you are using

the locking policy / transaction you have setted for you envirement .. or for you query https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html

the code you are using .. you could use a select for update for lock only the rows you want modify https://dev.mysql.com/doc/refman/8.0/en/update.html

and how you manage transaction
https://dev.mysql.com/doc/refman/8.0/en/commit.html

this is just a brief suggestion

Upvotes: 1

Related Questions