Debian Codegraph @

mysql-test/suite/sysschema/r/v_schema_table_lock_waits.result

raw
1 DESC sys.schema_table_lock_waits;
2 Field Type Null Key Default Extra
3 object_schema varchar(64) YES NULL
4 object_name varchar(64) YES NULL
5 waiting_thread_id bigint(20) unsigned NO NULL
6 waiting_pid bigint(20) unsigned YES NULL
7 waiting_account text YES NULL
8 waiting_lock_type varchar(32) NO NULL
9 waiting_lock_duration varchar(32) NO NULL
10 waiting_query longtext YES NULL
11 waiting_query_secs bigint(20) YES NULL
12 waiting_query_rows_affected bigint(20) unsigned YES NULL
13 waiting_query_rows_examined bigint(20) unsigned YES NULL
14 blocking_thread_id bigint(20) unsigned NO NULL
15 blocking_pid bigint(20) unsigned YES NULL
16 blocking_account text YES NULL
17 blocking_lock_type varchar(32) NO NULL
18 blocking_lock_duration varchar(32) NO NULL
19 sql_kill_blocking_query varchar(31) YES NULL
20 sql_kill_blocking_connection varchar(25) YES NULL
21 SELECT * FROM sys.schema_table_lock_waits;
22 DESC sys.x$schema_table_lock_waits;
23 Field Type Null Key Default Extra
24 object_schema varchar(64) YES NULL
25 object_name varchar(64) YES NULL
26 waiting_thread_id bigint(20) unsigned NO NULL
27 waiting_pid bigint(20) unsigned YES NULL
28 waiting_account text YES NULL
29 waiting_lock_type varchar(32) NO NULL
30 waiting_lock_duration varchar(32) NO NULL
31 waiting_query longtext YES NULL
32 waiting_query_secs bigint(20) YES NULL
33 waiting_query_rows_affected bigint(20) unsigned YES NULL
34 waiting_query_rows_examined bigint(20) unsigned YES NULL
35 blocking_thread_id bigint(20) unsigned NO NULL
36 blocking_pid bigint(20) unsigned YES NULL
37 blocking_account text YES NULL
38 blocking_lock_type varchar(32) NO NULL
39 blocking_lock_duration varchar(32) NO NULL
40 sql_kill_blocking_query varchar(31) YES NULL
41 sql_kill_blocking_connection varchar(25) YES NULL
42 SELECT * FROM sys.x$schema_table_lock_waits;
43 connect con1,localhost,root,,;
44 connect con2,localhost,root,,;
45 connection con1;
46 CREATE TABLE test.lock_waits (i INT PRIMARY KEY, j INT) ENGINE = InnoDB;
47 LOCK TABLE lock_waits WRITE;
48 connection con2;
49 ALTER TABLE test.lock_waits ADD k VARCHAR(20);
50 connection default;
51 SELECT object_schema, object_name,
52 waiting_account, waiting_lock_type, waiting_query,
53 blocking_account, blocking_lock_type, blocking_lock_duration
54 FROM sys.schema_table_lock_waits;
55 object_schema object_name waiting_account waiting_lock_type waiting_query blocking_account blocking_lock_type blocking_lock_duration
56 test lock_waits root@localhost SHARED_UPGRADABLE ALTER TABLE test.lock_waits ADD k VARCHAR(20) root@localhost SHARED_NO_READ_WRITE TRANSACTION
57 disconnect con1;
58 connection default;
59 disconnect con2;
60 connection default;
61 DROP TABLE test.lock_waits;