Skip to content
Advertisement

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?

Advertisement

Answer

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

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement