Equivalent of sp_lock, sp_who for mysql
Hi guys, Can anyone please tell me what is the equivalent of sp_lock, sp_who or sp_who2 in mysql server? Basically I want to know which tables are locked due to some query and which host is holding on to those exclusive locks. Thanks in advance ...