I'd like to be able to look at show innodb status, notice that a query is waiting on a lock to be released, and then determine which tx is holding that lock.
I know you can use the innodb_lock_monitor table, but this would make things a lot faster especially when there are a lot of active transactions. -- Joe Shear <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]