I too have wondered this... it looks like the manual just says (in your
case) user 'b' will wait indefinitely for the lock held by user 'a' to be
released. Maybe you could just have user 'a' hold a READ or READ LOCAL lock
and not a WRITE lock, therefore user 'b' will still be able to do SELECTS
ok... ??
Patrick
# -----Original Message-----
# From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
# Sent: Friday, May 04, 2001 3:39 AM
# To: [EMAIL PROTECTED]
# Subject: RTFM - Show locks
# Importance: High
#
#
# database, sql
#
# Hi there
#
# I have tried looking in the manual but can't see the solution to this.
#
# user a issues a lock on table1, userb then tries to do a select and
# obviously the select will wait until the lock is released.
#
# So my questions are :-
#
# 1. How do you change the 'timeout' period that userb will wait for?
#
# 2. When the timeout is reached, I want to give the user a
# message box that
# shows them who is currently locking the table. How do I see
# who is locking
# table1?
#
# Regards
# Warren
#
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
# Warren van der Merwe
# Software Director
# PRT Trading (Pty) Ltd t/a RedTie
# Durban, South Africa
# Cell (+27-83) 262-9163
# Office (+27-31) 767-0249
#
#
#
# ---------------------------------------------------------------------
# Before posting, please check:
# http://www.mysql.com/manual.php (the manual)
# http://lists.mysql.com/ (the list archive)
#
# To request this thread, e-mail <[EMAIL PROTECTED]>
# To unsubscribe, e-mail
# <[EMAIL PROTECTED]>
# Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
#
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
