Find the query from query_id in mysql

mysql deadlock workbench
TJ- picture TJ- · Aug 25, 2011 · Viewed 10.5k times · Source

Can I find the exact query from mysql query id?

This is a part of "SHOW ENGINE INNODB STATUS" in MySQL:

MySQL thread id 1106, query id 1360 localhost 127.0.0.1 test2
---TRANSACTION 0 19491, not started, OS thread id 2960035840

Is there a way by which I can find what was the query with id 1360?

Answer

bpgergo picture bpgergo · Aug 25, 2011

Some folks say turn on 'general log' and you'll find your query by id. http://forums.mysql.com/read.php?22,419784,419896#msg-419896

Related questions

How to avoid mysql 'Deadlock found when trying to get lock; try restarting transaction'

I have a innoDB table which records online users. It gets updated on every page refresh by a user to keep track of which pages they are on and their last access date to the site. I then have a …

Read More
Working around MySQL error "Deadlock found when trying to get lock; try restarting transaction"

I have a MySQL table with about 5,000,000 rows that are being constantly updated in small ways by parallel Perl processes connecting via DBI. The table has about 10 columns and several indexes. One fairly common operation gives rise to the following …

Read More
How can I clear a transaction deadlock?

Using 'show engine innodb status' I see that wordpress has two deadlocks. I'd like to clear these up but I don't see an active process for either of these cmds (IE something to 'kill' and hopefully force a rollback). I …

Read More