1

I am using mysql and trying to analyze performance issues on it. I am using innodb_row_lock_waits to indicate whether there is a row lock contention. The system is used by many consumers so I want to know which table is having the most contention. Is there a way to figure out or print the value of innodb_row_lock_waits per table? If not, is there something else which can be used to get this information?

I am using Percona MYSQL 8.0 with innodb as the storage engine.

pnndesh
  • 11
  • 2
  • 1
    I prefer to start with the slowlog. Delays due to locks tend to show up there as a long query time. Also check `SHOW ENGINE=InnoDB STATUS` to look for deadlocks. – Rick James Jun 02 '21 at 00:13

1 Answers1

0

you can do it use the performance_schema.metadata_locks tables

Zheng Songhua
  • 11
  • 1