Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> set innodb_lock_wait_timeout=100
- Query OK, 0 rows affected (0.02 sec)
- mysql> show variables like 'innodb_lock_wait_timeout';
- +--------------------------+-------+
- | Variable_name | Value |
- +--------------------------+-------+
- | innodb_lock_wait_timeout | 100 |
- +--------------------------+-------+
- SHOW ENGINE INNODB STATUSG
- show open tables where in_use>0;
- show full processlist;
Add Comment
Please, Sign In to add comment