[MDEV-32841] Provide Innodb async IO statistics Created: 2023-11-19  Updated: 2024-01-24

Status: In Progress
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: 11.5

Type: Task Priority: Major
Reporter: Vladislav Vaintroub Assignee: Vladislav Vaintroub
Resolution: Unresolved Votes: 0
Labels: None


 Description   

There is no information about Innodb async IO internals, and some people seem interested.

Apparently we already have information on how many IOs are either inflight or in-completion-processing. We do have some information on how many tasks are being executed.
In principle, we can even dump every incomplete IO.

We do not currently instrument waits for "free io slot", that can result from undersizing innodb_io_read/write threads, however maybe just cache size can give a good estimate (if cache size is 0, waits happen, otherwise not)


Generated at Thu Feb 08 10:34:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.