MySQL 表级行级锁定状态查看
{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;
CN : 简单的说上2个是查看，下面是一个是新建一张表，让数据库知道要开始monitor操作了，类似MySQL log.
{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;
CN : 简单的说上2个是查看，下面是一个是新建一张表，让数据库知道要开始monitor操作了，类似MySQL log.
YiiLib 专注于: 专业Web开发教程和专业Web开发服务
Copyright © 2011 - 2024 YiiLib.com(YiiBlog.info) - Designed & Developed by Boy.Lee
留言
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.