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.
Leave Comment
Hugo
2015-03-14 20:20:38Excellent post. I was checking ctsloantny this blog and I'm inspired! Extremely helpful info particularly the last part I care for such info much. I was looking for this certain info for a long time. Thanks and good luck.