diff options
author | Alexander Barkov <bar@mariadb.com> | 2018-07-25 08:25:57 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2018-07-25 08:25:57 +0400 |
commit | 9c0f5a252b0c0d84d414524adfbdb9e5b82449d4 (patch) | |
tree | aab496e2264fb6322ca3a39ff83f2fef610a90e0 /mysql-test/suite/innodb/r/monitor.result | |
parent | d6594847cff55bb6d7d094a0311f1fe3d5be789e (diff) | |
parent | 294a426088bd7167f42388e7e76ff8d42df7d6be (diff) | |
download | mariadb-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.result | 16 |
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; |