MySQL innodb lock wait timeout

1 개요

innodb_lock_wait_timeout

mysql> show variables like 'innodb_lock_wait_timeout';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| innodb_lock_wait_timeout | 50    |
+--------------------------+-------+
1 row in set (0.00 sec)

2 같이 보기

• MySQL 튜닝
• Error: 1205 Lock wait timeout exceeded; try restarting transaction
• 미디어위키 Error: 1205 Lock wait timeout exceeded; try restarting transaction