A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Mongo DB Applied Patterns
this week in the
or a resume review from
Five Year Itch
Lock table in database when doing write operation.
Joined: Jun 01, 2006
May 08, 2007 09:01:00
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.
I agree. Here's the link:
- if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
subject: Lock table in database when doing write operation.
question on Lock
Monkhouse DVD example: 2 levels of locking
Table-level locking, how?
a simple question of Locking mechanism
Locking Suggestions and Help
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013