[MySQL] 테이블 락 확인 및 해제

출처: https://hjjungdev.tistory.com/153

Mysql (Maria) Db 테이블락 확인하고 강제중지 방법.

-- 락테이블 조회
select * from information_schema.innodb_locks;
-- 대기중인 락 조회
select * from information_schema.innodb_lock_waits;

MariaDB [mysql]> select * from information_schema.innodb_locks;

+--------------------------+-------------+-----------+-----------+------------------------------+------------+------------+-----------+----------+--------------------------------------------+

| lock_id                  | lock_trx_id | lock_mode | lock_type | lock_table                   | lock_index | lock_space | lock_page | lock_rec | lock_data                                  |

+--------------------------+-------------+-----------+-----------+------------------------------+------------+------------+-----------+----------+--------------------------------------------+

| 208974131:14625:2153:180 | 208974131   | X         | RECORD    | test.test | PRIMARY    |      14625 |      2153 |      180 | 2100000543, '+CrPldwM2imKVZqpr2botBVtMnA=' |

| 208907691:14625:2153:180 | 208907691   | X         | RECORD    | test.test | PRIMARY    |      14625 |      2153 |      180 | 2100000543, '+CrPldwM2imKVZqpr2botBVtMnA=' |

kill 208974131