select * from innodb_lock_waits;
admin@172.17.0.81 15:15: [information_schema]>select * from innodb_locks where lock_trx_id in (select blocking_trx_id from innodb_lock_waits);
admin@172.17.0.81 15:18: [information_schema]>select * from innodb_locks join innodb_lock_waits on (innodb_locks.lock_trx_id=innodb_lock_waits.blocking_trx_id);
admin@172.17.0.81 15:20: [information_schema]>select * from innodb_locks where lock_table='table_name';
admin@172.17.0.81 15:39: [information_schema]>select trx_id,trx_requested_lock_id,trx_mysql_thread_id,trx_query from innodb_trx where trx_state='LOCK_WAIT';