mysql 哪些表正在被锁状态

查询mysql 哪些表正在被锁状态
show OPEN TABLES where In_use > 0;

select ID,USER,HOST,DB,COMMAND,TIME,INFO from information_schema.processlist where INFO is not null ;

select p.*, now() - t.trx_started as runtime 
  from information_schema.processlist p, information_schema.INNODB_TRX t 
 where p.id =t.trx_MySQl_thread_id