MySQL Forums
Forum List  »  MyISAM

Which blocks which?
Posted by: Jacky Shu
Date: January 24, 2006 10:10AM

Hi there,

By "show full processlist", we can find which table is blocked.
But any way that we can find which DML caused the blocking?
I tried "mysqladmin debug", it only output the address of locking and memory usage, it didn't help much.
I mean if "show full processlist" can show "locking" in "status" column, just like "locked" table, that will be very helpful.
Please don't tell me to go back to business logic and figure out which DML caused the locking.
There should be a way from the db side.

Thanks,

Jacky Shu

OCPDBA, MCDBA

Options: ReplyQuote


Subject
Views
Written By
Posted
Which blocks which?
2584
January 24, 2006 10:10AM
1789
January 25, 2006 03:49AM
1792
January 25, 2006 06:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.