Skip to content

Instantly share code, notes, and snippets.

@soundkitchen

soundkitchen/gist:466379

Created July 7, 2010 06:26
Show Gist options
  • Save soundkitchen/466379 to your computer and use it in GitHub Desktop.
Save soundkitchen/466379 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
-- find current processes.
mysql> SHOW PROCESSLIST;
-- kill process by process id
mysql> KILL <PROCESS ID>;
-- find lock.
--
-- When In_use is 0, anyone locked it. otherwise someone locked.
-- When Name_locked is 1, DDL locked it.
mysql> SHOW OPEN TABLES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment