Home > database >  Mysql for help: how to query a table in the index number of lock on the line
Mysql for help: how to query a table in the index number of lock on the line

Time:09-26

I might find a feasible way to SELECT * FROM INFORMATION_SCHEMA. INNODB_TRX; Examine The TRX_ROWS_LOCKED values, but because of "The value took The include delete - marked rows that are physically present but not visible to The transaction." so The two problems: 1, there are other view table index number of row locks on The way? 2, if not, what circumstance can produce the delete - marked rows counting, or delete - marked rows is a what thing,
Pray god grant instruction
  • Related