[MDEV-15756] innodb engine status missing some IO statistics Created: 2018-04-02 Updated: 2021-04-26 Resolved: 2021-04-26 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.2.2, 10.3.0 |
| Fix Version/s: | 10.5.10 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Jonathan Nicol | Assignee: | Marko Mäkelä |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | upstream | ||
| Environment: |
linux |
||
| Issue Links: |
|
||||||||
| Description |
|
Somewhere between 10.1 and 10.2, some of the IO statistics in 'show engine innodb status' stopped working. In 10.1:
in 10.2:
As you can see there are some zeroes missing. thanks |
| Comments |
| Comment by Marko Mäkelä [ 2018-05-30 ] | |||||||||||||||
|
The same issue appears to exist in MySQL since version 5.7.8, where some code was refactored. Either the function AIO::print_segment_info() or its caller should display m_n_reserved. | |||||||||||||||
| Comment by Marko Mäkelä [ 2021-04-26 ] | |||||||||||||||
|
It looks like this got broken further in
As part of Because there have not been any further votes or comments for this issue, I think that it is fine to remove the code. Asynchronous reads are only used by read-ahead. Asynchronous writes are being used for data file pages, and it could hurt performance to accurately track the number of pending operations, which is not interesting anyway. I suspect that the output had originally been added in order to be able to diagnose some hangs. I do not remember any I/O hangs lately. | |||||||||||||||
| Comment by Marko Mäkelä [ 2021-04-26 ] | |||||||||||||||
|
Most of the statistics were already removed in MariaDB 10.5.0. 10.5.10 will remove the string "Pending normal aio reads" that was not followed by any numbers. |