I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables.
Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My question is due that, as you know, the InnoDB tables makes loking at row level and in the context of a transaction, so if someone has locked the row that I'm tring to read or lock, my program freezes until the rows are released. I worked arround this situation setting the value of innodb_lock_wait_timeout to 5, more or less, so my program doesn't freezes and a warnig is raised, then I can "assume" that the row is locked, but can't be sure that this is the real reason of the warnig. Thanks in advance, Patricio. --------------------------------------------------------------------- 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