• rows_cached 

The number of cached rows for the table. 

## 28.4.3.9 The innodb_lock_waits and x$innodb_lock_waits Views 

These views summarize the InnoDB  locks that transactions are waiting for. By default, rows are sorted by descending lock age. 

The innodb_lock_waits  and x$innodb_lock_waits  views have these columns: 

• wait_started 

The time at which the lock wait started. 

• wait_age 

How long the lock has been waited for, as a TIME  value. 

• wait_age_secs 

How long the lock has been waited for, in seconds. 

• locked_table_schema 

The schema that contains the locked table. 

• locked_table_name 

The name of the locked table. 

• locked_table_partition 

The name of the locked partition, if any; NULL  otherwise. 

• locked_table_subpartition 

The name of the locked subpartition, if any; NULL  otherwise. 

• locked_index 

The name of the locked index. 

• locked_type 

The type of the waiting lock. 

• waiting_trx_id 

The ID of the waiting transaction. 

• waiting_trx_started 

The time at which the waiting transaction started. 

• waiting_trx_age 

How long the waiting transaction has been waiting, as a TIME  value. 

• waiting_trx_rows_locked 

