| 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: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S5 (Performance) |
| Version: | 8.0.46, 8.4.9 | OS: | Linux |
| Assigned to: | CPU Architecture: | x86 | |

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