ryanermita/innodb_lock_wait_timeout.md

Created August 27, 2016 02:11

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ryanermita/e36354a85fb4f029a88dff830c96cce0.js"></script>
Save ryanermita/e36354a85fb4f029a88dff830c96cce0 to your computer and use it in GitHub Desktop.

Updating innodb_lock_wait_timeout

Raw

Very useful when you need to update database transaction locking timeout dyanamically.

SET SESSION innodb_lock_wait_timeout = 1; will set the innodb_lock_wait_timeout

SELECT @@innodb_lock_wait_timeout; will output the updated innodb_lock_wait_timeout

Select an option