(none)> SELECT * FROM  sys.innodb_lock_waits\G

***************************[ 1. row ]***************************
wait_started                 | 2020-05-25 06:26:01
wait_age                     | 0:00:13
wait_age_secs                | 13
locked_table                 | `homestead`.`samples`
locked_index                 | PRIMARY
locked_type                  | RECORD
waiting_trx_id               | 47694
waiting_trx_started          | 2020-05-25 06:26:01
waiting_trx_age              | 0:00:13
waiting_trx_rows_locked      | 1
waiting_trx_rows_modified    | 0
waiting_pid                  | 1274
waiting_query                | insert into `samples` (`hoge_ ... at`) values (?, ?, ?, ?, ?, ?)
waiting_lock_id              | 47694:2144:3:1
waiting_lock_mode            | X
blocking_trx_id              | 47675
blocking_pid                 | 744 ←●注目
blocking_query               | <null>
blocking_lock_id             | 47675:2144:3:1
blocking_lock_mode           | X
blocking_trx_started         | 2020-05-24 16:54:51
blocking_trx_age             | 13:31:23
blocking_trx_rows_locked     | 40
blocking_trx_rows_modified   | 2
sql_kill_blocking_query      | KILL QUERY 744
sql_kill_blocking_connection | KILL 744
1 row in set
Time: 0.009s

逝ったれや！🐱

(none)> kill 744;
Query OK, 0 rows affected

@see

• MySQLでロックを特定し、強制終了する – Qiita

Amazonおすすめ

iPad 9世代 2021年最新作

iPad 9世代出たから買い替え。安いぞ！🐱 初めてならiPad。Kindleを外で見るならiPad mini。ほとんどの人には通常のiPadをおすすめします＞＜