Why is the value of this parameter Innodb_row_lock_current_waits not zero?
General
Escalation
General
Escalation
Description
Server version: 5.7.24-26-log Percona Server (GPL), Release 26, Revision c8fe767 mysql> show status where Variable_name = 'Innodb_row_lock_current_waits'; --------------------------------------+
Variable_name
Value
--------------------------------------+
Innodb_row_lock_current_waits
22
--------------------------------------+ 1 row in set (0.01 sec)
mysql> select count from information_schema.innodb_lock_waits; ----------
count
----------
0
---------- 1 row in set, 1 warning (0.00 sec)
mysql> select version(); ---------------
version()
---------------
5.7.24-26-log
--------------- 1 row in set (0.00 sec)
Environment
None
Smart Checklist
Activity
Show:
Lalit Choudhary July 30, 2019 at 8:00 AM
Hello @WangTuo
Thank you for the report.
These counters seem to be designed as "fuzzy" so we do not think that this is really a bug if they show wrong value. Hence, the behavior is so by design.
Server version: 5.7.24-26-log Percona Server (GPL), Release 26, Revision c8fe767
mysql> show status where Variable_name = 'Innodb_row_lock_current_waits';
--------------------------------------+
Variable_name
Value
--------------------------------------+
Innodb_row_lock_current_waits
22
--------------------------------------+
1 row in set (0.01 sec)
mysql> select count from information_schema.innodb_lock_waits;
----------
count
----------
0
----------
1 row in set, 1 warning (0.00 sec)
mysql> select version();
---------------
version()
---------------
5.7.24-26-log
---------------
1 row in set (0.00 sec)