Hi, I'm writing an application that uses InnoDB tables to provide transactional integrity. The front-end is a web-based interface.
I'd like to know - is there a way one can issue a query to test whether a particular set of rows (or row) has already been locked by another session - rather than the default action of waiting for quite long for the lock to be granted. The idea is so that a person using the front-end may know whether the information they are attempting to access is "unavailable" at the time. There will be situations where rows will be locked exclusively for prolonged times and I wouldn't want the web application users to be subjected to these lengthy delays but rather be told to try later. Regards, Gerald. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
