Skip to content

Instantly share code, notes, and snippets.

@6ui11em

6ui11em/force_unlock_tables.sql

Created May 29, 2018 11:39
Show Gist options
  • Save 6ui11em/360881ac7b825e90ccf5a7710ad77072 to your computer and use it in GitHub Desktop.
Save 6ui11em/360881ac7b825e90ccf5a7710ad77072 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL force unlock tables. #mysql
Raw
force_unlock_tables.sql
mysql -u your_user -p
mysql> show open tables where in_use>0;
mysql> show processlist;
mysql> kill put_process_id_here;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment