Hi,
All locking in *MySQL* is deadlock-free. This is managed by always
requesting all needed locks at once at the beginning of a query and always
locking the tables in the same order.
The --external-locking and --skip-external-locking options explicitly enable
and disable external locking.
The LOCK TABLES and UNLOCK TABLES statements use internal locking, so you
can use them even if external locking is disabled.
A call to LOCK TABLES tries to lock any tables you list so that the current
thread can work with it without interference. A call to UNLOCK TABLES
releases any locks that this thread holds.There are two main types of locks:
read and write.
When a lock is released, the lock is made available to the threads in the
write lock queue, then to the threads in the read lock queue.
External locking is a part of configuration and Internal locking is a part
of query.
Thanks
ViSolve DB Team
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, September 25, 2006 11:42 AM
Subject: Transactions in MySQL.
Hi All,
How transactions and locking are handled in MYSQL?
Is it a part of configuration? Or a query (lock tables, Unlock tables)
for each set of queries?
Regards,
Ravi K
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.
www.wipro.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
