How do I tell which mysql process has a lock?

Greetings. How do I tell which mysql process has a lock on what tables? I'm using mysql 3.23.54-Max with MyISAM tables on Linux 2.4.9-34 (RedHat 7.2). We've got about 20 users and a myriad of automated scripts (Perl DBI, Java JDBC) connecting to the database on a regular basis. Thanks. -- M

Which process holds the locks?

Greetings. I'm using mysql 3.23.54-Max with MyISAM tables on Linux 2.4.9-34 (RedHat 7.2). We've got about 20 users and a myriad of automated scripts (Perl DBI, Java JDBC) connecting to the database on a regular basis. Twice now, we've had problems with too many connections (max connections is cu