
mysql> show status like 'innodb_row_lock%';
+-------------------------------+--------+
| Variable_name | Value |
+-------------------------------+--------+
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 101613 |
| Innodb_row_lock_time_avg | 50806 |
| Innodb_row_lock_time_max | 51220 |
| Innodb_row_lock_waits | 2 |
+-------------------------------+--------+
5 rows in set (0.00 sec)
mysql> flush status;
Query OK, 0 rows affected (0.01 sec)
mysql> show status like 'innodb_row_lock%';
+-------------------------------+--------+
| Variable_name | Value |
+-------------------------------+--------+
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 101613 |
| Innodb_row_lock_time_avg | 50806 |
| Innodb_row_lock_time_max | 51220 |
| Innodb_row_lock_waits | 2 |
+-------------------------------+--------+
