mysql simultaneous query for insertion

Question

When several users try to insert into the same table at the same time, mysql locks the table while implementing the first query.

Question is:

mysql declines other requests or puts them in queue and after the table is unlocked will implement other requests as well?

Ryank · Accepted Answer · 2016-12-24 12:00:16Z

1

MySQL will handle the requests one at a time so in a sense will queue them until the lock has been released on the table to allow the next session to perform its request.

answered Dec 24, 2016 at 12:00

Ryank

5072 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql simultaneous query for insertion

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related