Cause of blocking?

[Garrett]

Hi friends,
As by using "show full processlist", we can find the blocked table. I wish to know a way by which we can find which DML caused the blocking? Is it possible in some way or other?
Thanks. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Saggie]

Dedug command from mysqladmin can provide the table locking information and the threads that hold the locks, but it requires the debug binary of the mysqld to get this information. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --