Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Innodb_row_lock_current_waits is inaccurate

Description

Upstream bug report: https://bugs.mysql.com/bug.php?id=94775

 

Steps to reproduce:

01) prepare

/usr/share/sysbench/oltp_update_index.lua prepare --mysql-host=127.0.0.1 --mysql-port=8030 --mysql-user=msandbox --mysql-password=msandbox --mysql-db=test --threads=32 --table-size=100 --tables=32

02) run

/usr/share/sysbench/oltp_update_index.lua run --mysql-host=127.0.0.1 --mysql-port=8030 --mysql-user=msandbox --mysql-password=msandbox --mysql-db=test --threads=32 --table-size=100 --tables=32

03) check the value of Innodb_row_lock_current_waits, after the complete run it will be >= 0, even without any connections.

Environment

None

AFFECTED CS IDs

CS0035520

Activity

Show:

Smart Checklist

Created April 18, 2023 at 9:17 AM
Updated March 6, 2024 at 9:43 AM
Configure

Flag notifications