diff options
Diffstat (limited to 'mysql-test/r/status.result')
| -rw-r--r-- | mysql-test/r/status.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/status.result b/mysql-test/r/status.result index 8f3ad3e0d59..3ef6cec32b3 100644 --- a/mysql-test/r/status.result +++ b/mysql-test/r/status.result @@ -1,6 +1,19 @@ +flush status; +show status like 'Table_lock%'; Variable_name Value Table_locks_immediate 0 Table_locks_waited 0 +SET SQL_LOG_BIN=0; +drop table if exists t1; +create table t1(n int) type=myisam; +insert into t1 values(1); +lock tables t1 read; +unlock tables; +lock tables t1 read; +update t1 set n = 3; +unlock tables; +show status like 'Table_lock%'; Variable_name Value Table_locks_immediate 3 Table_locks_waited 1 +drop table t1; |