| 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` |