I am looking at the percona monitoring management documentation, wherein it has talked about IO analysis for queries. MySQL Query Performance Troubleshooting: Resource-Based Approach - Percona Database Performance Blog. In the document, it is mentioned that “MySQL does not really provide very good instrumentation in those terms, and it is not easy to get information on how much CPU usage, Disk IO, or Memory a given query caused.”
Since I know PMM depends on performance schema in mysql to get stats, I was wondering how we collect query level stats for IO wait metrics. Performance schema has wait related instruments, however it provides aggregated level information. It does not provide metrics for individual query level IO wait. Can you please help me understand how we prepare this data?