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 X X
4 wait_age time X X
5 wait_age_secs bigint X X
6 locked_table mediumtext X X
7 locked_table_schema varchar(64) X X
8 locked_table_name varchar(64) X X
9 locked_table_partition varchar(64) X X
10 locked_table_subpartition varchar(64) X X
11 locked_index varchar(64) X X
12 locked_type varchar(32) X X
13 waiting_trx_id bigint unsigned X X
14 waiting_trx_started datetime X X
15 waiting_trx_age time X X
16 waiting_trx_rows_locked bigint unsigned X X
17 waiting_trx_rows_modified bigint unsigned X X
18 waiting_pid bigint unsigned X X
19 waiting_query longtext X X
20 waiting_lock_id varchar(128) X X
21 waiting_lock_mode varchar(32) X X
22 blocking_trx_id bigint unsigned X X
23 blocking_pid bigint unsigned X X
24 blocking_query longtext X X
25 blocking_lock_id varchar(128) X X
26 blocking_lock_mode varchar(32) X X
27 blocking_trx_started datetime X X
28 blocking_trx_age time X X
29 blocking_trx_rows_locked bigint unsigned X X
30 blocking_trx_rows_modified bigint unsigned X X
31 sql_kill_blocking_query varchar(33) X X
32 sql_kill_blocking_connection varchar(27) X X
33 SELECT * FROM sys.innodb_lock_waits;
34 DESC sys.x$innodb_lock_waits;
35 Field Type Null Key Default Extra
36 wait_started datetime X X
37 wait_age time X X
38 wait_age_secs bigint X X
39 locked_table mediumtext X X
40 locked_table_schema varchar(64) X X
41 locked_table_name varchar(64) X X
42 locked_table_partition varchar(64) X X
43 locked_table_subpartition varchar(64) X X
44 locked_index varchar(64) X X
45 locked_type varchar(32) X X
46 waiting_trx_id bigint unsigned X X
47 waiting_trx_started datetime X X
48 waiting_trx_age time X X
49 waiting_trx_rows_locked bigint unsigned X X
50 waiting_trx_rows_modified bigint unsigned X X
51 waiting_pid bigint unsigned X X
52 waiting_query varchar(1024) X X
53 waiting_lock_id varchar(128) X X
54 waiting_lock_mode varchar(32) X X
55 blocking_trx_id bigint unsigned X X
56 blocking_pid bigint unsigned X X
57 blocking_query varchar(1024) X X
58 blocking_lock_id varchar(128) X X
59 blocking_lock_mode varchar(32) X X
60 blocking_trx_started datetime X X
61 blocking_trx_age time X X
62 blocking_trx_rows_locked bigint unsigned X X
63 blocking_trx_rows_modified bigint unsigned X X
64 sql_kill_blocking_query varchar(33) X X
65 sql_kill_blocking_connection varchar(27) X X
66 SELECT * FROM sys.x$innodb_lock_waits;
67 EXPLAIN SELECT * FROM sys.innodb_lock_waits;
68 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
69 1 PRIMARY <derived2> NULL ALL NULL NULL NULL NULL 399996 100.00 NULL
70 2 DERIVED b NULL ALL NULL NULL NULL NULL NULL NULL Using temporary; Using filesort
71 2 DERIVED r NULL ALL NULL NULL NULL NULL NULL NULL Using join buffer (hash join)
72 2 DERIVED w NULL ALL PRIMARY,REQUESTING_ENGINE_LOCK_ID,BLOCKING_ENGINE_LOCK_ID NULL NULL NULL 99999 100.00 Using where; Using join buffer (hash join)
73 2 DERIVED bl NULL eq_ref PRIMARY PRIMARY 644 performance_schema.w.BLOCKING_ENGINE_LOCK_ID,performance_schema.w.ENGINE 1 100.00 NULL
74 2 DERIVED rl NULL eq_ref PRIMARY PRIMARY 644 performance_schema.w.REQUESTING_ENGINE_LOCK_ID,performance_schema.w.ENGINE 1 100.00 NULL
75 Warnings:
76 Note 1003 /* select#1 */ select `sys`.`innodb_lock_waits`.`wait_started` AS `wait_started`,`sys`.`innodb_lock_waits`.`wait_age` AS `wait_age`,`sys`.`innodb_lock_waits`.`wait_age_secs` AS `wait_age_secs`,`sys`.`innodb_lock_waits`.`locked_table` AS `locked_table`,`sys`.`innodb_lock_waits`.`locked_table_schema` AS `locked_table_schema`,`sys`.`innodb_lock_waits`.`locked_table_name` AS `locked_table_name`,`sys`.`innodb_lock_waits`.`locked_table_partition` AS `locked_table_partition`,`sys`.`innodb_lock_waits`.`locked_table_subpartition` AS `locked_table_subpartition`,`sys`.`innodb_lock_waits`.`locked_index` AS `locked_index`,`sys`.`innodb_lock_waits`.`locked_type` AS `locked_type`,`sys`.`innodb_lock_waits`.`waiting_trx_id` AS `waiting_trx_id`,`sys`.`innodb_lock_waits`.`waiting_trx_started` AS `waiting_trx_started`,`sys`.`innodb_lock_waits`.`waiting_trx_age` AS `waiting_trx_age`,`sys`.`innodb_lock_waits`.`waiting_trx_rows_locked` AS `waiting_trx_rows_locked`,`sys`.`innodb_lock_waits`.`waiting_trx_rows_modified` AS `waiting_trx_rows_modified`,`sys`.`innodb_lock_waits`.`waiting_pid` AS `waiting_pid`,`sys`.`innodb_lock_waits`.`waiting_query` AS `waiting_query`,`sys`.`innodb_lock_waits`.`waiting_lock_id` AS `waiting_lock_id`,`sys`.`innodb_lock_waits`.`waiting_lock_mode` AS `waiting_lock_mode`,`sys`.`innodb_lock_waits`.`blocking_trx_id` AS `blocking_trx_id`,`sys`.`innodb_lock_waits`.`blocking_pid` AS `blocking_pid`,`sys`.`innodb_lock_waits`.`blocking_query` AS `blocking_query`,`sys`.`innodb_lock_waits`.`blocking_lock_id` AS `blocking_lock_id`,`sys`.`innodb_lock_waits`.`blocking_lock_mode` AS `blocking_lock_mode`,`sys`.`innodb_lock_waits`.`blocking_trx_started` AS `blocking_trx_started`,`sys`.`innodb_lock_waits`.`blocking_trx_age` AS `blocking_trx_age`,`sys`.`innodb_lock_waits`.`blocking_trx_rows_locked` AS `blocking_trx_rows_locked`,`sys`.`innodb_lock_waits`.`blocking_trx_rows_modified` AS `blocking_trx_rows_modified`,`sys`.`innodb_lock_waits`.`sql_kill_blocking_query` AS `sql_kill_blocking_query`,`sys`.`innodb_lock_waits`.`sql_kill_blocking_connection` AS `sql_kill_blocking_connection` from `sys`.`innodb_lock_waits`
77 EXPLAIN SELECT * FROM sys.x$innodb_lock_waits;
78 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
79 1 PRIMARY <derived2> NULL ALL NULL NULL NULL NULL 399996 100.00 NULL
80 2 DERIVED b NULL ALL NULL NULL NULL NULL NULL NULL Using temporary; Using filesort
81 2 DERIVED r NULL ALL NULL NULL NULL NULL NULL NULL Using join buffer (hash join)
82 2 DERIVED w NULL ALL PRIMARY,REQUESTING_ENGINE_LOCK_ID,BLOCKING_ENGINE_LOCK_ID NULL NULL NULL 99999 100.00 Using where; Using join buffer (hash join)
83 2 DERIVED bl NULL eq_ref PRIMARY PRIMARY 644 performance_schema.w.BLOCKING_ENGINE_LOCK_ID,performance_schema.w.ENGINE 1 100.00 NULL
84 2 DERIVED rl NULL eq_ref PRIMARY PRIMARY 644 performance_schema.w.REQUESTING_ENGINE_LOCK_ID,performance_schema.w.ENGINE 1 100.00 NULL
85 Warnings:
86 Note 1003 /* select#1 */ select `sys`.`x$innodb_lock_waits`.`wait_started` AS `wait_started`,`sys`.`x$innodb_lock_waits`.`wait_age` AS `wait_age`,`sys`.`x$innodb_lock_waits`.`wait_age_secs` AS `wait_age_secs`,`sys`.`x$innodb_lock_waits`.`locked_table` AS `locked_table`,`sys`.`x$innodb_lock_waits`.`locked_table_schema` AS `locked_table_schema`,`sys`.`x$innodb_lock_waits`.`locked_table_name` AS `locked_table_name`,`sys`.`x$innodb_lock_waits`.`locked_table_partition` AS `locked_table_partition`,`sys`.`x$innodb_lock_waits`.`locked_table_subpartition` AS `locked_table_subpartition`,`sys`.`x$innodb_lock_waits`.`locked_index` AS `locked_index`,`sys`.`x$innodb_lock_waits`.`locked_type` AS `locked_type`,`sys`.`x$innodb_lock_waits`.`waiting_trx_id` AS `waiting_trx_id`,`sys`.`x$innodb_lock_waits`.`waiting_trx_started` AS `waiting_trx_started`,`sys`.`x$innodb_lock_waits`.`waiting_trx_age` AS `waiting_trx_age`,`sys`.`x$innodb_lock_waits`.`waiting_trx_rows_locked` AS `waiting_trx_rows_locked`,`sys`.`x$innodb_lock_waits`.`waiting_trx_rows_modified` AS `waiting_trx_rows_modified`,`sys`.`x$innodb_lock_waits`.`waiting_pid` AS `waiting_pid`,`sys`.`x$innodb_lock_waits`.`waiting_query` AS `waiting_query`,`sys`.`x$innodb_lock_waits`.`waiting_lock_id` AS `waiting_lock_id`,`sys`.`x$innodb_lock_waits`.`waiting_lock_mode` AS `waiting_lock_mode`,`sys`.`x$innodb_lock_waits`.`blocking_trx_id` AS `blocking_trx_id`,`sys`.`x$innodb_lock_waits`.`blocking_pid` AS `blocking_pid`,`sys`.`x$innodb_lock_waits`.`blocking_query` AS `blocking_query`,`sys`.`x$innodb_lock_waits`.`blocking_lock_id` AS `blocking_lock_id`,`sys`.`x$innodb_lock_waits`.`blocking_lock_mode` AS `blocking_lock_mode`,`sys`.`x$innodb_lock_waits`.`blocking_trx_started` AS `blocking_trx_started`,`sys`.`x$innodb_lock_waits`.`blocking_trx_age` AS `blocking_trx_age`,`sys`.`x$innodb_lock_waits`.`blocking_trx_rows_locked` AS `blocking_trx_rows_locked`,`sys`.`x$innodb_lock_waits`.`blocking_trx_rows_modified` AS `blocking_trx_rows_modified`,`sys`.`x$innodb_lock_waits`.`sql_kill_blocking_query` AS `sql_kill_blocking_query`,`sys`.`x$innodb_lock_waits`.`sql_kill_blocking_connection` AS `sql_kill_blocking_connection` from `sys`.`x$innodb_lock_waits`