MySQL Forums
Forum List  »  MySQL Workbench

Re: Need_info_about_wait_lock_time_out
Posted by: Harshada Thakur
Date: April 08, 2013 12:27AM

You should consider increasing the lock wait timeout value for InnoDB by setting the innodb_lock_wait_timeout, default is 50 sec

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

You can set it to higher value in /etc/my.cnf permanently with this line

[mysqld]
innodb_lock_wait_timeout=120

and restart mysql. If you cannot restart mysql at this time, run this:

SET GLOBAL innodb_lock_wait_timeout = 120;

You could also just set it for the duration of your session

SET innodb_lock_wait_timeout = 120;

followed by your query

Give it a Try !!!

Options: ReplyQuote


Subject
Views
Written By
Posted
1318
April 05, 2013 07:08AM
Re: Need_info_about_wait_lock_time_out
858
April 08, 2013 12:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.