MySQL show open transaction 2022-10-19 06:24
Once I got stuck while executing sql. I checked the process with the following command
SHOW FULL PROCESSLIST
But all processes are in sleep state. I'm guessing that some transaction locks some rows. I use below sql to view all transaction information.
SELECT * FROM information_schema.innodb_trx
Fortunately I did find an uncommitted transaction. After I kill this transaction with the kill command, my sql can be executed successfully. The above sql will display the transaction id and thread id.When killing, you need to use the thread id as a parameter.
EOF