You may want to look into a MySQL paradigm called Advisory Locking. You could read MYSQL 5.0 Certification Study Guide, Chapter 28 pages 403,404 or got these URLs for more on GET_LCOK and RELEASE_LOCK functions
http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html ----- Original Message ----- From: Ow Mun Heng <[EMAIL PROTECTED]> To: Submit MySQL <mysql@lists.mysql.com> Sent: Wednesday, November 1, 2006 11:21:25 PM GMT-0500 US/Eastern Subject: How to view locks in MySQL Under MSSQL there's a stored procedure called sp_lock which can be used. Is there an equivalent one in mySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]