|List:||InnoDB Storage Engine||« Previous MessageNext Message »|
|From:||孔智||Date:||February 13 2014 3:12pm|
|Subject:||output the query id of locks waiting for|
|View as plain text|
hi all: I want to know the sql of the lock which blocks current query. So I record the query id of the sql creating the lock. If waiting for it , then output it through show innodb status. But I can't get the query id of the implicit lock easily like the explicit ones. Can someone help me.
|• output the query id of locks waiting for||孔智||13 Feb 2014|