SHOW ENGINE INNODB STATUSG
-- LATEST DETECTED DEADLOCK names both statements, but only until the
-- next one replaces it; this is what is still holding a lock right now
SELECT trx_id, trx_state, trx_started, trx_mysql_thread_id, trx_query
FROM information_schema.innodb_trx
ORDER BY trx_started;