From eb5706d128539f1aa98690793e9344df280f98c8 Mon Sep 17 00:00:00 2001
From: unknown <sasha@mysql.sashanet.com>
Date: Fri, 26 Jan 2001 20:00:42 -0700
Subject: Table_locks_waited Table_locks_immediate

mysys/thr_lock.c:
  count locks
sql/mysqld.cc:
  count locks
sql/sql_base.cc:
  count locks
---
 mysql-test/t/status.test | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)
 create mode 100644 mysql-test/t/status.test

(limited to 'mysql-test/t/status.test')

diff --git a/mysql-test/t/status.test b/mysql-test/t/status.test
new file mode 100644
index 00000000000..2f65f87f29f
--- /dev/null
+++ b/mysql-test/t/status.test
@@ -0,0 +1,23 @@
+connect (con1,localhost,root,,test,0,mysql-master.sock);
+connect (con2,localhost,root,,test,0,mysql-master.sock);
+
+#don't polute binlog
+show status like 'Table_lock%';
+connection con1;
+SET SQL_LOG_BIN=0;
+drop table if exists t1;
+create table t1(n int);
+insert into t1 values(1);
+connection con2;
+lock tables t1 read;
+unlock tables;
+lock tables t1 read;
+connection con1;
+send update t1 set n = 3;
+connection con2;
+sleep 0.5;
+unlock tables;
+connection con1;
+reap;
+show status like 'Table_lock%';
+
-- 
cgit v1.2.1