MySQL Table and Row level lock status check

{Table Level}

show status like 'table%';

{Row Level}

show status like 'innodb_row_lock%';

{Innodb Monitor Open}

create table innodb_monitor(a int) engine=innodb;

 

In short, top 2 for check status, and thrid one for create new table let db know monitor operate start, a kind like MySQL log.