Sourabh Sourabh - 7 days ago 6
SQL Question

effective innodb_lock_wait_timeout value check

I have a table with lakhs of rows. Now, suddenly I need to create a varchar column index. Also, I need to perform some operations using that column. But its giving innodb_lock_wait_timeout exceeded error. I googled it and changed the value of innodb_lock_wait_timeout to 500 in my.ini file in my mysql folder. But Its still giving the same error. I need to be sure if the value has actually been changed or not. How can I check the effective innodb_lock_wait_timeout value?

Answer

I found the answer. I need to run a query : "show variables like 'innodb_lock_wait_timeout'".