Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!