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 unsigned NO NULL
6 waiting_pid bigint 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 YES NULL
12 waiting_query_rows_affected bigint unsigned YES NULL
13 waiting_query_rows_examined bigint unsigned YES NULL
14 blocking_thread_id bigint unsigned NO NULL
15 blocking_pid bigint 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 unsigned NO NULL
27 waiting_pid bigint 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 YES NULL
33 waiting_query_rows_affected bigint unsigned YES NULL
34 waiting_query_rows_examined bigint unsigned YES NULL
35 blocking_thread_id bigint unsigned NO NULL
36 blocking_pid bigint 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 CREATE TABLE test.lock_waits (i INT PRIMARY KEY, j INT) ENGINE = InnoDB;
44 LOCK TABLE lock_waits WRITE;
45 ALTER TABLE test.lock_waits ADD k VARCHAR(20);
46 SELECT SLEEP(1);
47 SLEEP(1)
48 0
49 SELECT object_schema, object_name,
50 waiting_account, waiting_lock_type, waiting_query,
51 blocking_account, blocking_lock_type, blocking_lock_duration
52 FROM sys.schema_table_lock_waits;
53 object_schema object_name waiting_account waiting_lock_type waiting_query blocking_account blocking_lock_type blocking_lock_duration
54 test lock_waits root@localhost SHARED_UPGRADABLE ALTER TABLE test.lock_waits ADD k VARCHAR(20) root@localhost SHARED_NO_READ_WRITE TRANSACTION
55 SELECT SLEEP(1);
56 SLEEP(1)
57 0
58 SELECT object_schema, object_name,
59 waiting_account, waiting_lock_type, waiting_query,
60 blocking_account, blocking_lock_type, blocking_lock_duration
61 FROM sys.schema_table_lock_waits;
62 object_schema object_name waiting_account waiting_lock_type waiting_query blocking_account blocking_lock_type blocking_lock_duration
63 DROP TABLE test.lock_waits;