Hi! Is there a way or command for mysql that shows me a) what tables are currently locked b) with what kind of lock c) which query caused the lock d) and maybe how long the lock exists? I usually try to figure out via mysqladmin processlist and look for the one query that isnīt locked as the cause, but sometimes it just seems like everything is locked. henning --------------------------------------------------------------------- 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
