Marco, It is also possible to set table locks by hand using a lock table query. These connections will simply show up as sleeping or doing something else. There currently isn't a show locks command in MySQL. Depending on what the process list looks like tracking it down could be as simple as looking for the sleeping connection that has been asleep for about as long as the longest locked select. If it's locking tables then doing something else it may be more difficult.
On 7/29/06, Marco Simon <[EMAIL PROTECTED]> wrote:
Hello list, I've a question about understanding table-locks of myisam-tables: >From time to time it happens that my proccesslist gets flooded by Queries, that are waiting for a locked table. Quickly there are 100-500 waiting Queries in the queue - some of them waiting since more than 1000 seconds. My question is: How can I see who (which query) set the lock, which all other queries are waiting for to be released ? I thought there should be at least one "update" Query in the processlist, which set the lock and which is still working. But there are only locked queries for the locked table - no updates, no deletes. Could somebody try to explain, how I can investigate, who's blocking the line ?
-- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]