Bug #120596 WAIT_FOR_READ, WAIT_FOR_WRITE is stuck in the 2012
Submitted: 2 Jun 6:37
Reporter: Alex Zimnitski Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S5 (Performance)
Version:8.0.46, 8.4.9 OS:Linux
Assigned to: CPU Architecture:x86

[2 Jun 6:37] Alex Zimnitski
Description:
This constant does match NVMe read response times (100 us) but NVMe can do reads in ~10 us.

constexpr std::chrono::microseconds WAIT_FOR_READ{100};
constexpr std::chrono::microseconds WAIT_FOR_WRITE{100};

It is used in buf_page_get_zip, zip_page_handler, check_state

How to repeat:
Run Innodb on NVMe storage

Suggested fix:
Use a shorter wait