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 currently set at 100, we may raise this, but that's another matter). The last time this happened, most processes were showing a state (through processlist) of "Locked", such as this: | Id | User | Host | db | Command | Time | State | Info | 867791 | textcafe | jed.texterity.com | textman | Query | 165 | Locked | SELECT tickets.ticket_id FROM tickets LEFT JOIN projects ON tickets.project_id = projects.project_id | My assumption (which may be flawed) is that there is a proccess which has LOCKed TABLEs, but is not UNLOCKing them. I would love to track this down. So, my question is (I think) a simple one, yet I have found no answer in my searches on-line: How do I tell which process has a lock on what tables? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
