60 lines
1.4 KiB
Plaintext
60 lines
1.4 KiB
Plaintext
CREATE TABLE innodb_monitor(a SERIAL) ENGINE=InnoDB;
|
|
SHOW VARIABLES LIKE 'innodb_status_output%';
|
|
Variable_name Value
|
|
innodb_status_output OFF
|
|
innodb_status_output_locks OFF
|
|
DROP TABLE innodb_monitor;
|
|
SHOW VARIABLES LIKE 'innodb_status_output%';
|
|
Variable_name Value
|
|
innodb_status_output OFF
|
|
innodb_status_output_locks OFF
|
|
CREATE TABLE innodb_lock_monitor(a SERIAL) ENGINE=InnoDB;
|
|
SHOW VARIABLES LIKE 'innodb_status_output%';
|
|
Variable_name Value
|
|
innodb_status_output OFF
|
|
innodb_status_output_locks OFF
|
|
DROP TABLE innodb_lock_monitor;
|
|
SHOW VARIABLES LIKE 'innodb_status_output%';
|
|
Variable_name Value
|
|
innodb_status_output OFF
|
|
innodb_status_output_locks OFF
|
|
CREATE TABLE innodb_tablespace_monitor(a SERIAL) ENGINE=InnoDB;
|
|
DROP TABLE innodb_tablespace_monitor;
|
|
CREATE TABLE innodb_table_monitor(a SERIAL) ENGINE=InnoDB;
|
|
DROP TABLE innodb_table_monitor;
|
|
CREATE TABLE t(a SERIAL) ENGINE=InnoDB;
|
|
INSERT INTO t VALUES(42);
|
|
BEGIN;
|
|
SELECT * FROM t FOR UPDATE;
|
|
a
|
|
42
|
|
SET GLOBAL innodb_status_output_locks=ON;
|
|
SET GLOBAL innodb_status_output=ON;
|
|
SELECT SLEEP(30);
|
|
SLEEP(30)
|
|
0
|
|
COMMIT;
|
|
Pattern "INNODB MONITOR OUTPUT" found
|
|
BEGIN;
|
|
SELECT * FROM t FOR UPDATE;
|
|
a
|
|
42
|
|
SET GLOBAL innodb_status_output_locks=ON;
|
|
SELECT SLEEP(30);
|
|
SLEEP(30)
|
|
0
|
|
COMMIT;
|
|
Pattern "ready for connections. Version:" found
|
|
BEGIN;
|
|
SELECT * FROM t FOR UPDATE;
|
|
a
|
|
42
|
|
SET GLOBAL innodb_status_output=ON;
|
|
SELECT SLEEP(30);
|
|
SLEEP(30)
|
|
0
|
|
COMMIT;
|
|
# restart
|
|
Pattern "INNODB MONITOR OUTPUT" found
|
|
DROP TABLE t;
|