MySQL patches by Codership

  1. Bug #861212
  2. Comment #0

Comment 0 for bug 861212

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote : unresolved MDL conflict with limited innodb thread concurrency

Hanging happens in 1.0beta evaluation with following use case:

* innodb_thread_concurrency=32
* ~50 client connections running short autocommit queries (UPDATE,DELETE,INSERT)
* one UPDATE with INNER JOIN, updating 'queue' table
* one DDL running: CREATE TABLE IF NOT EXISTS queue(...)

The DDL stays hanging in state: "Waiting for table metadata lock", killing this query resolves the deadlock.