Skip to content

Instantly share code, notes, and snippets.

@cmpscabral

cmpscabral/gist:46deeb742e4d0e27a12c

Created January 27, 2015 18:26
Show Gist options
  • Save cmpscabral/46deeb742e4d0e27a12c to your computer and use it in GitHub Desktop.
Save cmpscabral/46deeb742e4d0e27a12c to your computer and use it in GitHub Desktop.
Download ZIP
mysql lock timeout
Raw
gistfile1.sh
mysql> show open tables where in_use>0;
mysql> show processlist;
mysql> kill put_process_id_here;
mysql> show variables like 'innodb_lock_wait_timeout';
mysql> set innodb_lock_wait_timeout=100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment