Debian Codegraph @

mysql-test/suite/innodb/r/innodb-status-output.result

raw
1 CREATE TABLE innodb_monitor(a SERIAL) ENGINE=InnoDB;
2 SHOW VARIABLES LIKE 'innodb_status_output%';
3 Variable_name Value
4 innodb_status_output OFF
5 innodb_status_output_locks OFF
6 DROP TABLE innodb_monitor;
7 SHOW VARIABLES LIKE 'innodb_status_output%';
8 Variable_name Value
9 innodb_status_output OFF
10 innodb_status_output_locks OFF
11 CREATE TABLE innodb_lock_monitor(a SERIAL) ENGINE=InnoDB;
12 SHOW VARIABLES LIKE 'innodb_status_output%';
13 Variable_name Value
14 innodb_status_output OFF
15 innodb_status_output_locks OFF
16 DROP TABLE innodb_lock_monitor;
17 SHOW VARIABLES LIKE 'innodb_status_output%';
18 Variable_name Value
19 innodb_status_output OFF
20 innodb_status_output_locks OFF
21 CREATE TABLE innodb_tablespace_monitor(a SERIAL) ENGINE=InnoDB;
22 DROP TABLE innodb_tablespace_monitor;
23 CREATE TABLE innodb_table_monitor(a SERIAL) ENGINE=InnoDB;
24 DROP TABLE innodb_table_monitor;
25 CREATE TABLE t(a SERIAL) ENGINE=InnoDB;
26 INSERT INTO t VALUES(42);
27 BEGIN;
28 SELECT * FROM t FOR UPDATE;
29 a
30 42
31 SET GLOBAL innodb_status_output_locks=ON;
32 SET GLOBAL innodb_status_output=ON;
33 SELECT SLEEP(30);
34 SLEEP(30)
35 0
36 COMMIT;
37 Pattern "INNODB MONITOR OUTPUT" found
38 BEGIN;
39 SELECT * FROM t FOR UPDATE;
40 a
41 42
42 SET GLOBAL innodb_status_output_locks=ON;
43 SELECT SLEEP(30);
44 SLEEP(30)
45 0
46 COMMIT;
47 Pattern "ready for connections. Version:" found
48 BEGIN;
49 SELECT * FROM t FOR UPDATE;
50 a
51 42
52 SET GLOBAL innodb_status_output=ON;
53 SELECT SLEEP(30);
54 SLEEP(30)
55 0
56 COMMIT;
57 # restart
58 Pattern "INNODB MONITOR OUTPUT" found
59 DROP TABLE t;