sys Schema Views The number of cached rows for the table. The  innodb_lock_waits  and  x$innodb_lock_waits  views have these columns: These views summarize the  InnoDB  locks that transactions are waiting for. By default, rows are sorted by descending lock age. The time at which the lock wait started. How long the lock has been waited for, as a  TIME  value. How long the lock has been waited for, in seconds. The schema that contains the locked table. The name of the locked table. The name of the locked partition, if any;  NULL  otherwise. The name of the locked subpartition, if any;  NULL  otherwise. The name of the locked index. The type of the waiting lock. The ID of the waiting transaction. The time at which the waiting transaction started. How long the waiting transaction has been waiting, as a  TIME  value. 5147 • waiting_trx_rows_locked • waiting_trx_age • waiting_trx_started • waiting_trx_id • locked_type • locked_index • locked_table_subpartition • locked_table_partition • locked_table_name • locked_table_schema • wait_age_secs • wait_age • wait_started • rows_cached 28.4.3.9 The innodb_lock_waits and x$innodb_lock_waits Views