Register / Login
Win a copy of
Re-engineering Legacy Software
this week in the
Docker in Action
JDBC and Relational Databases
Lock table in database when doing write operation.
posted 8 years ago
Based on my understanding, when we do write operation to a table in database (MYSQL) we lock the table from bein accessed by another processess. But not when we do read operation.
Is this true?
If yes, then is there a way I can turn of some settings so the write operation will not lock the table?
Is there any disadvantages in doing this?
Thanks in advance for the help.
Monkhouse DVD example: 2 levels of locking
Table-level locking, how?
Locking Suggestions and Help
a simple question of Locking mechanism
question on Lock