Skip to content

Instantly share code, notes, and snippets.

@jedprentice

jedprentice/gist:4e3dfba017b0b4d29ef3102bee1f1069

Created October 18, 2018 21:22
Show Gist options
  • Save jedprentice/4e3dfba017b0b4d29ef3102bee1f1069 to your computer and use it in GitHub Desktop.
Save jedprentice/4e3dfba017b0b4d29ef3102bee1f1069 to your computer and use it in GitHub Desktop.
Download ZIP
How to find out which query is holding a lock in MySQL
Raw
gistfile1.txt
mysql> SELECT r.trx_id waiting_trx_id, r.trx_mysql_thread_id waiting_thread, r.trx_query waiting_query,
b.trx_id blocking_trx_id, b.trx_mysql_thread_id blocking_thread, b.trx_query blocking_query
FROM information_schema.innodb_lock_waits w
INNER JOIN information_schema.innodb_trx b ON b.trx_id = w.blocking_trx_id
INNER JOIN information_schema.innodb_trx r ON r.trx_id = w.requesting_trx_id\G
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment