title: Equivalent of sp_lock, sp_who for mysql
body: <p>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.</p>
  
  <p>Thanks in advance</p>