我找到一个可能可行的办法SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;查看其中TRX_ROWS_LOCKED的值,但是由于“ The value might include delete-marked rows that are physically present but not visible to the transaction.”所以产生2个问题:1、有其他查看表中索引上的行锁个数的办法吗?2、如果没有,什么情况下会产生delete-marked rows计数,或者说delete-marked rows是个什么东西。
求大神赐教