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