Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Lock table in database when doing write operation.

 
Rudy Rusli
Ranch Hand
Posts: 114
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic