Skip to content

Instantly share code, notes, and snippets.

@ryanermita

ryanermita/innodb_lock_wait_timeout.md

Created August 27, 2016 02:11
Show Gist options
  • Save ryanermita/e36354a85fb4f029a88dff830c96cce0 to your computer and use it in GitHub Desktop.
Save ryanermita/e36354a85fb4f029a88dff830c96cce0 to your computer and use it in GitHub Desktop.
Download ZIP
Updating innodb_lock_wait_timeout
Raw
innodb_lock_wait_timeout.md

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment