Debian Codegraph @

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

raw
1 DESC sys.innodb_lock_waits;
2 Field Type Null Key Default Extra
3 wait_started datetime YES NULL
4 wait_age time /* mariadb-5.3 */ YES NULL
5 wait_age_secs bigint(21) YES NULL
6 locked_table varchar(1024) NO NULL
7 locked_index varchar(1024) YES NULL
8 locked_type enum('RECORD','TABLE') NO NULL
9 waiting_trx_id bigint(21) unsigned NO NULL
10 waiting_trx_started datetime NO NULL
11 waiting_trx_age time /* mariadb-5.3 */ YES NULL
12 waiting_trx_rows_locked bigint(21) unsigned NO NULL
13 waiting_trx_rows_modified bigint(21) unsigned NO NULL
14 waiting_pid bigint(21) unsigned NO NULL
15 waiting_query longtext YES NULL
16 waiting_lock_id varchar(81) NO NULL
17 waiting_lock_mode enum('S','S,GAP','X','X,GAP','IS','IS,GAP','IX','IX,GAP','AUTO_INC') NO NULL
18 blocking_trx_id bigint(21) unsigned NO NULL
19 blocking_pid bigint(21) unsigned NO NULL
20 blocking_query longtext YES NULL
21 blocking_lock_id varchar(81) NO NULL
22 blocking_lock_mode enum('S','S,GAP','X','X,GAP','IS','IS,GAP','IX','IX,GAP','AUTO_INC') NO NULL
23 blocking_trx_started datetime NO NULL
24 blocking_trx_age time /* mariadb-5.3 */ YES NULL
25 blocking_trx_rows_locked bigint(21) unsigned NO NULL
26 blocking_trx_rows_modified bigint(21) unsigned NO NULL
27 sql_kill_blocking_query varchar(32) YES NULL
28 sql_kill_blocking_connection varchar(26) YES NULL
29 SELECT * FROM sys.innodb_lock_waits;
30 DESC sys.x$innodb_lock_waits;
31 Field Type Null Key Default Extra
32 wait_started datetime YES NULL
33 wait_age time /* mariadb-5.3 */ YES NULL
34 wait_age_secs bigint(21) YES NULL
35 locked_table varchar(1024) NO NULL
36 locked_index varchar(1024) YES NULL
37 locked_type enum('RECORD','TABLE') NO NULL
38 waiting_trx_id bigint(21) unsigned NO NULL
39 waiting_trx_started datetime NO NULL
40 waiting_trx_age time /* mariadb-5.3 */ YES NULL
41 waiting_trx_rows_locked bigint(21) unsigned NO NULL
42 waiting_trx_rows_modified bigint(21) unsigned NO NULL
43 waiting_pid bigint(21) unsigned NO NULL
44 waiting_query varchar(1024) YES NULL
45 waiting_lock_id varchar(81) NO NULL
46 waiting_lock_mode enum('S','S,GAP','X','X,GAP','IS','IS,GAP','IX','IX,GAP','AUTO_INC') NO NULL
47 blocking_trx_id bigint(21) unsigned NO NULL
48 blocking_pid bigint(21) unsigned NO NULL
49 blocking_query varchar(1024) YES NULL
50 blocking_lock_id varchar(81) NO NULL
51 blocking_lock_mode enum('S','S,GAP','X','X,GAP','IS','IS,GAP','IX','IX,GAP','AUTO_INC') NO NULL
52 blocking_trx_started datetime NO NULL
53 blocking_trx_age time /* mariadb-5.3 */ YES NULL
54 blocking_trx_rows_locked bigint(21) unsigned NO NULL
55 blocking_trx_rows_modified bigint(21) unsigned NO NULL
56 sql_kill_blocking_query varchar(32) YES NULL
57 sql_kill_blocking_connection varchar(26) YES NULL
58 SELECT * FROM sys.x$innodb_lock_waits;
59 #
60 # Start of 10.6 tests
61 #
62 #
63 # MDEV-26507 Assertion `tmp != ((long long) 0x8000000000000000LL)' failed in TIME_from_longlong_datetime_packed
64 #
65 SET SESSION sql_mode='ALLOW_INVALID_DATES';
66 SELECT * FROM sys.x$innodb_lock_waits;
67 SET SESSION sql_mode=DEFAULT;
68 #
69 # End of 10.6 tests
70 #