SET lock_wait_timeout = 1; CREATE TABLE t1 (a ) ENGINE= ; LOCK TABLES t1 WRITE CONCURRENT, t1 AS t2 READ; SET lock_wait_timeout = 1; LOCK TABLES t1 READ LOCAL; UNLOCK TABLES; UNLOCK TABLES; LOCK TABLES t1 READ LOCAL; LOCK TABLES t1 WRITE CONCURRENT, t1 AS t2 READ; UNLOCK TABLES; UNLOCK TABLES; DROP TABLE t1;