Debian Codegraph @

mysql-test/suite/innodb/r/innodb_row_lock_time_ms.result

raw
1 CREATE TABLE `t`(`id` INT, PRIMARY KEY(`id`)) ENGINE=InnoDB STATS_PERSISTENT=0;
2 INSERT INTO t VALUES (1);
3 SET GLOBAL innodb_monitor_disable="lock_row_lock_time";
4 SET GLOBAL innodb_monitor_disable="lock_row_lock_time_max";
5 SET GLOBAL innodb_monitor_reset_all='lock_row_lock_time';
6 SET GLOBAL innodb_monitor_reset_all='lock_row_lock_time_max';
7 SET GLOBAL innodb_monitor_enable="lock_row_lock_time";
8 SET GLOBAL innodb_monitor_enable="lock_row_lock_time_max";
9 BEGIN;
10 SELECT * FROM t FOR UPDATE;
11 id
12 1
13 SELECT @innodb_row_lock_time_before := variable_value
14 FROM information_schema.global_status
15 WHERE LOWER(variable_name) = 'innodb_row_lock_time';
16 connect con1,localhost,root,,;
17 SET innodb_lock_wait_timeout = 1;
18 SELECT * FROM t FOR UPDATE;
19 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
20 disconnect con1;
21 connection default;
22 COMMIT;
23 SELECT variable_value - @innodb_row_lock_time_before > 100
24 FROM information_schema.global_status
25 WHERE LOWER(variable_name) = 'innodb_row_lock_time';
26 variable_value - @innodb_row_lock_time_before > 100
27 1
28 SELECT variable_value > 100
29 FROM information_schema.global_status
30 WHERE LOWER(variable_name) = 'innodb_row_lock_time_max';
31 variable_value > 100
32 1
33 SELECT count_reset > 100
34 FROM INFORMATION_SCHEMA.INNODB_METRICS
35 WHERE NAME='lock_row_lock_time';
36 count_reset > 100
37 1
38 SELECT count_reset > 100
39 FROM INFORMATION_SCHEMA.INNODB_METRICS
40 WHERE NAME='lock_row_lock_time_max';
41 count_reset > 100
42 1
43 DROP TABLE t;
44 SET GLOBAL innodb_monitor_enable=default;
45 SET GLOBAL innodb_monitor_disable=default;
46 SET GLOBAL innodb_monitor_reset_all=default;