SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1061 | 5.46 s | 121.09 ms | |
background | wait/io/file/innodb/innodb_data_file | 2739 | 2.33 s | 247.88 ms | |
background | wait/io/file/innodb/innodb_temp_file | 645 | 646.78 ms | 172.76 ms | |
background | wait/io/file/sql/binlog_index | 36 | 63.71 ms | 46.46 ms | |
background | wait/io/file/sql/binlog | 37 | 32.42 ms | 16.34 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.14 ms | 473.00 us | |
background | wait/io/file/sql/casetest | 15 | 916.72 us | 852.41 us | |
background | wait/io/file/mysys/cnf | 5 | 322.85 us | 302.52 us | |
background | wait/io/file/mysys/charset | 3 | 244.35 us | 230.78 us | |
background | wait/io/file/sql/pid | 3 | 13.04 us | 10.76 us | |
background | wait/io/file/sql/misc | 1 | 12.51 us | 12.51 us | |
root | wait/io/file/innodb/innodb_temp_file | 46 | 397.95 ms | 26.71 ms | |
root | wait/io/file/innodb/innodb_data_file | 309 | 281.21 ms | 109.08 ms | |
root | wait/io/file/sql/binlog | 76 | 64.88 ms | 15.06 ms | |
root | wait/io/file/sql/io_cache | 721 | 49.84 ms | 14.58 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 32.37 ms | 6.36 ms | |
root | wait/io/file/csv/metadata | 4 | 413.81 us | 341.30 us | |
root | wait/io/file/sql/binlog_index | 2 | 189.47 us | 187.59 us | |
root | wait/io/file/sql/misc | 3 | 34.10 us | 12.36 us | |
root | wait/io/file/csv/data | 2 | 16.42 us | 10.65 us |
|