summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/r/monitor.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.com>2018-07-25 08:25:57 +0400
committerAlexander Barkov <bar@mariadb.com>2018-07-25 08:25:57 +0400
commit9c0f5a252b0c0d84d414524adfbdb9e5b82449d4 (patch)
treeaab496e2264fb6322ca3a39ff83f2fef610a90e0 /mysql-test/suite/innodb/r/monitor.result
parentd6594847cff55bb6d7d094a0311f1fe3d5be789e (diff)
parent294a426088bd7167f42388e7e76ff8d42df7d6be (diff)
downloadmariadb-git-9c0f5a252b0c0d84d414524adfbdb9e5b82449d4.tar.gz
Merge remote-tracking branch 'origin/10.3' into 10.4
Diffstat (limited to 'mysql-test/suite/innodb/r/monitor.result')
-rw-r--r--mysql-test/suite/innodb/r/monitor.result16
1 files changed, 15 insertions, 1 deletions
diff --git a/mysql-test/suite/innodb/r/monitor.result b/mysql-test/suite/innodb/r/monitor.result
index f5c1070ff94..4168a94928f 100644
--- a/mysql-test/suite/innodb/r/monitor.result
+++ b/mysql-test/suite/innodb/r/monitor.result
@@ -661,7 +661,21 @@ SELECT NAME, COUNT > 0 FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME
LIKE 'buffer_page_written_index_leaf';
NAME COUNT > 0
buffer_page_written_index_leaf 1
+DROP TABLE t1;
+CREATE TABLE t1(id INT PRIMARY KEY, a INT, b CHAR(1), UNIQUE KEY u(a,b))
+ENGINE=InnoDB;
+SET @start = (SELECT COUNT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME
+= 'lock_rec_lock_created');
+BEGIN;
+INSERT INTO t1 VALUES(1,1,'a'),(2,9999,'b'),(3,10000,'c'),(4,4,'d');
+DELETE FROM t1 WHERE a = 9999 AND b='b';
+COMMIT;
+SET @end = (SELECT COUNT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME
+= 'lock_rec_lock_created');
+SELECT @end - @start;
+@end - @start
+0
+DROP TABLE t1;
SET GLOBAL innodb_monitor_enable=default;
SET GLOBAL innodb_monitor_disable=default;
SET GLOBAL innodb_monitor_reset_all=default;
-DROP TABLE t1;